Random “Lost connection to MySQL server at 'reading initial communication packet', system error: 0”

Posted by user1606545 on Server Fault See other posts from Server Fault or by user1606545
Published on 2012-08-17T15:47:56Z Indexed on 2012/09/25 15:39 UTC
Read the original article Hit count: 225

Filed under:
|

Sometimes I get the error from MYSQL server:

Lost connection to MySQL server at 'reading initial communication packet', system error: 0 

I cannot find the cause, since most of the time it works, but every week for some hours I get this error. I googled, but there seem to be only users which have this error permanently. But in this case, it only occurs sometimes. I checked hosts.allow and hosts.deny, but the host is allowed and not denied.

Also sometimes I get the error:

File './database/table.MYD' not found (Errcode: 24) 

It occurs very rarely. But it occurs for some hours once a week, sometimes on multiple days, but suddenly the problem disappears again. I have checked the open files limit. It's 2048 and should be absolutely enough. I also tried to increase the number of open files nevertheless, but no effect. I thought, perhaps the process does not close some tables. But this is impossible, because after a while everythings o.k. again and the process opens maximum 100 tables at once. I also checked the MySQL-runtime-environment, and there were 930 opened files. I cannot explain that. After a while it's 129.

I am running a MySQL-Server on a SUSE-Linux machine. I connect to the MySQL-Server from another host by the command line tool "mysql" and by MySQL-C-connector. The MySQL-Server is version 5.0.67.

© Server Fault or respective owner

Related posts about networking

Related posts about mysql