FLUSH

FLUSH

FLUSH flush_option [,flush_option] ...

The flush_option can be any of the following:

DES_KEY_FILE HOSTS LOGS QUERY CACHE PRIVILEGES STATUS TABLES [TABLE | TABLES] table_name [,table_name...] TABLES WITH READ LOCK USER_RESOURCES 

Flushing the DES_KEY_FILE reloads the DES keys. With the HOSTS option, the host's cache is emptied (which you use after changing IP addresses, for example). Flushing the LOGS closes and reopens log files and increments the binary log. Flushing the QUERY CACHE defragments the query cache. Flushing the PRIVILEGES reloads the permission tables from the mysql database. Flushing the STATUS resets the status variables. Flushing the TABLES is the same as flushing the QUERY CACHE, but it also closes all open tables. You can specify only certain tables to flush. You can place a READ LOCK on the tables, which is useful for locking a group of tables for backup purposes. Flushing the USER_RESOURCES resets user resources (used for limiting queries, connections, and updates per hour).



Mastering MySQL 4
Mastering MySQL 4
ISBN: 0782141625
EAN: 2147483647
Year: 2003
Pages: 230
Authors: Ian Gilfillan

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net