SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 659 | 3413675446896 | 5180083920 | 33491122368 | |
wait/io/file/innodb/innodb_data_file | 2325 | 1960098832032 | 843053112 | 253621091328 | |
wait/io/file/innodb/innodb_temp_file | 583 | 793994779248 | 1361912112 | 32866995744 | |
wait/io/file/sql/io_cache | 386 | 490279283472 | 1270153368 | 433163479056 | |
wait/io/file/sql/binlog_index | 38 | 62914520592 | 1655645112 | 42644634912 | |
wait/io/file/sql/binlog | 137 | 41321497008 | 301616568 | 17211719184 | |
wait/io/file/sql/ERRMSG | 25 | 20969472480 | 838778688 | 3738779616 | |
wait/io/table/sql/handler | 936 | 13641521520 | 14574120 | 2809348080 | |
wait/io/file/csv/metadata | 4 | 3414041136 | 853510152 | 1982094048 | |
wait/io/file/sql/casetest | 15 | 1196855616 | 79790304 | 1130359296 | |
wait/io/file/mysys/cnf | 5 | 740353680 | 148070736 | 719323440 | |
wait/lock/table/sql/handler | 289 | 277591248 | 960432 | 14062224 | |
wait/io/file/mysys/charset | 3 | 258413232 | 86137656 | 245263392 | |
wait/io/file/myisam/kfile | 4 | 221377200 | 55344168 | 205187136 | |
wait/io/file/csv/data | 2 | 38049264 | 19024632 | 23913120 | |
wait/io/file/sql/misc | 1 | 14955600 | 14955600 | 14955600 | |
wait/io/file/sql/pid | 3 | 13470864 | 4490112 | 10795488 | |
wait/io/file/myisam/dfile | 2 | 7551456 | 3775728 | 7232544 |
|