SELECT * FROM `waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 415 | 2.21 s | 5.32 ms | 38.51 ms | |
wait/io/file/innodb/innodb_data_file | 2181 | 1.58 s | 725.62 us | 218.75 ms | |
wait/io/file/innodb/innodb_temp_file | 90 | 388.65 ms | 4.32 ms | 38.74 ms | |
wait/io/file/sql/ERRMSG | 50 | 46.62 ms | 932.44 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 | 97 | 40.61 ms | 418.64 us | 19.25 ms | |
wait/io/table/sql/handler | 765 | 9.69 ms | 12.66 us | 2.82 ms | |
wait/io/file/sql/casetest | 15 | 1.20 ms | 80.29 us | 1.14 ms | |
wait/io/file/sql/io_cache | 30 | 988.66 us | 32.96 us | 491.57 us | |
wait/io/file/mysys/cnf | 5 | 441.09 us | 88.22 us | 423.36 us | |
wait/io/file/csv/metadata | 4 | 379.90 us | 94.97 us | 323.33 us | |
wait/io/file/mysys/charset | 3 | 277.38 us | 92.46 us | 266.08 us | |
wait/lock/table/sql/handler | 135 | 119.68 us | 886.25 ns | 3.49 us | |
wait/io/file/sql/pid | 3 | 46.34 us | 15.45 us | 36.41 us | |
wait/io/file/csv/data | 2 | 14.51 us | 7.25 us | 9.56 us | |
wait/io/file/sql/misc | 1 | 5.79 us | 5.79 us | 5.79 us |
|