What does show processlist return when this is happening? Is anything being logged to the error log?
-----Original Message----- From: Brandon Metcalf To: [EMAIL PROTECTED] Sent: 5/25/04 2:33 PM Subject: DB hanging We are running 3.23.58 on Solaris 8 and seeing the following problem. Periodically, mysqld gets into a state where we can't query just one table in all of our DBs--queries just hang. Restarting mysqld always fixes the problem, but a SIGKILL is required to stop it. Could this be something is corrupt in this particular table? Would dumping this DB and reloading it help? Thanks. -- Brandon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]