MySQL FLUSH Commands

mysql> REBOOT PRIVILEGES;

when we give authorization to a user, running the command reboot privileges will refresh the authorization tables in the MySQL database allowing the changes to take effect without reloading or restarting the MySQL service.

Refresh TABLES

mysql> REFRESH TABLES;
The command closes all tables that are currently open or in use. And clears cache which in turn improves the utilization of available memory.

Reinitialize HOSTS

mysql> REINITIALIZE HOSTS;

The command uses host cache tables, if the maximum number of connections has been reached for a particular host, the MySQL server will not be able to establish new connections. Flushing host tables resets the process and allows connections for the particular HOST again.

Recycle LOGS

mysql> RECYCLE LOGS;
The command closes and reopens all log files; if log files are too large and are taking more time to load, you can run the command which will create an empty log file.