MySql Flush Hosts

16 Aug

I got a below connection error recently on our server,  but resolved after certain attempts. FLUSH Hosts is the command where it Flush out the connection errors and allow MySql to connect again.

[Tue Jun 01 16:07:10 2010] [error] [client] 

DBI connect('host:database:port;mysql_connect_timeout=10','web',...)

failed: Host '' is blocked because of many connection errors;

unblock with 'mysqladmin flush-hosts' at [Tue Jun 01 16:07:10 2010]

[error] [client]



FLUSH HOSTS will Free all the connection errors from buffer.

Leave a comment

Posted by on August 16, 2010 in Database Administration, MySql


Tags: ,

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: