SELECT * FROM `waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 3059 | 15.31 s | 5.00 ms | 134.40 ms | |
wait/io/file/innodb/innodb_data_file | 5026 | 8.49 s | 1.69 ms | 236.90 ms | |
wait/io/file/innodb/innodb_temp_file | 475 | 1.75 s | 3.69 ms | 125.77 ms | |
wait/io/file/sql/binlog | 980 | 1.29 s | 1.32 ms | 33.10 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 | 182 | 9.52 ms | 52.32 us | 2.85 ms | |
wait/io/file/mysys/cnf | 5 | 5.65 ms | 1.13 ms | 5.63 ms | |
wait/io/table/sql/handler | 114 | 2.26 ms | 19.83 us | 521.11 us | |
wait/io/file/sql/casetest | 15 | 853.56 us | 56.90 us | 793.96 us | |
wait/io/file/sql/misc | 27 | 672.28 us | 24.90 us | 237.23 us | |
wait/io/file/csv/metadata | 8 | 639.30 us | 79.91 us | 210.23 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/lock/table/sql/handler | 144 | 233.14 us | 1.62 us | 12.69 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 |
|