m == michael.kruckenberg@stripped 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.
--
Brandon
