GNU Info

(mysql.info)FLUSH

---

Next: KILL Prev: ANALYZE TABLE Up: Database Administration

---

Enter node , (file) or (file)node

`FLUSH' Syntax
--------------

     FLUSH flush_option [,flush_option]

You should use the `FLUSH' command if you want to clear some of the
internal caches MySQL uses.  To execute `FLUSH', you must have the
*RELOAD* privilege.

`flush_option' can be any of the following:

`HOSTS'     Empties the host cache tables.  You should flush the host
            tables if some of your hosts change IP number or if you get
            the error message `Host ... is blocked'.  When more than
            `max_connect_errors' errors occur in a row for a given host
            while connection to the MySQL server, MySQL assumes
            something is wrong and blocks the host from further
            connection requests.  Flushing the host tables allows the
            host to attempt to connect again. Note: Blocked host.) You
            can start `mysqld' with `-O max_connection_errors=999999999'
            to avoid this error message.
`LOGS'      Closes and reopens all log files.  If you have specified the
            update log file or a binary log file without an extension,
            the extension number of the log file will be incremented by
            one relative to the previous file.  If you have used an
            extension in the file name, MySQL will close and reopen the
            update log file.  Note: Update log. This is the same thing
            as sending the `SIGHUP' signal to the `mysqld' server.
`PRIVILEGES'Reloads the privileges from the grant tables in the `mysql'
            database.
`TABLES'    Closes all open tables and force all tables in use to be
            closed.
`[TABLE |   Flushes only the given tables.
TABLES]     
table_name  
[,table_name...]'
`TABLES     Closes all open tables and locks all tables for all
WITH READ   databases with a read until one executes `UNLOCK TABLES'.
LOCK'       This is very convenient way to get backups if you have a
            file system, like Veritas,that can take snapshots in time.
`STATUS'    Resets most status variables to zero. This is something one
            should only use when debugging a query.

You can also access each of the commands shown above with the
`mysqladmin' utility, using the `flush-hosts', `flush-logs', `reload',
or `flush-tables' commands.

Take also a look at the `RESET' command used with replication. Note:
Replication SQL.