m == mich...@tufts.edu writes:

m> Brandon Metcalf wrote:

m> > We are running 3.23.58 on Solaris 8 and seeing the following problem. m> > Periodically, mysqld gets into a state where we can't query just one m> > table in all of our DBs--queries just hang. Restarting mysqld always m> > fixes the problem, but a SIGKILL is required to stop it. m> Have you tried show processlist while this is happening? We've had this m> happen and most often it's someone or some script running a query with a m> missing join and killing the query fixes the problem.

I just sent a reply to another message on this that contains the processlist. I don't see anything amiss, but maybe you do?

m> > Could this be something is corrupt in this particular table? Would m> > dumping this DB and reloading it help? m> Does check table indicate any problems?

No, no problems.