content_image/752960.jpg
This operation has no effect on tables used for the slow query log (see Section 5.4.1, “Selecting General Query Log and Slow Query Log Output Destinations” ). 

## • FLUSH STATUS 

Flushes status indicators. 

This operation requires the FLUSH_STATUS  or RELOAD  privilege. 

This operation adds the session status from all active sessions to the global status variables, resets the status of all active sessions, and resets account, host, and user status values aggregated from disconnected sessions. See Section 27.12.15, “Performance Schema Status Variable Tables” . This information may be of use when debugging a query. See Section 1.6, “How to Report Bugs or Problems” . 

## • FLUSH USER_RESOURCES 

Resets all per-hour user resource indicators to zero. 

This operation requires the FLUSH_USER_RESOURCES  or RELOAD  privilege. 

Resetting resource indicators enables clients that have reached their hourly connection, query, or update limits to resume activity immediately. FLUSH USER_RESOURCES  does not apply to the limit on maximum simultaneous connections that is controlled by the max_user_connections  system variable. See Section 6.2.20, “Setting Account Resource Limits” . 

## FLUSH TABLES Syntax 

FLUSH TABLES  flushes tables, and, depending on the variant used, acquires locks. Any TABLES  variant used in a FLUSH  statement must be the only option used. FLUSH TABLE  is a synonym for FLUSH TABLES . 

<img src='content_image/752960.jpg'>

## • FLUSH TABLES 

## Note 

The descriptions here that indicate tables are flushed by closing them apply differently for InnoDB , which flushes table contents to disk but leaves them open. This still permits table files to be copied while the tables are open, as long as other activity does not modify them. 

Closes all open tables, forces all tables in use to be closed, and flushes the prepared statement cache. 

This operation requires the FLUSH_TABLES  or RELOAD  privilege. 

For information about prepared statement caching, see Section 8.10.3, “Caching of Prepared Statements and Stored Programs” . 

FLUSH TABLES  is not permitted when there is an active LOCK TABLES ... READ . To flush and lock tables, use FLUSH TABLES tbl_name  ... WITH READ LOCK  instead. 

## • FLUSH TABLES tbl_name  [, tbl_name ] ... 

With a list of one or more comma-separated table names, this operation is like FLUSH TABLES  with no names except that the server flushes only the named tables. If a named table does not exist, no error occurs. 

