SELECT * FROM `waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 514 | 2.95 s | 5.74 ms | 38.55 ms | |
wait/io/file/innodb/innodb_data_file | 2369 | 2.82 s | 1.19 ms | 226.04 ms | |
wait/io/file/innodb/innodb_temp_file | 99 | 392.05 ms | 3.96 ms | 38.06 ms | |
wait/io/file/sql/binlog | 165 | 168.79 ms | 1.02 ms | 30.24 ms | |
wait/io/file/sql/binlog_index | 38 | 48.65 ms | 1.28 ms | 33.25 ms | |
wait/io/file/sql/ERRMSG | 50 | 28.52 ms | 570.44 us | 3.67 ms | |
wait/io/table/sql/handler | 466 | 23.74 ms | 50.95 us | 4.23 ms | |
wait/io/file/sql/io_cache | 36 | 2.10 ms | 58.25 us | 724.06 us | |
wait/io/file/mysys/cnf | 5 | 1.14 ms | 227.46 us | 1.12 ms | |
wait/io/file/sql/casetest | 15 | 894.80 us | 59.65 us | 810.20 us | |
wait/io/file/mysys/charset | 3 | 285.17 us | 95.06 us | 270.59 us | |
wait/lock/table/sql/handler | 146 | 157.60 us | 1.08 us | 3.37 us | |
wait/io/file/sql/misc | 6 | 106.26 us | 17.71 us | 34.61 us | |
wait/io/file/sql/pid | 3 | 13.75 us | 4.58 us | 10.95 us |
|