FLUSH STATUS

FLUSH STATUS 语句用于提供 MySQL 兼容性,但在 TiDB 上并无作用。因为 TiDB 使用 Prometheus 和 Grafana 而非 SHOW STATUS 来进行集中度量收集。

语法图

FlushStmt
FLUSHNoWriteToBinLogAliasOptFlushOption
NoWriteToBinLogAliasOpt
NO_WRITE_TO_BINLOGLOCAL
FlushOption
PRIVILEGESSTATUSTIDBPLUGINSPluginNameListHOSTSLogTypeOptLOGSTableOrTablesTableNameListOptWithReadLockOpt

示例

show status;
+--------------------+--------------------------------------+ | Variable_name | Value | +--------------------+--------------------------------------+ | Ssl_cipher_list | | | server_id | 93e2e07d-6bb4-4a1b-90b7-e035fae154fe | | ddl_schema_version | 141 | | Ssl_verify_mode | 0 | | Ssl_version | | | Ssl_cipher | | +--------------------+--------------------------------------+ 6 rows in set (0.01 sec)
show global status;
+--------------------+--------------------------------------+ | Variable_name | Value | +--------------------+--------------------------------------+ | Ssl_cipher | | | Ssl_cipher_list | | | Ssl_verify_mode | 0 | | Ssl_version | | | server_id | 93e2e07d-6bb4-4a1b-90b7-e035fae154fe | | ddl_schema_version | 141 | +--------------------+--------------------------------------+ 6 rows in set (0.00 sec)
flush status;
Query OK, 0 rows affected (0.00 sec)
show status;
+--------------------+--------------------------------------+ | Variable_name | Value | +--------------------+--------------------------------------+ | Ssl_cipher | | | Ssl_cipher_list | | | Ssl_verify_mode | 0 | | Ssl_version | | | ddl_schema_version | 141 | | server_id | 93e2e07d-6bb4-4a1b-90b7-e035fae154fe | +--------------------+--------------------------------------+ 6 rows in set (0.00 sec)

MySQL 兼容性

  • FLUSH STATUS 语句与 MySQL 兼容。

另请参阅