There are two setting in MySQL configuration file. These are max_connections and max_user_connections. The default for the first is about 150 and the second is unlimited. So, if you have the defaults set your should really address why so many connections are being used. Are the sessions being closed correctly?
There is also max_connection_errors which default to 10.
Last edited by harry edwards; 01-17-2011 at 06:33 PM.
|