FLUSH TABLE

Purpose

You can execute this statement to clear or refresh specific internal caches, logs, and tables.

Syntax

FLUSH [NO_WRITE_TO_BINLOG | LOCAL] { tables_option }

tables_option: {
    table_synonym
  | table_synonym tbl_name [, tbl_name] ...
  | table_synonym WITH READ LOCK
  | table_synonym tbl_name [, tbl_name] ... WITH READ LOCK
  | table_synonym tbl_name [, tbl_name] ... FOR EXPORT
}

table_synonym: {
    TABLE
  | TABLES
}

Considerations

After you enable the tenant-level hidden parameter _enable_mock_stmt_flush_table, the FLUSH TABLE statement will not return an error. If the parameter is disabled, the statement returns NOT SUPPORT.

You can execute the following statement to enable the hidden parameter:

ALTER SYSTEM SET _enable_mock_stmt_flush_table = true;