Recently, it happened to me, that the MySQL server has reached the
max_connections limit and therefore did not respond to new clients
Fact is, that I use mod_auth_mysql for authentication with persistent
connections and therefore about 100 connections were lying around
doing nothing, while others couldn't be established.
Although the original problem has been max_connections beeing to low,
I thought it would be a nice idea, to automatically kill the most idle
connection (if there is one), whenever the connection limit is reached
- and of course complain in the error log about it.
At least in my environment, this would have circumvented a complete
What do you thing?
PS: Sorry, if this would be more appropriate on the general discussion