SELECT * FROM `waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 1038 | 6.10 s | 5.87 ms | 93.80 ms | |
wait/io/file/innodb/innodb_data_file | 3120 | 4.24 s | 1.36 ms | 256.39 ms | |
wait/io/file/innodb/innodb_temp_file | 140 | 773.17 ms | 5.52 ms | 36.94 ms | |
wait/io/table/sql/handler | 1032232 | 608.58 ms | 589.51 ns | 6.08 ms | |
wait/io/file/sql/binlog | 285 | 147.08 ms | 516.07 us | 33.47 ms | |
wait/io/file/sql/binlog_index | 38 | 47.53 ms | 1.25 ms | 28.30 ms | |
wait/io/file/sql/ERRMSG | 55 | 38.60 ms | 701.74 us | 4.10 ms | |
wait/io/file/myisam/dfile | 42 | 12.72 ms | 302.75 us | 6.06 ms | |
wait/io/file/myisam/kfile | 12 | 2.10 ms | 174.91 us | 1.45 ms | |
wait/io/file/mysys/cnf | 5 | 1.46 ms | 292.68 us | 1.43 ms | |
wait/io/file/sql/casetest | 15 | 1.28 ms | 85.54 us | 1.21 ms | |
wait/io/file/csv/metadata | 8 | 1.11 ms | 138.21 us | 600.02 us | |
wait/lock/table/sql/handler | 853 | 1.02 ms | 1.19 us | 16.52 us | |
wait/io/file/csv/data | 37 | 494.78 us | 13.37 us | 295.75 us | |
wait/io/file/mysys/charset | 3 | 299.86 us | 99.95 us | 282.42 us | |
wait/io/file/sql/misc | 2 | 30.54 us | 15.27 us | 17.15 us | |
wait/io/file/sql/pid | 3 | 28.61 us | 9.54 us | 22.25 us |
|