SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 990 | 6496520036160 | 6562141344 | 711622532544 | |
wait/io/file/innodb/innodb_data_file | 3179 | 4824172673232 | 1517512392 | 266892107328 | |
wait/io/file/innodb/innodb_temp_file | 192 | 510104655984 | 2656794888 | 35035000704 | |
wait/io/file/sql/binlog | 245 | 261867302400 | 1068845976 | 35352778560 | |
wait/io/file/sql/binlog_index | 38 | 59488653840 | 1565490696 | 27324990528 | |
wait/io/file/sql/ERRMSG | 60 | 48285240432 | 804753840 | 5980265280 | |
wait/io/table/sql/handler | 1706 | 31995276720 | 18754296 | 5036527056 | |
wait/lock/metadata/sql/mdl | 3 | 18108225696 | 6036075144 | 14289250800 | |
wait/io/file/sql/io_cache | 146 | 3266209584 | 22371096 | 190022448 | |
wait/io/file/myisam/kfile | 4 | 2561505408 | 640376352 | 2509270896 | |
wait/io/file/mysys/cnf | 5 | 1897008960 | 379401792 | 1880750256 | |
wait/lock/table/sql/handler | 843 | 1168271808 | 1385736 | 44072160 | |
wait/io/file/csv/metadata | 8 | 742338432 | 92792304 | 389370432 | |
wait/io/file/sql/casetest | 15 | 715649088 | 47709816 | 648433632 | |
wait/io/file/mysys/charset | 3 | 300604656 | 100201464 | 279493104 | |
wait/io/file/csv/data | 4 | 207203040 | 51800760 | 175740576 | |
wait/io/file/sql/misc | 5 | 73586304 | 14717208 | 20865504 | |
wait/io/file/myisam/dfile | 2 | 34351680 | 17175840 | 32900208 | |
wait/io/file/sql/pid | 3 | 17739216 | 5913072 | 11240064 |
|