FLUSH STATUS

This statement is included for compatibility with MySQL. It has no effect on TiDB, which uses Prometheus and Grafana for centralized metrics collection instead of SHOW STATUS.

Synopsis

FlushStmt

FLUSH STATUS - 图1

NoWriteToBinLogAliasOpt

FLUSH STATUS - 图2

FlushOption

FLUSH STATUS - 图3

  1. FlushStmt ::=
  2.     'FLUSH' NoWriteToBinLogAliasOpt FlushOption
  4. NoWriteToBinLogAliasOpt ::=
  5.     ( 'NO_WRITE_TO_BINLOG' | 'LOCAL' )?
  7. FlushOption ::=
  8.     'PRIVILEGES'
  9. |   'STATUS'
  10. |    'TIDB' 'PLUGINS' PluginNameList
  11. |    'HOSTS'
  12. |   LogTypeOpt 'LOGS'
  13. |   TableOrTables TableNameListOpt WithReadLockOpt

Examples

  1. mysql> show status;
  2. +--------------------+--------------------------------------+
  3. | Variable_name      | Value                                |
  4. +--------------------+--------------------------------------+
  5. | Ssl_cipher_list    |                                      |
  6. | server_id          | 93e2e07d-6bb4-4a1b-90b7-e035fae154fe |
  7. | ddl_schema_version | 141                                  |
  8. | Ssl_verify_mode    | 0                                    |
  9. | Ssl_version        |                                      |
  10. | Ssl_cipher         |                                      |
  11. +--------------------+--------------------------------------+
  12. 6 rows in set (0.01 sec)
  14. mysql> show global status;
  15. +--------------------+--------------------------------------+
  16. | Variable_name      | Value                                |
  17. +--------------------+--------------------------------------+
  18. | Ssl_cipher         |                                      |
  19. | Ssl_cipher_list    |                                      |
  20. | Ssl_verify_mode    | 0                                    |
  21. | Ssl_version        |                                      |
  22. | server_id          | 93e2e07d-6bb4-4a1b-90b7-e035fae154fe |
  23. | ddl_schema_version | 141                                  |
  24. +--------------------+--------------------------------------+
  25. 6 rows in set (0.00 sec)
  27. mysql> flush status;
  28. Query OK, 0 rows affected (0.00 sec)
  30. mysql> show status;
  31. +--------------------+--------------------------------------+
  32. | Variable_name      | Value                                |
  33. +--------------------+--------------------------------------+
  34. | Ssl_cipher         |                                      |
  35. | Ssl_cipher_list    |                                      |
  36. | Ssl_verify_mode    | 0                                    |
  37. | Ssl_version        |                                      |
  38. | ddl_schema_version | 141                                  |
  39. | server_id          | 93e2e07d-6bb4-4a1b-90b7-e035fae154fe |
  40. +--------------------+--------------------------------------+
  41. 6 rows in set (0.00 sec)

MySQL compatibility

  • This statement is compatible with MySQL.

See also