SELECT * FROM `waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 610 | 3.78 s | 6.19 ms | 74.45 ms | |
wait/io/file/innodb/innodb_data_file | 2618 | 3.04 s | 1.16 ms | 181.05 ms | |
wait/io/file/innodb/innodb_temp_file | 150 | 695.60 ms | 4.64 ms | 50.80 ms | |
wait/io/table/sql/handler | 133990 | 274.72 ms | 2.05 us | 16.76 ms | |
wait/io/file/sql/binlog | 419 | 116.28 ms | 277.52 us | 20.99 ms | |
wait/io/file/sql/binlog_index | 38 | 62.52 ms | 1.65 ms | 37.71 ms | |
wait/io/file/sql/ERRMSG | 90 | 51.83 ms | 575.91 us | 2.24 ms | |
wait/io/file/sql/misc | 5 | 2.42 ms | 483.12 us | 2.26 ms | |
wait/io/file/myisam/dfile | 34 | 1.65 ms | 48.65 us | 1.59 ms | |
wait/io/file/myisam/kfile | 12 | 1.30 ms | 108.33 us | 709.33 us | |
wait/io/file/sql/casetest | 15 | 1.24 ms | 82.54 us | 1.18 ms | |
wait/io/file/mysys/cnf | 5 | 1.07 ms | 214.81 us | 1.04 ms | |
wait/io/file/csv/metadata | 8 | 919.48 us | 114.94 us | 507.35 us | |
wait/lock/table/sql/handler | 502 | 546.56 us | 1.09 us | 14.27 us | |
wait/io/file/mysys/charset | 3 | 232.43 us | 77.48 us | 219.05 us | |
wait/io/file/sql/pid | 3 | 35.36 us | 11.79 us | 29.88 us | |
wait/io/file/csv/data | 4 | 32.90 us | 8.22 us | 10.71 us |
|