Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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.

share|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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.