SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 5246 | 25339262572800 | 4830206304 | 703004902512 | |
wait/io/file/innodb/innodb_data_file | 8694 | 8066618600832 | 927837240 | 220595275296 | |
wait/io/file/innodb/innodb_temp_file | 722 | 825496852752 | 1143347304 | 29537953632 | |
wait/io/file/sql/binlog | 493 | 704838828144 | 1429693320 | 27799900128 | |
wait/io/table/sql/handler | 161110 | 281552803488 | 1747416 | 4244230848 | |
wait/io/file/sql/io_cache | 722 | 197144411376 | 273053088 | 75009199584 | |
wait/io/file/sql/binlog_index | 38 | 51268642656 | 1349174640 | 26931266208 | |
wait/io/file/sql/ERRMSG | 45 | 14684229648 | 326316144 | 1268071200 | |
wait/lock/table/sql/handler | 3962 | 4414469664 | 1114080 | 68798928 | |
wait/io/file/mysys/cnf | 5 | 1885378176 | 377075424 | 1844532096 | |
wait/io/file/sql/casetest | 15 | 1329877296 | 88658328 | 1246562064 | |
wait/io/file/csv/metadata | 8 | 967668768 | 120958464 | 540387936 | |
wait/io/file/sql/misc | 9 | 483645888 | 53738256 | 244349424 | |
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 |
|