SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 488 | 2356303542912 | 4828490832 | 54088770912 | |
wait/io/file/innodb/innodb_data_file | 2143 | 1954077735984 | 911842008 | 784990663248 | |
wait/io/file/innodb/innodb_temp_file | 93 | 325741866912 | 3502600464 | 20205394176 | |
wait/io/file/sql/binlog_index | 38 | 53892652176 | 1418227536 | 38564851248 | |
wait/io/file/sql/ERRMSG | 55 | 50857991184 | 924690624 | 10706144064 | |
wait/io/file/sql/binlog | 61 | 31490744736 | 516241704 | 15436828176 | |
wait/io/table/sql/handler | 1922 | 27430457472 | 14271576 | 4386629808 | |
wait/io/file/csv/data | 4 | 3133768176 | 783441912 | 3081174624 | |
wait/io/file/csv/metadata | 8 | 2045874864 | 255734160 | 1682788800 | |
wait/io/file/mysys/cnf | 5 | 1675582128 | 335116320 | 1641159168 | |
wait/io/file/sql/io_cache | 76 | 1647856320 | 21682320 | 273336096 | |
wait/io/file/sql/casetest | 15 | 805129248 | 53675160 | 725688480 | |
wait/io/file/mysys/charset | 3 | 347315232 | 115771656 | 330029040 | |
wait/io/file/myisam/kfile | 4 | 293398512 | 73349496 | 271227264 | |
wait/lock/table/sql/handler | 202 | 209177760 | 1035408 | 8115888 | |
wait/io/file/sql/pid | 3 | 15009984 | 5003328 | 9954912 | |
wait/io/file/myisam/dfile | 2 | 9876240 | 4938120 | 9417408 | |
wait/io/file/sql/misc | 1 | 5814864 | 5814864 | 5814864 |
|