mysql error value

razzera · 01-17-2011, 04:26 PM

Hello

I sometimes get my webserver blocked by my mysql server because of "to many connection errors" and have to use flush hosts to solve it, i now wonder if there is any way to increese that connection error value so the webserver wont get blocked ?

harry edwards · 01-17-2011, 05:32 PM

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.