系统表介绍
status_by_account 展示每个访客的状态信息
列名 | 含义 |
---|---|
USER | 用户名 |
HOST | 客户端IP |
VARIABLE_NAME | 变量名 |
VARIABLE_VALUE | 变量值 |
实例
mysql> select * from status_by_account ;
+------+-----------+-------------------------------+----------------+
| USER | HOST | VARIABLE_NAME | VARIABLE_VALUE |
+------+-----------+-------------------------------+----------------+
| NULL | NULL | Bytes_received | 164 |
| NULL | NULL | Bytes_sent | 157 |
| NULL | NULL | Com_stmt_reprepare | 0 |
| NULL | NULL | Created_tmp_disk_tables | 0 |
| NULL | NULL | Created_tmp_tables | 0 |
| NULL | NULL | Handler_commit | 0 |
| NULL | NULL | Handler_delete | 0 |
| NULL | NULL | Handler_discover | 0 |
| NULL | NULL | Handler_external_lock | 0 |
| NULL | NULL | Handler_mrr_init | 0 |
| NULL | NULL | Handler_prepare | 0 |
| NULL | NULL | Handler_read_first | 0 |
| NULL | NULL | Handler_read_key | 0 |
| NULL | NULL | Handler_read_last | 0 |
| NULL | NULL | Handler_read_next | 0 |
| NULL | NULL | Handler_read_prev | 0 |
| NULL | NULL | Handler_read_rnd | 0 |
| NULL | NULL | Handler_read_rnd_next | 0 |
| NULL | NULL | Handler_rollback | 0 |
| NULL | NULL | Handler_savepoint | 0 |
| NULL | NULL | Handler_savepoint_rollback | 0 |
| NULL | NULL | Handler_update | 0 |
| NULL | NULL | Handler_write | 0 |
| NULL | NULL | Max_execution_time_exceeded | 0 |
| NULL | NULL | Max_execution_time_set | 0 |
| NULL | NULL | Max_execution_time_set_failed | 0 |
| NULL | NULL | Opened_table_definitions | 0 |
| NULL | NULL | Opened_tables | 0 |
| NULL | NULL | Questions | 0 |
| NULL | NULL | Select_full_join | 0 |
| NULL | NULL | Select_full_range_join | 0 |
| NULL | NULL | Select_range | 0 |
| NULL | NULL | Select_range_check | 0 |
| NULL | NULL | Select_scan | 0 |
| NULL | NULL | Slow_queries | 0 |
| NULL | NULL | Sort_merge_passes | 0 |
| NULL | NULL | Sort_range | 0 |
| NULL | NULL | Sort_rows | 0 |
| NULL | NULL | Sort_scan | 0 |
| NULL | NULL | Table_open_cache_hits | 0 |
| NULL | NULL | Table_open_cache_misses | 0 |
| NULL | NULL | Table_open_cache_overflows | 0 |
| root | localhost | Bytes_received | 3351 |
| root | localhost | Bytes_sent | 171021 |
| root | localhost | Com_stmt_reprepare | 0 |
| root | localhost | Created_tmp_disk_tables | 1 |
| root | localhost | Created_tmp_tables | 3 |
| root | localhost | Handler_commit | 0 |
| root | localhost | Handler_delete | 0 |
| root | localhost | Handler_discover | 0 |
| root | localhost | Handler_external_lock | 1 |
| root | localhost | Handler_mrr_init | 0 |
| root | localhost | Handler_prepare | 0 |
| root | localhost | Handler_read_first | 1 |
| root | localhost | Handler_read_key | 1 |
| root | localhost | Handler_read_last | 0 |
| root | localhost | Handler_read_next | 0 |
| root | localhost | Handler_read_prev | 0 |
| root | localhost | Handler_read_rnd | 0 |
| root | localhost | Handler_read_rnd_next | 142 |
| root | localhost | Handler_rollback | 0 |
| root | localhost | Handler_savepoint | 0 |
| root | localhost | Handler_savepoint_rollback | 0 |
| root | localhost | Handler_update | 0 |
| root | localhost | Handler_write | 92 |
| root | localhost | Max_execution_time_exceeded | 0 |
| root | localhost | Max_execution_time_set | 0 |
| root | localhost | Max_execution_time_set_failed | 0 |
| root | localhost | Opened_table_definitions | 0 |
| root | localhost | Opened_tables | 87 |
| root | localhost | Questions | 94 |
| root | localhost | Select_full_join | 0 |
| root | localhost | Select_full_range_join | 0 |
| root | localhost | Select_range | 0 |
| root | localhost | Select_range_check | 0 |
| root | localhost | Select_scan | 4 |
| root | localhost | Slow_queries | 0 |
| root | localhost | Sort_merge_passes | 0 |
| root | localhost | Sort_range | 0 |
| root | localhost | Sort_rows | 0 |
| root | localhost | Sort_scan | 0 |
| root | localhost | Table_open_cache_hits | 2 |
| root | localhost | Table_open_cache_misses | 87 |
| root | localhost | Table_open_cache_overflows | 0 |
+------+-----------+-------------------------------+----------------+