SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 903 | 6228213798576 | 6897246576 | 491965089264 | |
wait/io/file/innodb/innodb_data_file | 2923 | 3514418792544 | 1202332560 | 327325404912 | |
wait/io/file/innodb/innodb_temp_file | 178 | 1277864945280 | 7179016416 | 183677633568 | |
wait/io/file/sql/binlog | 649 | 243632224704 | 375396120 | 29446496640 | |
wait/io/table/sql/handler | 4716 | 184836778896 | 39193440 | 133205832672 | |
wait/io/file/sql/binlog_index | 38 | 77310271104 | 2034480624 | 42135305520 | |
wait/io/file/sql/ERRMSG | 65 | 53106194064 | 817018224 | 8712029568 | |
wait/lock/metadata/sql/mdl | 1 | 44661624480 | 44661624480 | 44661624480 | |
wait/io/file/sql/io_cache | 46 | 19046731440 | 414059184 | 10597231392 | |
wait/io/file/myisam/dfile | 12 | 5112278688 | 426023136 | 5040268464 | |
wait/io/file/mysys/cnf | 5 | 4184623872 | 836924616 | 4162918848 | |
wait/io/file/myisam/kfile | 8 | 3900970128 | 487621200 | 2323428624 | |
wait/io/file/csv/metadata | 8 | 1895469312 | 236933664 | 868471296 | |
wait/io/file/sql/casetest | 15 | 826374384 | 55091520 | 757267104 | |
wait/lock/table/sql/handler | 479 | 488176128 | 1019040 | 15338928 | |
wait/io/file/mysys/charset | 3 | 313551744 | 104517072 | 294298224 | |
wait/io/file/csv/data | 4 | 298638384 | 74659464 | 228463488 | |
wait/io/file/sql/misc | 6 | 95983536 | 15997080 | 27698880 | |
wait/io/file/sql/pid | 3 | 56716176 | 18905304 | 40221456 |
|