SELECT * FROM `waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 1236 | 6.86 s | 5.55 ms | 46.01 ms | |
wait/io/file/innodb/innodb_data_file | 3641 | 5.17 s | 1.42 ms | 218.75 ms | |
wait/io/table/sql/handler | 4899618 | 2.71 s | 553.08 ns | 6.20 ms | |
wait/io/file/innodb/innodb_temp_file | 122 | 590.01 ms | 4.84 ms | 38.74 ms | |
wait/io/file/sql/ERRMSG | 65 | 57.32 ms | 881.77 us | 6.16 ms | |
wait/io/file/sql/binlog_index | 38 | 43.66 ms | 1.15 ms | 24.89 ms | |
wait/io/file/sql/binlog | 381 | 42.15 ms | 110.63 us | 19.25 ms | |
wait/io/file/myisam/kfile | 12 | 4.34 ms | 361.56 us | 3.11 ms | |
wait/io/file/sql/io_cache | 210 | 3.98 ms | 18.97 us | 491.57 us | |
wait/io/file/csv/metadata | 8 | 2.45 ms | 305.78 us | 1.95 ms | |
wait/io/file/myisam/dfile | 173 | 2.00 ms | 11.57 us | 1.85 ms | |
wait/lock/table/sql/handler | 1371 | 1.44 ms | 1.05 us | 17.19 us | |
wait/io/file/sql/casetest | 15 | 1.20 ms | 80.29 us | 1.14 ms | |
wait/io/file/mysys/cnf | 5 | 441.09 us | 88.22 us | 423.36 us | |
wait/io/file/mysys/charset | 3 | 277.38 us | 92.46 us | 266.08 us | |
wait/io/file/csv/data | 49 | 252.31 us | 5.15 us | 20.45 us | |
wait/io/file/sql/pid | 3 | 46.34 us | 15.45 us | 36.41 us | |
wait/io/file/sql/misc | 1 | 5.79 us | 5.79 us | 5.79 us |
|