SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_data_file | 1830 | 777352449456 | 424782600 | 73965088032 | |
wait/io/file/innodb/innodb_log_file | 169 | 760984834368 | 4502868744 | 37330897824 | |
wait/io/file/innodb/innodb_temp_file | 199 | 429799268976 | 2159795088 | 28156431600 | |
wait/io/file/sql/binlog | 171 | 68228678496 | 398997984 | 22485771264 | |
wait/io/file/sql/ERRMSG | 50 | 22873923072 | 457478208 | 3916135872 | |
wait/io/table/sql/handler | 741 | 18408947040 | 24843192 | 4536588672 | |
wait/io/file/sql/io_cache | 164 | 16874957088 | 102895848 | 9202593840 | |
wait/io/file/sql/binlog_index | 23 | 2658445152 | 115584480 | 1612268064 | |
wait/io/file/mysys/cnf | 5 | 1201346256 | 240269040 | 1184068512 | |
wait/io/file/sql/casetest | 15 | 888021024 | 59201208 | 831639072 | |
wait/lock/table/sql/handler | 202 | 262981488 | 1301784 | 59195136 | |
wait/io/file/mysys/charset | 3 | 182858016 | 60952584 | 174340320 | |
wait/io/file/sql/pid | 3 | 44900592 | 14966688 | 35302608 | |
wait/io/file/sql/misc | 2 | 16751856 | 8375928 | 8870400 |
|