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]



Reply via email to