RE: FW: mysqld in hung mode

I have already verified the machine state.
I have ample amount of disk space and memory. Looks like all the system
resources are in good condition.

Surely if I restart mysql, it will start working fine.
But, I need to find out how to recover from this state or what this
state is so that I can avoid getting into this state.

Through mysqladmin kill command I have killed all the pending queries
(these queries are executed due to mysqldump command and they were stuck
up in 'Opening tables' state). After killing all the queries are in
Killed state and they are not going away. 

Any idea under which circumstances mysql will go into this kind of
state?

Ila.


-----Original Message-----
From: Daniel da Veiga [mailto:[email protected]] 
Sent: Monday, June 05, 2006 1:30 PM
To: MySQL Win32 List
Subject: Re: FW: mysqld in hung mode

On 6/5/06, Ilavajuthy Palanisamy <[email protected]> wrote:
> 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.
>

Ok, this is just a guess, but have you checked your OS state? I mean
memory, filesystem, disk space and resources in general. After that,
try restarting MySQL and see how it behaves. It doesn't look good, so,
back it up and I hope you have previous backups also.

Post back when you finish please.

-- 
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------

-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:
http://lists.mysql.com/[email protected]


-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/[email protected]