系统表介绍
session_status 描述了全局各状态的值
相对于Information_schema的同名表,Performance_schema 中的表不包含Com_XXX的视图
| 列名 | 含义 |
|---|---|
| VARIABLE_NAME | 状态名称 |
| VARIABLE_VALUE | 状态值 |
实例
mysql> select * from session_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 | 3532 |
| Bytes_sent | 171688 |
| Com_stmt_reprepare | 0 |
| Compression | OFF |
+----------------------------+----------------+
10 rows in set (0.01 sec)