What does show processlist return when this is happening? Is anything being
logged to the error log?
-----Original Message-----
From: Brandon Metcalf
To: mysql@stripped
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/mysql?unsub=1
