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 | 5607 | 339366068976 | 0 | 60525168 | 29983823760 | 1394 | 4695868848 | 244464 | 3368376 | 579220752 | 7054 | 21 | 2170405776 | 4935744 | 103352568 | 834349296 | 8439 | 4192 | 332499794352 | 0 | 79317480 | 29983823760 | |
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 | 57317745408 | 0 | 1508361624 | 40231962144 | 9 | 1521718176 | 0 | 169079592 | 1506072480 | 288 | 0 | 0 | 0 | 0 | 0 | 0 | 29 | 55796027232 | 0 | 1924000848 | 40231962144 | |
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 | 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/casetest | 15 | 952963440 | 0 | 63530808 | 856496256 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 952963440 | 0 | 63530808 | 856496256 | |
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 | 75 | 40705321008 | 3314784 | 542737536 | 3804108000 | 45 | 22860489168 | 136630560 | 508010712 | 1848889152 | 4597303 | 0 | 0 | 0 | 0 | 0 | 0 | 30 | 17844831840 | 3314784 | 594827640 | 3804108000 | |
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 | 6 | 419544048 | 0 | 69923832 | 226347792 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 419544048 | 0 | 69923832 | 226347792 | |
wait/io/file/sql/pid | 3 | 12931248 | 609840 | 4310328 | 10371504 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1949904 | 1949904 | 1949904 | 1949904 | 4 | 2 | 10981344 | 609840 | 5490672 | 10371504 | |
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 |
|