SHOW [GLOBAL|SESSION] STATUS
SHOW [GLOBAL|SESSION] STATUS
语句用于提供 MySQL 兼容性。对于大部分监控指标,TiDB 使用 Prometheus 和 Grafana 来集中收集,而不是使用 SHOW STATUS
。
该语句输出中各变量的详细介绍,请参考服务器状态变量。
语法图
- ShowStatusStmt
- Scope
- ShowLikeOrWhere
ShowStatusStmt ::=
'SHOW' Scope? 'STATUS' ShowLikeOrWhere?
Scope ::=
( 'GLOBAL' | 'SESSION' )
ShowLikeOrWhere ::=
"LIKE" SimpleExpr
| "WHERE" Expression
示例
SHOW SESSION STATUS;
+-------------------------------+--------------------------------------+
| Variable_name | Value |
+-------------------------------+--------------------------------------+
| Compression | OFF |
| Compression_algorithm | |
| Compression_level | 0 |
| Ssl_cipher | |
| Ssl_cipher_list | |
| Ssl_server_not_after | |
| Ssl_server_not_before | |
| Ssl_verify_mode | 0 |
| Ssl_version | |
| Uptime | 1409 |
| ddl_schema_version | 116 |
| last_plan_binding_update_time | 0000-00-00 00:00:00 |
| server_id | 61160e73-ab80-40ff-8f33-27d55d475fd1 |
+-------------------------------+--------------------------------------+
13 rows in set (0.00 sec)
SHOW GLOBAL STATUS;
+-----------------------+--------------------------------------+
| Variable_name | Value |
+-----------------------+--------------------------------------+
| Ssl_cipher | |
| Ssl_cipher_list | |
| Ssl_server_not_after | |
| Ssl_server_not_before | |
| Ssl_verify_mode | 0 |
| Ssl_version | |
| Uptime | 1413 |
| ddl_schema_version | 116 |
| server_id | 61160e73-ab80-40ff-8f33-27d55d475fd1 |
+-----------------------+--------------------------------------+
9 rows in set (0.00 sec)
MySQL 兼容性
SHOW [GLOBAL|SESSION] STATUS
语句与 MySQL 兼容。