RSS

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 100.100.11.12] 

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

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

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

[error] [client 100.100.21.211]

 

Solution:

FLUSH HOSTS will Free all the connection errors from buffer.

Advertisements
 
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:

WordPress.com Logo

You are commenting using your WordPress.com 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: