Daevid Vincent wrote:
> Is there a way to disable this 'max_connect_errors' thing?
> http://www.mysql.com/doc/en/Blocked_host.html
>
> Tried "max_connect_errors=0" but then it shows up as "max_connect_errors=1"
>
> What is the 'max' that this value can be in case?
> We have it set to 10,000 now, but that only buys us time.
>
> When is this counter reset?
on FLUSH HOSTS
> Is it ongoing until a "FLUSH HOSTS"?
yes
> Is it until mysql is restarted?
it does also reset on restart
To disable for practical purposes, set it to 2^32-1 = 4294967295. On top, once a
day run FLUSH HOSTS
At the same time try to figure out why you are getting so many of them.
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
