FW: mysqld in hung mode

"Ilavajuthy Palanisamy" <[email protected]>
Newsgroups gmane.comp.db.mysql.windows
Message-ID <52BBA75459915749B68F93B604B636CD0171739C@neptune.TidalNetworks.net>
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.
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.