SELECT * FROM `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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
wait/io/file/sql/binlog | 1223 | 70691028672 | 0 | 57801216 | 15738382704 | 302 | 4857790608 | 456720 | 16085256 | 2038193520 | 1804 | 4 | 1700808384 | 5142192 | 425202096 | 1671130560 | 426 | 917 | 64132429680 | 0 | 69937032 | 15738382704 | |
wait/io/file/sql/binlog_cache | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
wait/io/file/sql/binlog_index | 38 | 48961349712 | 0 | 1288456488 | 29711564256 | 9 | 417711888 | 0 | 46412256 | 390225264 | 288 | 0 | 0 | 0 | 0 | 0 | 0 | 29 | 48543637824 | 0 | 1673918400 | 29711564256 | |
wait/io/file/sql/binlog_index_cache | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
wait/io/file/sql/relaylog | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
wait/io/file/sql/relaylog_cache | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
wait/io/file/sql/relaylog_index | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
wait/io/file/sql/relaylog_index_cache | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
wait/io/file/sql/io_cache | 484 | 69723260112 | 0 | 144056088 | 32065074624 | 230 | 1290708144 | 0 | 5611584 | 32330496 | 11547919 | 194 | 8424027216 | 0 | 43422720 | 638878944 | 11547919 | 60 | 60008524752 | 0 | 1000141824 | 32065074624 | |
wait/io/file/sql/casetest | 15 | 848243616 | 0 | 56549328 | 788201040 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 848243616 | 0 | 56549328 | 788201040 | |
wait/io/file/sql/dbopt | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
wait/io/file/sql/ERRMSG | 60 | 37722427776 | 2531760 | 628707024 | 2430498576 | 36 | 23546788320 | 182531184 | 654077424 | 1980981552 | 3694592 | 0 | 0 | 0 | 0 | 0 | 0 | 24 | 14175639456 | 2531760 | 590651424 | 2430498576 | |
wait/io/file/sql/select_to_file | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
wait/io/file/sql/file_parser | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
wait/io/file/sql/FRM | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
wait/io/file/sql/load | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
wait/io/file/sql/LOAD_FILE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
wait/io/file/sql/log_event_data | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
wait/io/file/sql/log_event_info | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
wait/io/file/sql/misc | 2 | 527985216 | 0 | 263992608 | 522086400 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 527985216 | 0 | 263992608 | 522086400 | |
wait/io/file/sql/pid | 3 | 18914544 | 983664 | 6304848 | 14573328 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 3357552 | 3357552 | 3357552 | 3357552 | 4 | 2 | 15556992 | 983664 | 7778496 | 14573328 | |
wait/io/file/sql/query_log | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
wait/io/file/sql/slow_log | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
wait/io/file/sql/tclog | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
wait/io/file/sql/trigger_name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
|