SELECT * FROM `waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 3425 | 17.44 s | 5.09 ms | 134.40 ms | |
wait/io/file/innodb/innodb_data_file | 5652 | 10.25 s | 1.81 ms | 236.90 ms | |
wait/io/file/innodb/innodb_temp_file | 487 | 1.85 s | 3.80 ms | 125.77 ms | |
wait/io/file/sql/binlog | 1266 | 1.45 s | 1.14 ms | 35.25 ms | |
wait/lock/metadata/sql/mdl | 2 | 410.46 ms | 205.23 ms | 207.71 ms | |
wait/io/file/sql/binlog_index | 38 | 52.68 ms | 1.39 ms | 33.61 ms | |
wait/io/file/sql/ERRMSG | 80 | 42.10 ms | 526.29 us | 3.27 ms | |
wait/io/file/sql/io_cache | 218 | 10.20 ms | 46.81 us | 2.85 ms | |
wait/io/file/mysys/cnf | 5 | 5.65 ms | 1.13 ms | 5.63 ms | |
wait/io/table/sql/handler | 115 | 2.28 ms | 19.85 us | 521.11 us | |
wait/io/file/sql/casetest | 15 | 853.56 us | 56.90 us | 793.96 us | |
wait/io/file/sql/misc | 32 | 743.38 us | 23.23 us | 237.23 us | |
wait/io/file/csv/metadata | 8 | 639.30 us | 79.91 us | 210.23 us | |
wait/lock/table/sql/handler | 236 | 372.09 us | 1.58 us | 13.59 us | |
wait/io/file/mysys/charset | 3 | 311.09 us | 103.70 us | 296.01 us | |
wait/io/file/myisam/kfile | 4 | 247.71 us | 61.93 us | 168.04 us | |
wait/io/file/myisam/dfile | 4 | 227.54 us | 56.89 us | 200.92 us | |
wait/io/file/sql/pid | 3 | 54.11 us | 18.04 us | 36.89 us | |
wait/io/file/csv/data | 4 | 50.11 us | 12.53 us | 28.92 us |
|