SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 892 | 5216808986400 | 5848440312 | 50978496624 | |
wait/io/file/innodb/innodb_data_file | 2925 | 4277681513952 | 1462455192 | 286355418096 | |
wait/io/file/innodb/innodb_temp_file | 209 | 554690027760 | 2654019192 | 29824375152 | |
wait/io/table/sql/handler | 982672 | 492789246576 | 501336 | 5677614624 | |
wait/io/file/sql/binlog | 389 | 103925944848 | 267161664 | 19731434448 | |
wait/io/file/sql/binlog_index | 38 | 56493197376 | 1486662936 | 33885556320 | |
wait/io/file/sql/ERRMSG | 35 | 21460365696 | 613153200 | 3497346336 | |
wait/io/file/sql/io_cache | 240 | 8027753712 | 33448800 | 1578409536 | |
wait/io/file/csv/metadata | 8 | 1441305888 | 180163104 | 921941328 | |
wait/io/file/sql/casetest | 15 | 1036169376 | 69077712 | 978238800 | |
wait/io/file/mysys/cnf | 5 | 714693936 | 142938576 | 697462656 | |
wait/io/file/csv/data | 13 | 563837472 | 43372032 | 421063104 | |
wait/lock/table/sql/handler | 550 | 530758800 | 964920 | 10570032 | |
wait/io/file/mysys/charset | 3 | 299383920 | 99794640 | 283668528 | |
wait/io/file/sql/pid | 3 | 64109760 | 21369744 | 39566736 | |
wait/io/file/sql/misc | 3 | 31315152 | 10438296 | 15179472 |
|