What can I check to see whether I'm about to have a host blocked? Anything in mysql or the OS?
I'd like to know about it before I get a phone call, and I don't want to proactively flush hosts or increase max_connection_errors. -----Original Message----- From: Werner D. [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 09, 2008 8:49 AM To: mysql@lists.mysql.com Subject: Re: Using Flush Hosts in cron Hank schrieb: > I have the blocked connection problem between three of my servers, all > behind two firewalls and on one switch. > > Occaisionally the mysql servers start blocking the hosts. > > What's the downside to running a "Flush hosts" once per minute on these > mysql servers? better solution: increases max_connect_errors if you are sure, that there ist really no network-problem e.g. --max_connect_errors=100000 Werner -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
