SELECT * FROM `waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 15810 | 1.06 m | 4.02 ms | 246.00 ms | |
wait/io/file/innodb/innodb_data_file | 7596 | 22.46 s | 2.96 ms | 216.96 ms | |
wait/io/file/sql/binlog | 1248 | 5.72 s | 4.58 ms | 106.77 ms | |
wait/io/file/innodb/innodb_temp_file | 124 | 613.96 ms | 4.95 ms | 39.91 ms | |
wait/lock/metadata/sql/mdl | 5 | 328.93 ms | 65.79 ms | 124.50 ms | |
wait/io/table/sql/handler | 134038 | 195.43 ms | 1.46 us | 7.13 ms | |
wait/io/file/sql/ERRMSG | 90 | 57.73 ms | 641.43 us | 8.76 ms | |
wait/io/file/sql/binlog_index | 38 | 50.74 ms | 1.34 ms | 29.38 ms | |
wait/io/file/sql/io_cache | 230 | 42.08 ms | 182.97 us | 23.16 ms | |
wait/io/file/csv/metadata | 4 | 4.52 ms | 1.13 ms | 2.41 ms | |
wait/io/file/sql/misc | 6 | 2.06 ms | 342.94 us | 1.80 ms | |
wait/lock/table/sql/handler | 854 | 1.17 ms | 1.37 us | 29.56 us | |
wait/io/file/sql/casetest | 15 | 724.41 us | 48.29 us | 662.81 us | |
wait/io/file/mysys/cnf | 5 | 623.36 us | 124.67 us | 603.09 us | |
wait/io/file/mysys/charset | 3 | 290.91 us | 96.97 us | 279.06 us | |
wait/io/file/csv/data | 2 | 72.30 us | 36.15 us | 57.65 us | |
wait/io/file/sql/pid | 3 | 19.62 us | 6.54 us | 15.64 us |
|