Notice
The current version only supports this keyword syntax, but the functionality does not take effect.
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 tenant-level hidden parameter _enable_mock_stmt_flush_table, the FLUSH TABLE syntax does not return an error. If you disable this parameter, the statement returns NOT SUPPORT.
You can execute the following command to enable this parameter:
ALTER SYSTEM SET _enable_mock_stmt_flush_table = true;