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/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
