Flush Hosts – MySQL

The FLUSH statement can be used to clean or reload various internal caches, flush tables, or acquire locks. Flush means reset.

MySQL will clear the host cache when you use FLUSH HOSTS, which effectively implies MySQL’s record of which hosts are now or have recently connected is reset, allowing you to connect to those hosts again.

In other words, The command uses host cache tables; if the maximum number of connections for a certain host has been reached, mysql server will be unable to initiate new connections. Flushing host tables restarts the process and re-allows connections to specific HOSTs.


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 )

Connecting to %s