up vote 0 down vote favorite
share [g+] share [fb]

I'm running into an odd error with my current mysql version 5.0.32-Debian_7etch8

My MySQL server is running on it's own hardware. Connected to it are 3 apache web servers. Everything works fine up until I hit about 300 to 320 active connections from the web servers. At that point the sever start's throwing the following error:

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

In the research I've done it all I can find out about system error 0 is that it occures when a host is not allowed. But I can't think of a reason that would cause allowed status to be revoked based on the number of connections.

I've gradually tripled the value of max_connections but it hasn't had any effect. If anyone has any ideas I'd be very grateful.

link|improve this question
Have you checked logs on the mysql box? Checked load / active connections? Mysql log should show you a bit more detail. – Jakub Feb 8 '11 at 19:32
An update to the mysql_common package seems to have solved my issue even though previous updates have not. I'm going to leave the question open for a time to make sure the server gremlins aren't just on their coffee break. – Bishma Feb 8 '11 at 21:21
feedback

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
or
required, but never shown
discard

Browse other questions tagged or ask your own question.