SELECT * FROM `waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 2679 | 13.07 s | 4.88 ms | 123.22 ms | |
wait/io/file/innodb/innodb_data_file | 4258 | 6.90 s | 1.62 ms | 190.60 ms | |
wait/io/file/innodb/innodb_temp_file | 256 | 1.27 s | 4.98 ms | 40.61 ms | |
wait/io/file/sql/binlog | 709 | 1.19 s | 1.67 ms | 44.42 ms | |
wait/lock/metadata/sql/mdl | 4 | 141.93 ms | 35.48 ms | 91.88 ms | |
wait/io/file/sql/binlog_index | 38 | 73.27 ms | 1.93 ms | 57.20 ms | |
wait/io/file/sql/ERRMSG | 70 | 45.57 ms | 650.97 us | 2.32 ms | |
wait/io/file/mysys/cnf | 5 | 1.34 ms | 267.81 us | 1.31 ms | |
wait/io/file/sql/casetest | 15 | 1.13 ms | 75.34 us | 1.07 ms | |
wait/io/file/csv/metadata | 8 | 952.46 us | 119.06 us | 394.56 us | |
wait/io/file/sql/misc | 19 | 813.08 us | 42.79 us | 580.97 us | |
wait/io/file/myisam/dfile | 4 | 627.93 us | 156.98 us | 529.86 us | |
wait/io/file/myisam/kfile | 4 | 442.18 us | 110.54 us | 253.05 us | |
wait/io/file/mysys/charset | 3 | 248.14 us | 82.71 us | 238.44 us | |
wait/io/file/csv/data | 30 | 196.90 us | 6.56 us | 23.31 us | |
wait/lock/table/sql/handler | 41 | 54.80 us | 1.34 us | 3.49 us | |
wait/io/table/sql/handler | 1 | 23.39 us | 23.39 us | 23.39 us | |
wait/io/file/sql/pid | 3 | 15.00 us | 5.00 us | 12.39 us |
|