Other Administrative Statements | 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. 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 . 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. Note 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 2971