系统表介绍
status_by_thread 记录了活动每个会话的状态变量
| 列名 | 含义 |
|---|---|
| THREAD_ID | 线程编号 |
| VARIABLE_NAME | 变量名 |
| VARIABLE_VALUE | 变量值 |
实例
mysql> select * from status_by_thread limit 10 ;
+-----------+-------------------------+----------------+
| THREAD_ID | VARIABLE_NAME | VARIABLE_VALUE |
+-----------+-------------------------+----------------+
| 38 | Bytes_received | 4896 |
| 38 | Bytes_sent | 223214 |
| 38 | Com_stmt_reprepare | 0 |
| 38 | Compression | OFF |
| 38 | Created_tmp_disk_tables | 11 |
| 38 | Created_tmp_tables | 13 |
| 38 | Handler_commit | 0 |
| 38 | Handler_delete | 0 |
| 38 | Handler_discover | 0 |
| 38 | Handler_external_lock | 50 |
+-----------+-------------------------+----------------+
10 rows in set (0.01 sec)