8 messages in com.mysql.lists.win32FW: mysqld in hung mode
FromSent OnAttachments
Ilavajuthy Palanisamy05 Jun 2006 12:48 
Ilavajuthy Palanisamy05 Jun 2006 12:52 
Daniel da Veiga05 Jun 2006 13:29 
Ilavajuthy Palanisamy05 Jun 2006 13:45 
Daniel da Veiga05 Jun 2006 14:03 
Ilavajuthy Palanisamy05 Jun 2006 14:09 
Daniel da Veiga05 Jun 2006 14:37 
Shane Bester06 Jun 2006 01:46 
Subject:FW: mysqld in hung mode
From:Ilavajuthy Palanisamy (ipal@consentry.com)
Date:06/05/2006 12:52:56 PM
List:com.mysql.lists.win32

I have enabled debug by executing the command 'mysqladmin debug'.

Now on the .err file I can see lots of prints like 'lock: 0xfa0b8d0:'.

Ila.

________________________________

From: Ilavajuthy Palanisamy Sent: Monday, June 05, 2006 12:49 PM To: MySQL Win32 List Subject: mysqld in hung mode

Hi,

Today our mysqld process is in hung mode. I'm able to connect to mysqld thru mysql client, but none of the commands are going thru.

I tried 'show processlist' and 'select 1' from mysql client, the command just hangs.

In the task manager I can see mysqld in running and its cpu usage as 0.

Any idea why mysqld is in this state?

Is there any command that I can use to see the state of the mysqld?

Ila.