All,
We are experiencing a strange problem where one minute everything is running fine on mysql, then the next minute, all queries seem to lockup. Can anybody provide guidance to me so I can determine the cause of the lockups? So far I dump the proc logs every minute via cron. I have found that the proclog before the "lockup" shows about 100 open connections to database in sleep (1 or 2 actually doing work). Then the proclog from a minute later when the lockup is in progress shows almost every connection in query. These lockups appear to be intermittent and I do not see anything in common from one proclog to the next. We are running mysql v3.23.49 on Solaris 5.7. Kevin --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php