SELECT * FROM `waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_data_file | 2217 | 2.22 s | 1.00 ms | 226.04 ms | |
wait/io/file/innodb/innodb_log_file | 405 | 2.22 s | 5.47 ms | 30.56 ms | |
wait/io/file/innodb/innodb_temp_file | 96 | 372.06 ms | 3.88 ms | 38.06 ms | |
wait/io/file/sql/binlog | 119 | 120.51 ms | 1.01 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/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 | 125 | 123.87 us | 990.79 ns | 2.77 us | |
wait/io/file/sql/misc | 4 | 75.98 us | 19.00 us | 34.61 us | |
wait/io/file/sql/pid | 3 | 13.75 us | 4.58 us | 10.95 us |
|