系统表介绍
file_summary_by_event_name 按文件名与事件分组统计
| 列名 | 含义 |
|---|---|
| EVENT_NAME | 事件名称 |
| COUNT_STAR | 事件汇总数 |
| SUM_TIMER_WAIT | 事件总等待时间 |
| MIN_TIMER_WAIT | 事件最小等待时间 |
| AVG_TIMER_WAIT | 事件平均等待时间 |
| MAX_TIMER_WAIT | 事件最大等待时间 |
| COUNT_READ | 读操作事件汇总数 |
| SUM_TIMER_READ | 读操作总等待时间 |
| MIN_TIMER_READ | 读操作最小等待时间 |
| AVG_TIMER_READ | 读操作平均等待时间 |
| MAX_TIMER_READ | 读操作最大等待时间 |
| SUM_NUMBER_OF_BYTES_READ | 总读取字节数 |
| COUNT_WRITE | 写操作事件汇总数 |
| SUM_TIMER_WRITE | 写操作总等待时间 |
| MIN_TIMER_WRITE | 写操作最小等待时间 |
| AVG_TIMER_WRITE | 写操作平均等待时间 |
| MAX_TIMER_WRITE | 写操作最大等待时间 |
| SUM_NUMBER_OF_BYTES_WRITE | 总写入字节数 |
| COUNT_MISC | 其他文件操作发生的次数 |
| SUM_TIMER_MISC | 其他文件操作总时间 |
| MIN_TIMER_MISC | 其他文件操作最短时间 |
| AVG_TIMER_MISC | 其他文件操作平均时间 |
| MAX_TIMER_MISC | 其他文件操作最长时间 |
实例
mysql> select * from file_summary_by_event_name limit 2 \G ;
*************************** 1. row ***************************
EVENT_NAME: wait/io/file/sql/map
COUNT_STAR: 0
SUM_TIMER_WAIT: 0
MIN_TIMER_WAIT: 0
AVG_TIMER_WAIT: 0
MAX_TIMER_WAIT: 0
COUNT_READ: 0
SUM_TIMER_READ: 0
MIN_TIMER_READ: 0
AVG_TIMER_READ: 0
MAX_TIMER_READ: 0
SUM_NUMBER_OF_BYTES_READ: 0
COUNT_WRITE: 0
SUM_TIMER_WRITE: 0
MIN_TIMER_WRITE: 0
AVG_TIMER_WRITE: 0
MAX_TIMER_WRITE: 0
SUM_NUMBER_OF_BYTES_WRITE: 0
COUNT_MISC: 0
SUM_TIMER_MISC: 0
MIN_TIMER_MISC: 0
AVG_TIMER_MISC: 0
MAX_TIMER_MISC: 0
*************************** 2. row ***************************
EVENT_NAME: wait/io/file/sql/binlog
COUNT_STAR: 9614
SUM_TIMER_WAIT: 901935582472
MIN_TIMER_WAIT: 1225384
AVG_TIMER_WAIT: 93814632
MAX_TIMER_WAIT: 96170384048
COUNT_READ: 7
SUM_TIMER_READ: 2220859792
MIN_TIMER_READ: 3618624
AVG_TIMER_READ: 317265416
MAX_TIMER_READ: 1020551984
SUM_NUMBER_OF_BYTES_READ: 17519
COUNT_WRITE: 9509
SUM_TIMER_WRITE: 282927913104
MIN_TIMER_WRITE: 7561360
AVG_TIMER_WRITE: 29753632
MAX_TIMER_WRITE: 4216208696
SUM_NUMBER_OF_BYTES_WRITE: 77228214
COUNT_MISC: 98
SUM_TIMER_MISC: 616786809576
MIN_TIMER_MISC: 1225384
AVG_TIMER_MISC: 6293742928
MAX_TIMER_MISC: 96170384048
2 rows in set (0.00 sec)