FLUSH TABLE

Purpose

This statement is used 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 hidden tenant-level parameter _enable_mock_stmt_flush_table, the FLUSH TABLE syntax will not return an error. If you disable this parameter, the statement will return a NOT SUPPORT error.

You can execute the following command to enable this parameter:

ALTER SYSTEM SET _enable_mock_stmt_flush_table = true;