SHOW [GLOBAL|SESSION] 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

ShowStmt:

ShowStmt

ShowTargetFilterable:

ShowTargetFilterable

GlobalScope:

GlobalScope

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)

MySQL compatibility

  • This statement is included only for compatibility with MySQL.

See also