Strange flood of connections to mysql server
We have recently upgraded our mysql server from v4.3 to the "hyper-modern"* 5.0.77 and on occasion are seeing a sudden flood of connections which takes our server down.
These connections are from the expected IP (our firewall) and all for "unauthenticated user" and they remain in the login state for several minutes at least.
We have two apache web servers on different physical machines throwing connections at the server. They are configured such that even if they throw their maximum number at the DB it shouldn't be overwhelmed.
There is nothing to indicate this activity in the database or web server logs.
We are having occasional issues with our ad servers taking a very long time to respond so we have identified a couple of possibilities:
1. Ad taking a long time so everyone pressing F5 several times
2. D.o.S. attack
Has anyone encountered this before and if so, how did you fix it?
Thanks for any insights
* For here at least