Practical application of MySQL FLUSH syntax

This article mainly describes MySQL FLUSH syntax (clear cache) FLUSH flush_option [, flush_option]. If you want to clear MySQL databases using internal cache, you have to use the FLUSH command. To execute FLUSH, you must have the reload permission.

Flush_option can be any of the following:

HOSTS clears the host cache table. If some of your hosts change the IP number, or if you get the error message Host... isblocked, you should clear the Host table. When connecting to the MySQL server, more than max_connect_errors errors occur continuously on a given host. MySQL determines that something is wrong and blocks further connection requests from the host. Clear the host table to allow the host to try again. See 18.2.3 host'... 'isblocked error ).

LOGS closes and then opens the standard and update record files. If you specify an update record file without an extension, the extension number of the new update record file will be 1 higher than that of the previous file.

PRIVILEGES reloads permissions from the MySQL database authorization table.

Close all open TABLES in TABLES.

STATUS resets most STATUS variables to 0.

You can also use the MySQLadmin utility and use the flush-hosts, flush-logs, reload, or flush-tables commands to access each of the preceding commands.

The above content is an introduction to MySQL FLUSH syntax (clear cache). I hope you will find some gains.

The above content is the description of MySQL FLUSH syntax (clear cache), hoping to help you in this aspect.

Original article title: MySQL FLUSH syntax (clear cache)

Connection: http://www.cnblogs.com/window07/archive/2009/11/11/1601102.html