SELECT * FROM `waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 557 | 3.68 s | 6.62 ms | 613.06 ms | |
wait/io/file/innodb/innodb_data_file | 2339 | 2.35 s | 1.01 ms | 209.04 ms | |
wait/io/file/innodb/innodb_temp_file | 133 | 652.51 ms | 4.91 ms | 31.01 ms | |
wait/io/file/sql/ERRMSG | 55 | 459.63 ms | 8.36 ms | 433.41 ms | |
wait/io/file/sql/binlog | 236 | 152.63 ms | 646.72 us | 24.44 ms | |
wait/io/file/sql/binlog_index | 38 | 55.22 ms | 1.45 ms | 34.13 ms | |
wait/io/table/sql/handler | 670 | 35.22 ms | 52.57 us | 8.37 ms | |
wait/io/file/csv/metadata | 8 | 2.29 ms | 286.72 us | 1.36 ms | |
wait/io/file/mysys/cnf | 5 | 1.32 ms | 263.42 us | 1.29 ms | |
wait/io/file/sql/casetest | 15 | 913.43 us | 60.90 us | 852.84 us | |
wait/io/file/csv/data | 4 | 618.03 us | 154.51 us | 509.95 us | |
wait/io/file/sql/misc | 6 | 416.51 us | 69.42 us | 332.75 us | |
wait/io/file/mysys/charset | 3 | 241.19 us | 80.40 us | 230.00 us | |
wait/lock/table/sql/handler | 133 | 157.54 us | 1.18 us | 3.70 us | |
wait/io/file/sql/pid | 3 | 47.58 us | 15.86 us | 36.90 us |
|