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 ...
Get MySQL in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.