SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 1271 | 5861523102336 | 4611741024 | 39326402544 | |
wait/io/file/innodb/innodb_data_file | 3031 | 2920670373456 | 963599472 | 158702608416 | |
wait/io/file/innodb/innodb_temp_file | 223 | 673200005808 | 3018833928 | 32644462752 | |
wait/io/file/sql/binlog | 203 | 338149269744 | 1665759744 | 23527084416 | |
wait/io/file/sql/ERRMSG | 40 | 27779356704 | 694483680 | 2739582912 | |
wait/io/table/sql/handler | 2693 | 18950942736 | 7036920 | 3895664784 | |
wait/io/file/sql/io_cache | 74 | 2053295376 | 27747192 | 780312720 | |
wait/io/file/sql/binlog_index | 23 | 1395638112 | 60679872 | 371390448 | |
wait/io/file/sql/casetest | 15 | 762213408 | 50814192 | 649998624 | |
wait/io/file/mysys/cnf | 5 | 555271728 | 111054240 | 537440112 | |
wait/io/file/mysys/charset | 3 | 544121952 | 181373808 | 512163696 | |
wait/lock/table/sql/handler | 208 | 220418352 | 1059696 | 3981120 | |
wait/io/file/sql/pid | 3 | 48935040 | 16311504 | 38849712 | |
wait/io/file/sql/misc | 2 | 8095824 | 4047912 | 4515456 |
|