Re: Lost connection to MySQL server during query
the application program and mysql server are in the same host and i have add skip-name-resolv to the my.cnf and extend the max_allowed_packet from 16M to 32M our application connected to mysql server from mysql.sock before the query which cause lost connection to MySQLserver.. we only ran some sql that create table(s) i have read this article http://dev.mysql.com/doc/refman/5.1/en/gone-away.html and can get rid of the problems this article referred it seems that our problem is similar to this bug: http://lists.mysql.com/commits/9447 http://bugs.mysql.com/bug.php?id=15752 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...@gmail.com mailto:stutired...@gmail.com 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: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=claudio.na...@gmail.com -- Claudio -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Lost connection to MySQL server during query
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: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
how to get the time of the client in sleep status
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
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 (HY000): Got error 124 from storage engine +---+---+--+-+---++ | Field | Type | Null | Key | Default | Extra | +---+---+--+-+---++ | id | bigint(20) unsigned | NO | MUL | NULL | auto_increment | *but when i try another table, the situation is as before, such as table B1,B2,B * mysql select max(id) from loot; +-+ | max(id) | +-+ | 110415 | +-+ 1 row in set (0.00 sec) * the only difference is (*table A the id Field is auto_increment and table B the id is not*): *+---+---+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +---+---+--+-+-+---+ | id | bigint(20) unsigned | NO | MUL | NULL | | *and if i do not use myisampack/myisamchk, all are work fine, *our system is freebsd 7.2, the mysql version is 5.0.84 Server version: 5.0.84 Source distribution * thanks for your reply tiredboy ** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Got error 124 from storage engine
Gavin Towey wrote: Which version of mysql are you using? In mysql 4, you could get away with some differences between the definition of the merge table and the underlying tables. As you've discovered, the structure and index definitions must now be exactly the same, otherwise you will get 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 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 (HY000): Got error 124 from storage engine +---+---+--+-+---++ | Field | Type | Null | Key | Default | Extra | +---+---+--+-+---++ | id | bigint(20) unsigned | NO | MUL | NULL | auto_increment | *but when i try another table, the situation is as before, such as table B1,B2,B * mysql select max(id) from loot; +-+ | max(id) | +-+ | 110415 | +-+ 1 row in set (0.00 sec) * the only difference is (*table A the id Field is auto_increment and table B the id is not*): *+---+---+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +---+---+--+-+-+---+ | id | bigint(20) unsigned | NO | MUL | NULL | | *and if i do not use myisampack/myisamchk, all are work fine, *our system is freebsd 7.2, the mysql version is 5.0.84 Server version: 5.0.84 Source distribution * thanks for your reply tiredboy ** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=gto...@ffn.com The information contained in this transmission may contain privileged and confidential information. It is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. thanks Gavin yes, of course, the structure are exactly the same our mysql Server version: 5.0.84 Source distribution if i do not pack and re creat the index ,everything work fine may be after i myisampack/myisamchk , the index been changed ? thanks all -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org