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=gcdmg-mysql-2@m.gmane.org
--000fea7959dddc78e70473213218
Content-Type: text/plain; charset=ISO-8859-1
Can you provide more details?
network layout, type of client/app used, connectors,etc,etc?
Thanks
Claudio
2009/9/9 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: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=claudio.nanni@gmail.com
>
>
--
Claudio
--000fea7959dddc78e70473213218--
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
>
> 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.nanni@gmail.com
>
>
>
>
> --
> Claudio
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org
--00c09ffb56dd08c8a6047321b70b
Content-Type: text/plain; charset=ISO-8859-1
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
> 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
>>
>> 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.nanni@gmail.com
>>
>>
>>
>>
>> --
>> Claudio
>>
>
>
--
Claudio
--00c09ffb56dd08c8a6047321b70b--