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.