Since it is very unlikely that you lose connection on the socket file, I guess you are using a PHP app, that uses the mysql driver and the problem must be in the driver. I would not look at mysql but at the PHP and PHP2MYSQL layer, mainly at the later one.
Try different PHP (and driver) versions. Claudio 2009/9/9 stutiredboy <stutired...@gmail.com> > 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 >> > > -- Claudio