SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 3090 | 16109952198912 | 5213576544 | 151293090432 | |
wait/io/file/innodb/innodb_data_file | 5436 | 9567419853552 | 1760010912 | 208012862112 | |
wait/io/file/innodb/innodb_temp_file | 502 | 1392584015856 | 2774071608 | 127632673872 | |
wait/io/file/sql/binlog | 591 | 812520127056 | 1374822504 | 24565725360 | |
wait/lock/metadata/sql/mdl | 18 | 631983882816 | 35110215624 | 304553563776 | |
wait/io/file/sql/ERRMSG | 75 | 61696890288 | 822625056 | 5665795872 | |
wait/io/file/sql/binlog_index | 38 | 51206038752 | 1347527280 | 34578879456 | |
wait/io/table/sql/handler | 9871 | 51118058640 | 5178360 | 6143486448 | |
wait/io/file/sql/io_cache | 208 | 12591418752 | 60535464 | 3937478688 | |
wait/lock/table/sql/handler | 856 | 1501389120 | 1753752 | 418233552 | |
wait/io/file/sql/casetest | 15 | 888087024 | 59205696 | 816213024 | |
wait/io/file/mysys/cnf | 5 | 791587104 | 158317368 | 756155136 | |
wait/io/file/csv/data | 4 | 757316208 | 189328920 | 719632320 | |
wait/io/file/csv/metadata | 8 | 523917504 | 65489688 | 219400368 | |
wait/io/file/myisam/kfile | 4 | 489809760 | 122452440 | 473525712 | |
wait/io/file/mysys/charset | 3 | 244498848 | 81499440 | 222864576 | |
wait/io/file/sql/misc | 13 | 173125920 | 13317216 | 29466624 | |
wait/io/file/myisam/dfile | 6 | 20720832 | 3453384 | 9510864 | |
wait/io/file/sql/pid | 3 | 13318800 | 4439424 | 10737408 |
|