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
