List:General Discussion« Previous MessageNext Message »
From:Mary Bahrami Date:September 9 2008 4:07pm
Subject:RE: Using Flush Hosts in cron
View as plain text  
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:werner@stripped] 
Sent: Tuesday, September 09, 2008 8:49 AM
To: mysql@stripped
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/mysql?unsub=1

Thread
Using Flush Hosts in cronHank9 Sep
  • Re: Using Flush Hosts in cronWerner D.9 Sep
    • RE: Using Flush Hosts in cronMary Bahrami9 Sep
Re: Using Flush Hosts in cronWerner D.9 Sep