9 messages in com.mysql.lists.mysqlRe: DB hanging
FromSent OnAttachments
Brandon Metcalf25 May 2004 12:33 
Victor Pendleton25 May 2004 12:45 
Brandon Metcalf25 May 2004 12:56 
Michael Kruckenberg25 May 2004 12:58 
Brandon Metcalf25 May 2004 13:05 
Victor Pendleton25 May 2004 13:23 
Brandon Metcalf25 May 2004 13:35 
Victor Pendleton25 May 2004 13:43 
Jon Drukman25 May 2004 16:33 
Subject:Re: DB hanging
From:Jon Drukman (js@cluttered.com)
Date:05/25/2004 04:33:10 PM
List:com.mysql.lists.mysql

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.

Could this be something is corrupt in this particular table? Would dumping this DB and reloading it help?

this happens to me without fail on Linux if i set max connections or table cache too large. i get "Error in accept: too many open files" in the mysql error log and then the db hangs as you describe, requiring a SIGKILL to get it back.

make sure you run myisamchk after killing though - you never know how messed up your tables are.

-jsd-