Daevid Vincent wrote:
> Is there a way to disable this 'max_connect_errors' thing?
> 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"?
> 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.
Create online surveys at http://www.surveyz.com/