Other Administrative Statements 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” ). 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” . 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  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 . • FLUSH STATUS • FLUSH USER_RESOURCES FLUSH TABLES Syntax Note • FLUSH TABLES • FLUSH TABLES  tbl_name  [,  tbl_name ] ... Closes all open tables, forces all tables in use to be closed, and flushes the prepared statement cache. For information about prepared statement caching, see Section 8.10.3, “Caching of Prepared Statements and Stored Programs” . This operation requires the  FLUSH_TABLES  or  RELOAD  privilege. 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. 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. 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. 2974