SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 12867 | 54868921629250 | 4264313485 | 199278786830 | |
wait/io/file/innodb/innodb_data_file | 10331 | 22721944036660 | 2199394265 | 343759342490 | |
wait/lock/metadata/sql/mdl | 19 | 3961540433230 | 208502127995 | 870393258960 | |
wait/io/file/sql/binlog | 954 | 3164764055020 | 3317362485 | 59374188100 | |
wait/io/file/innodb/innodb_temp_file | 555 | 918234519860 | 1654476355 | 43329500220 | |
wait/io/file/sql/io_cache | 562 | 165096766490 | 293766280 | 69174871780 | |
wait/io/file/sql/ERRMSG | 75 | 90143346050 | 1201911210 | 14505454990 | |
wait/io/file/sql/binlog_index | 38 | 86138224560 | 2266795160 | 43046257620 | |
wait/io/table/sql/handler | 271 | 6997152750 | 25819745 | 3857382930 | |
wait/io/file/mysys/cnf | 5 | 3083911530 | 616782200 | 3063105850 | |
wait/io/file/myisam/kfile | 9 | 2653859460 | 294873185 | 2134322190 | |
wait/io/file/sql/casetest | 15 | 876670350 | 58444690 | 775933250 | |
wait/io/file/csv/metadata | 8 | 788943690 | 98617895 | 372774440 | |
wait/io/file/myisam/dfile | 7 | 716660170 | 102379835 | 610306660 | |
wait/io/file/mysys/charset | 3 | 320630920 | 106876885 | 289525750 | |
wait/io/file/csv/data | 4 | 251275650 | 62818780 | 212199810 | |
wait/io/file/sql/misc | 13 | 206996270 | 15922790 | 49697570 | |
wait/lock/table/sql/handler | 106 | 159454210 | 1504140 | 5071570 | |
wait/io/file/sql/pid | 3 | 17586460 | 5862065 | 14237920 |
|