SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 412 | 2256676488528 | 5477370096 | 32073647232 | |
wait/io/file/innodb/innodb_data_file | 2170 | 2158335178560 | 994624488 | 273687098256 | |
wait/io/file/innodb/innodb_temp_file | 195 | 541198866384 | 2775378672 | 41219991648 | |
wait/io/table/sql/handler | 3785 | 92882862336 | 24539592 | 78304711056 | |
wait/io/file/sql/binlog_index | 38 | 60925890432 | 1603312656 | 35850744336 | |
wait/io/file/sql/binlog | 1026 | 39721171776 | 38714544 | 20258969808 | |
wait/io/file/sql/ERRMSG | 40 | 25096245504 | 627406032 | 6479235840 | |
wait/io/file/sql/io_cache | 110 | 3598848528 | 32716728 | 1087044816 | |
wait/io/file/sql/casetest | 15 | 976597776 | 65106360 | 916736832 | |
wait/io/file/mysys/cnf | 5 | 781438944 | 156287736 | 761990064 | |
wait/io/file/mysys/charset | 3 | 279086016 | 93028584 | 266006400 | |
wait/lock/table/sql/handler | 266 | 264967824 | 996072 | 10870992 | |
wait/io/file/sql/pid | 3 | 32957232 | 10985568 | 27482400 | |
wait/io/file/sql/misc | 1 | 9738960 | 9738960 | 9738960 |
|