SELECT * FROM `waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 739 | 4.07 s | 5.50 ms | 62.68 ms | |
wait/io/file/innodb/innodb_data_file | 2453 | 3.15 s | 1.28 ms | 225.28 ms | |
wait/io/file/innodb/innodb_temp_file | 291 | 758.24 ms | 2.61 ms | 87.56 ms | |
wait/io/file/sql/binlog | 191 | 255.38 ms | 1.34 ms | 25.77 ms | |
wait/io/file/sql/binlog_index | 38 | 45.02 ms | 1.18 ms | 29.44 ms | |
wait/io/table/sql/handler | 600 | 17.51 ms | 29.18 us | 8.95 ms | |
wait/io/file/sql/ERRMSG | 30 | 10.81 ms | 360.29 us | 1.68 ms | |
wait/io/file/sql/io_cache | 112 | 2.47 ms | 22.07 us | 107.85 us | |
wait/io/file/mysys/cnf | 5 | 1.62 ms | 323.83 us | 1.59 ms | |
wait/io/file/sql/casetest | 15 | 811.36 us | 54.09 us | 722.61 us | |
wait/lock/table/sql/handler | 303 | 545.48 us | 1.80 us | 25.69 us | |
wait/io/file/sql/misc | 4 | 459.89 us | 114.97 us | 277.13 us | |
wait/io/file/csv/metadata | 4 | 431.50 us | 107.87 us | 377.57 us | |
wait/io/file/mysys/charset | 3 | 319.51 us | 106.50 us | 276.72 us | |
wait/io/file/csv/data | 2 | 233.48 us | 116.74 us | 225.23 us | |
wait/io/file/sql/pid | 3 | 21.91 us | 7.30 us | 17.14 us |
|