SELECT * FROM `waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 804 | 5.10 s | 6.34 ms | 613.06 ms | |
wait/io/file/innodb/innodb_data_file | 2771 | 3.56 s | 1.28 ms | 209.04 ms | |
wait/io/file/innodb/innodb_temp_file | 194 | 842.80 ms | 4.34 ms | 31.01 ms | |
wait/io/file/sql/ERRMSG | 55 | 459.63 ms | 8.36 ms | 433.41 ms | |
wait/io/file/sql/binlog | 444 | 327.36 ms | 737.29 us | 24.44 ms | |
wait/lock/metadata/sql/mdl | 3 | 81.37 ms | 27.12 ms | 28.45 ms | |
wait/io/file/sql/binlog_index | 38 | 55.22 ms | 1.45 ms | 34.13 ms | |
wait/io/table/sql/handler | 909 | 37.74 ms | 41.52 us | 8.37 ms | |
wait/io/file/csv/metadata | 8 | 2.29 ms | 286.72 us | 1.36 ms | |
wait/io/file/mysys/cnf | 5 | 1.32 ms | 263.42 us | 1.29 ms | |
wait/io/file/sql/io_cache | 36 | 939.85 us | 26.11 us | 254.47 us | |
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/lock/table/sql/handler | 368 | 454.44 us | 1.23 us | 16.31 us | |
wait/io/file/sql/misc | 8 | 431.26 us | 53.91 us | 332.75 us | |
wait/io/file/mysys/charset | 3 | 241.19 us | 80.40 us | 230.00 us | |
wait/io/file/sql/pid | 3 | 47.58 us | 15.86 us | 36.90 us |
|