TiDBTiDB Docs Dash 2024

Jan 9 - Jan 12 (UTC)
Join us to improve docs and win a prize!
Sign InTry Free

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

Was this page helpful?

Download PDFRequest docs changesAsk questions on Discord
Playground
New
One-stop & interactive experience of TiDB's capabilities WITHOUT registration.
Products
TiDB
TiDB Dedicated
TiDB Serverless
Pricing
Get Demo
Get Started
© 2024 PingCAP. All Rights Reserved.
Privacy Policy.