MySQL in a Nutshell

Name

FLUSH

Synopsis

FLUSH [LOCAL|NO_WRITE_TO_BINLOG] option[,  . . . ]

Options:

DES_KEY_FILE, HOSTS, LOGS, PRIVILEGES, QUERY_CACHE,
STATUS, TABLE, TABLES, TABLES WITHOUT READ LOCK, USER_RESOURCES

Use this statement to clear temporary caches in MySQL. It requires RELOAD privileges. To prevent this statement from writing to the binary log file, the NO_WRITE_TO_BINLOG flag or its LOCAL alias may be given. The cache may be given as an option to the statement to be flushed. Multiple options may be given in a comma-separated list:

DES_KEY_FILE

Reloads the DES encryption file.

HOSTS

Clears the hosts cache, which is used to minimize host/IP address lookups. The hosts cache may need to be flushed if a host has been blocked from accessing the server.

LOGS

Used to close all of the logfiles and reopen them.

PRIVILEGES

Reloads the grant table for users. This is necessary if the user table in the mysql database is modified manually, without a GRANT statement.

QUERY CACHE

Instructs the server to defragment the query cache.

STATUS

Resets the various status variables.

TABLE

Followed by one or more table names, forces the given tables to be closed. This will terminate any active queries on the given tables.

TABLES

Causes all tables to be closed, all queries to be terminated, and the query cache will be flushed, as well. This is the same as TABLE with no table name.

TABLES WITH READ LOCK

Closes all tables and locks them with a read lock. This will allow users to view the data, but not to update it or ...