m == [EMAIL PROTECTED] 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]