系统表介绍
global_status 描述了会话各状态的值
| 列名 | 含义 |
|---|---|
| VARIABLE_NAME | 状态名称 |
| VARIABLE_VALUE | 状态值 |
实例
mysql> select * from global_status limit 10 ;
+----------------------------+----------------+
| VARIABLE_NAME | VARIABLE_VALUE |
+----------------------------+----------------+
| Aborted_clients | 1 |
| Aborted_connects | 0 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 0 |
| Binlog_stmt_cache_disk_use | 0 |
| Binlog_stmt_cache_use | 0 |
| Bytes_received | 85024 |
| Bytes_sent | 601661 |
| Com_stmt_reprepare | 0 |
| Connection_errors_accept | 0 |
+----------------------------+----------------+
10 rows in set (0.01 sec)