Re: Lost connection to MySQL server during query

2009-09-09 Thread stutiredboy
but, this bug has been fixed in 5.0.25 are there any suggestions ? or any other informaion (s) should i post here? thanks! stutiredboy Claudio Nanni wrote: Can you provide more details? network layout, type of client/app used, connectors,etc,etc? Thanks Claudio 2009/9/9 stutiredboy stutired

Lost connection to MySQL server during query

2009-09-08 Thread stutiredboy
hi,all: we met a problem that: * Lost connection to MySQL server during query SHOW TABLE STATUS WHERE ENGINE='MyISAM' *sometimes it works well, sometimes not our mysql version is 5.0.84 our system is FreeBSD 6.2 thanks -- MySQL General Mailing List For list archives:

how to get the time of the client in sleep status

2009-09-04 Thread stutiredboy
hi,all can i get how long the client(s) in sleep staus after the client connected to mysql server how can i do it ? thanks very much tiredboy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Got error 124 from storage engine

2009-08-25 Thread stutiredboy
hi, all: i have met an question as below: table A1,A2 A1 has been *packed by myisampack, and rebuild the index by myisamchk* A2 is a noraml table, and the struct of A1 and A2 is exactlly same talbe A is the merge table of A1 and A2 while i use: * mysql select max(id) from A; ** ERROR 1030

Re: Got error 124 from storage engine

2009-08-25 Thread stutiredboy
errors. Regards, Gavin Towey -Original Message- From: stutiredboy [mailto:stutired...@gmail.com] Sent: Tuesday, August 25, 2009 12:23 AM To: mysql@lists.mysql.com Subject: Got error 124 from storage engine hi, all: i have met an question as below: table A1,A2 A1 has been *packed