Skip to content

Latest commit

 

History

History
61 lines (45 loc) · 2.2 KB

sql-statement-show-status.md

File metadata and controls

61 lines (45 loc) · 2.2 KB
Raw
title summary aliases
SHOW [GLOBAL|SESSION] STATUS | TiDB SQL Statement Reference
An overview of the usage of SHOW [GLOBAL|SESSION] STATUS for the TiDB database.
/docs/dev/sql-statements/sql-statement-show-status/
/docs/dev/reference/sql/statements/show-status/

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

mysql> 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)

mysql> 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)

MySQL compatibility

  • This statement is included only for compatibility with MySQL.

See also