FLUSH TABLE

tip

The syntax of this statement is supported in the current version, but the statement does not take effect.

Description

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
}

Usage

After you enable the hidden configuration item _enable_mock_stmt_flush_table, the FLUSH TABLE statement does not return an error. If you disable this configuration item, the statement returns NOT SUPPORT.

You can execute the following command to enable this configuration item:

ALTER SYSTEM SET _enable_mock_stmt_flush_table = true;