Understandable. The state, command and info values from `show processlist` could shed some light on what is occurring.


Paul Smith wrote:

%% Victor Pendleton <[EMAIL PROTECTED]> writes:

 vp> What state are the queries in while they are hung? What command or
 vp> SQL are they executing?

Unfortunately I lost the output of the processlist command.  Whenever
the server hangs it's always a crazy race to get it back up again.

Next time it happens I'll be sure to stow the list somewhere before
restarting the server.  However, IIRC there were a mix of queries: some
were Wait, some were Sleep.





--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to