SELECT * FROM `waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 968 | 5.24 s | 5.42 ms | 105.47 ms | |
wait/io/file/innodb/innodb_data_file | 3231 | 4.09 s | 1.27 ms | 706.26 ms | |
wait/io/file/innodb/innodb_temp_file | 230 | 1.05 s | 4.57 ms | 32.91 ms | |
wait/io/file/sql/binlog | 1780 | 199.68 ms | 112.18 us | 21.57 ms | |
wait/io/table/sql/handler | 133386 | 155.30 ms | 1.16 us | 3.80 ms | |
wait/io/file/sql/binlog_index | 38 | 62.49 ms | 1.64 ms | 41.42 ms | |
wait/io/file/sql/ERRMSG | 75 | 42.26 ms | 563.42 us | 4.29 ms | |
wait/io/file/sql/io_cache | 310 | 8.74 ms | 28.19 us | 806.11 us | |
wait/io/file/myisam/kfile | 16 | 5.99 ms | 374.32 us | 4.42 ms | |
wait/io/file/csv/metadata | 8 | 3.86 ms | 483.03 us | 2.19 ms | |
wait/io/file/sql/misc | 7 | 1.08 ms | 153.90 us | 853.99 us | |
wait/io/file/sql/casetest | 15 | 684.53 us | 45.64 us | 625.67 us | |
wait/lock/table/sql/handler | 530 | 556.48 us | 1.05 us | 3.04 us | |
wait/io/file/mysys/cnf | 5 | 503.94 us | 100.79 us | 485.98 us | |
wait/io/file/mysys/charset | 3 | 311.50 us | 103.83 us | 297.67 us | |
wait/io/file/sql/pid | 3 | 54.10 us | 18.03 us | 39.23 us | |
wait/io/file/myisam/dfile | 8 | 48.28 us | 6.04 us | 15.81 us | |
wait/io/file/csv/data | 4 | 44.45 us | 11.11 us | 20.29 us |
|