content_image/688824.jpg content_image/688829.jpg
| ENGINE LOGS | ERROR LOGS | GENERAL LOGS | HOSTS | LOGS | PRIVILEGES | OPTIMIZER_COSTS | RELAY LOGS [FOR CHANNEL channel ] | SLOW LOGS | STATUS | USER_RESOURCES } tables_option : { TABLES | TABLES tbl_name  [, tbl_name ] ... | TABLES WITH READ LOCK | TABLES tbl_name  [, tbl_name ] ... WITH READ LOCK | TABLES tbl_name  [, tbl_name ] ... FOR EXPORT } 

The FLUSH  statement has several variant forms that clear or reload various internal caches, flush tables, or acquire locks. Each FLUSH  operation requires the privileges indicated in its description. 

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

## Note 

It is not possible to issue FLUSH  statements within stored functions or triggers. However, you may use FLUSH  in stored procedures, so long as these are not called from stored functions or triggers. See Section 25.8, “Restrictions on Stored Programs” . 

By default, the server writes FLUSH  statements to the binary log so that they replicate to replicas. To suppress logging, specify the optional NO_WRITE_TO_BINLOG  keyword or its alias LOCAL . 

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

## Note 

FLUSH LOGS , FLUSH BINARY LOGS , FLUSH TABLES WITH READ LOCK  (with or without a table list), and FLUSH TABLES tbl_name  ... FOR EXPORT  are not written to the binary log in any case because they would cause problems if replicated to a replica. 

The FLUSH  statement causes an implicit commit. See Section 13.3.3, “Statements That Cause an Implicit Commit” . 

The mysqladmin  utility provides a command-line interface to some flush operations, using commands such as flush-hosts , flush-logs , flush-privileges , flush-status , and flush-tables . See Section 4.5.2, “mysqladmin — A MySQL Server Administration Program” . 

Sending a SIGHUP  or SIGUSR1  signal to the server causes several flush operations to occur that are similar to various forms of the FLUSH  statement. Signals can be sent by the root  system account or the system account that owns the server process. This enables the flush operations to be performed without having to connect to the server, which requires a MySQL account that has privileges sufficient for those operations. See Section 4.10, “Unix Signal Handling in MySQL” . 

The RESET  statement is similar to FLUSH . See Section 13.7.8.6, “RESET Statement” , for information about using RESET  with replication. 

The following list describes the permitted FLUSH  statement flush_option  values. For descriptions of the permitted tables_option  values, see FLUSH TABLES Syntax. 

• FLUSH BINARY LOGS 

