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
