Re: FW: mysqld in hung mode
"Daniel da Veiga" <[email protected]>
| Newsgroups | gmane.comp.db.mysql.windows |
|---|---|
| Message-ID | <[email protected]> |
Well my friend, my last shot would be to extend check and repair, rebuilding indexes from scratch. Windows is used to inconsistencies like that. On 6/5/06, Ilavajuthy Palanisamy <[email protected]> wrote: > The version that we are using is 'Server version 4.1.15-log'. > > > > -----Original Message----- > From: Daniel da Veiga [mailto:[email protected]] > Sent: Monday, June 05, 2006 2:04 PM > To: MySQL Win32 List > Subject: Re: FW: mysqld in hung mode > > 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] > > -- 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]