SELECT * FROM `waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 1109 | 7.43 s | 6.70 ms | 563.35 ms | |
wait/io/file/innodb/innodb_data_file | 3441 | 4.81 s | 1.40 ms | 240.88 ms | |
wait/io/file/innodb/innodb_temp_file | 198 | 2.08 s | 10.52 ms | 405.53 ms | |
wait/io/table/sql/handler | 331383 | 292.53 ms | 882.55 ns | 5.02 ms | |
wait/io/file/sql/binlog | 242 | 159.95 ms | 660.96 us | 29.08 ms | |
wait/io/file/sql/io_cache | 250 | 60.17 ms | 240.68 us | 41.23 ms | |
wait/io/file/sql/binlog_index | 38 | 58.94 ms | 1.55 ms | 33.57 ms | |
wait/io/file/sql/ERRMSG | 60 | 47.87 ms | 797.84 us | 4.71 ms | |
wait/io/file/csv/metadata | 8 | 3.09 ms | 385.80 us | 1.65 ms | |
wait/io/file/myisam/kfile | 8 | 2.61 ms | 326.01 us | 1.47 ms | |
wait/lock/table/sql/handler | 613 | 828.95 us | 1.35 us | 13.83 us | |
wait/io/file/sql/casetest | 15 | 781.17 us | 52.08 us | 716.72 us | |
wait/io/file/myisam/dfile | 61 | 747.97 us | 12.26 us | 623.70 us | |
wait/io/file/mysys/cnf | 5 | 669.42 us | 133.88 us | 651.90 us | |
wait/io/file/csv/data | 7 | 496.59 us | 70.94 us | 423.20 us | |
wait/io/file/mysys/charset | 3 | 291.46 us | 97.15 us | 272.53 us | |
wait/io/file/sql/misc | 4 | 128.94 us | 32.24 us | 70.23 us | |
wait/io/file/sql/pid | 3 | 48.60 us | 16.20 us | 38.24 us |
|