Brandon Metcalf wrote:
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.
Have you tried show processlist while this is happening? We've had this
happen and most often it's someone or some script running a query with a
missing join and killing the query fixes the problem.
Could this be something is corrupt in this particular table? Would
dumping this DB and reloading it help?
Does check table indicate any problems?
http://dev.mysql.com/doc/mysql/en/CHECK_TABLE.html
Mike
--
http://mike.kruckenberg.com | michael at kruckenberg.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]