Re: FW: mysqld in hung mode
"Daniel da Veiga" <[email protected]>
| Newsgroups | gmane.comp.db.mysql.windows |
|---|---|
| Message-ID | <[email protected]> |
On 6/5/06, Ilavajuthy Palanisamy <[email protected]> wrote: > 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? > I've only seen this kind of behavior when a memory corruption occured on my machine, and also once in an old version (<4.1.12), if that's your case, you should upgrade to the latest version of your brand. -- 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]