SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 641 | 3027566951904 | 4723193112 | 31704223056 | |
wait/io/file/innodb/innodb_data_file | 2573 | 2072420688624 | 805448952 | 195974418288 | |
wait/io/file/innodb/innodb_temp_file | 684 | 1582717624752 | 2313914592 | 283298567376 | |
wait/io/file/sql/binlog_index | 38 | 55336979280 | 1456236144 | 28889379024 | |
wait/io/file/sql/io_cache | 229 | 44464106544 | 194166192 | 29143583568 | |
wait/io/file/sql/binlog | 277 | 40172040480 | 145025232 | 20123708352 | |
wait/io/file/sql/ERRMSG | 45 | 24794667216 | 550992552 | 2518664016 | |
wait/io/table/sql/handler | 1474 | 23342152416 | 15835776 | 4516808736 | |
wait/io/file/csv/metadata | 4 | 3376700976 | 844175112 | 1907104848 | |
wait/io/file/sql/casetest | 15 | 895852848 | 59723400 | 813221904 | |
wait/io/file/mysys/cnf | 5 | 423623904 | 84724728 | 405869904 | |
wait/io/file/mysys/charset | 3 | 305534064 | 101844600 | 288990768 | |
wait/lock/table/sql/handler | 290 | 297642576 | 1026168 | 4014912 | |
wait/io/file/csv/data | 2 | 18081888 | 9040944 | 11591184 | |
wait/io/file/sql/pid | 3 | 12032064 | 4010688 | 9714672 | |
wait/io/file/sql/misc | 1 | 4783152 | 4783152 | 4783152 |
|