List:General Discussion« Previous MessageNext Message »
From:Sasha Pachev Date:March 5 2004 6:20pm
Subject:Re: How can I disable 'max_connect_errors'?
View as plain text  
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/
Thread
How can I disable 'max_connect_errors'?Daevid Vincent5 Mar
  • Re: How can I disable 'max_connect_errors'?Sasha Pachev5 Mar