SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 6887 | 32977586836656 | 4788381840 | 703004902512 | |
wait/io/file/innodb/innodb_data_file | 11004 | 9725929619472 | 883853784 | 220595275296 | |
wait/io/file/innodb/innodb_temp_file | 925 | 990302774208 | 1070597352 | 29537953632 | |
wait/io/file/sql/binlog | 551 | 725892760032 | 1317409632 | 27799900128 | |
wait/io/table/sql/handler | 167654 | 293745222672 | 1751904 | 4244230848 | |
wait/io/file/sql/io_cache | 1194 | 212408568240 | 177896400 | 75009199584 | |
wait/io/file/sql/binlog_index | 38 | 51268642656 | 1349174640 | 26931266208 | |
wait/io/file/sql/ERRMSG | 50 | 16336513248 | 326730096 | 1268071200 | |
wait/lock/table/sql/handler | 5178 | 5656971936 | 1092432 | 68798928 | |
wait/io/file/mysys/cnf | 5 | 1885378176 | 377075424 | 1844532096 | |
wait/io/file/sql/casetest | 15 | 1329877296 | 88658328 | 1246562064 | |
wait/io/file/sql/misc | 10 | 1074716016 | 107471496 | 591070128 | |
wait/io/file/csv/metadata | 8 | 967668768 | 120958464 | 540387936 | |
wait/io/file/mysys/charset | 3 | 291233712 | 97077816 | 270161760 | |
wait/io/file/csv/data | 4 | 33025872 | 8256336 | 10959168 | |
wait/io/file/sql/pid | 3 | 22266288 | 7422096 | 14116608 |
|