SELECT * FROM `waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 2479 | 12.40 s | 5.00 ms | 613.06 ms | |
wait/io/file/innodb/innodb_data_file | 3968 | 5.84 s | 1.47 ms | 209.04 ms | |
wait/io/file/innodb/innodb_temp_file | 224 | 1.03 s | 4.58 ms | 31.01 ms | |
wait/io/file/sql/binlog | 744 | 975.84 ms | 1.31 ms | 26.71 ms | |
wait/lock/metadata/sql/mdl | 5 | 750.91 ms | 150.18 ms | 338.11 ms | |
wait/io/file/sql/ERRMSG | 60 | 463.64 ms | 7.73 ms | 433.41 ms | |
wait/io/file/sql/binlog_index | 38 | 55.22 ms | 1.45 ms | 34.13 ms | |
wait/io/file/sql/io_cache | 72 | 2.31 ms | 32.05 us | 696.91 us | |
wait/io/file/csv/metadata | 8 | 2.29 ms | 286.72 us | 1.36 ms | |
wait/io/table/sql/handler | 47 | 1.93 ms | 41.11 us | 1.05 ms | |
wait/io/file/mysys/cnf | 5 | 1.32 ms | 263.42 us | 1.29 ms | |
wait/io/file/sql/casetest | 15 | 913.43 us | 60.90 us | 852.84 us | |
wait/io/file/csv/data | 4 | 618.03 us | 154.51 us | 509.95 us | |
wait/io/file/sql/misc | 14 | 493.13 us | 35.22 us | 332.75 us | |
wait/io/file/myisam/kfile | 4 | 424.04 us | 106.01 us | 311.39 us | |
wait/io/file/mysys/charset | 3 | 241.19 us | 80.40 us | 230.00 us | |
wait/lock/table/sql/handler | 100 | 204.52 us | 2.04 us | 16.75 us | |
wait/io/file/sql/pid | 3 | 47.58 us | 15.86 us | 36.90 us | |
wait/io/file/myisam/dfile | 4 | 43.28 us | 10.82 us | 13.64 us |
|