SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 5657 | 29009300071488 | 5128036056 | 116198231952 | |
wait/io/file/innodb/innodb_data_file | 9789 | 10806802256448 | 1103973816 | 234395839392 | |
wait/io/file/innodb/innodb_temp_file | 1454 | 2261492403456 | 1555359168 | 658381239120 | |
wait/io/table/sql/handler | 1013733 | 686145370416 | 676632 | 7510095120 | |
wait/io/file/sql/binlog | 355 | 277964621616 | 782998920 | 21460263264 | |
wait/io/file/sql/io_cache | 2340 | 251668020912 | 107550432 | 67842775968 | |
wait/io/file/sql/binlog_index | 38 | 58515371376 | 1539877944 | 35547195024 | |
wait/io/file/sql/ERRMSG | 70 | 48968267040 | 699546672 | 4958527200 | |
wait/lock/table/sql/handler | 5497 | 5487374640 | 998184 | 21910944 | |
wait/io/file/myisam/kfile | 16 | 1674788016 | 104674152 | 788288688 | |
wait/io/file/csv/data | 24 | 1307026512 | 54459240 | 851699904 | |
wait/io/file/csv/metadata | 8 | 1249043664 | 156130392 | 717032976 | |
wait/io/file/sql/casetest | 15 | 1115546784 | 74369592 | 1050804480 | |
wait/io/file/mysys/cnf | 5 | 575300880 | 115060176 | 559230144 | |
wait/io/file/sql/misc | 10 | 386688720 | 38668872 | 251651664 | |
wait/io/file/myisam/dfile | 14 | 337827600 | 24130392 | 291816096 | |
wait/io/file/mysys/charset | 3 | 297092400 | 99030624 | 281397600 | |
wait/io/file/sql/pid | 3 | 44132352 | 14710608 | 34663728 |
|