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 | 191 | 61693160496 | 0 | 323000832 | 15738382704 | 44 | 1308262560 | 456720 | 29733000 | 548870256 | 772 | 4 | 1700808384 | 5142192 | 425202096 | 1671130560 | 426 | 143 | 58684089552 | 0 | 410378232 | 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 | 280 | 10457838336 | 0 | 37349400 | 2047003200 | 122 | 793916640 | 0 | 6507336 | 32330496 | 6900171 | 118 | 5218900896 | 0 | 44227920 | 186804816 | 6900171 | 40 | 4445020800 | 0 | 111125520 | 2047003200 | |
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 | 50 | 32388766080 | 2531760 | 647775216 | 2430498576 | 30 | 20489399040 | 182531184 | 682979880 | 1980981552 | 3070283 | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 11899367040 | 2531760 | 594968352 | 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 |
|