SELECT * FROM `waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 1536 | 8.54 s | 5.56 ms | 102.11 ms | |
wait/io/file/innodb/innodb_data_file | 3966 | 7.02 s | 1.77 ms | 224.32 ms | |
wait/io/file/innodb/innodb_temp_file | 198 | 1.01 s | 5.12 ms | 144.56 ms | |
wait/io/file/sql/binlog | 499 | 402.95 ms | 807.52 us | 36.44 ms | |
wait/io/file/sql/binlog_index | 38 | 53.04 ms | 1.40 ms | 29.30 ms | |
wait/io/file/sql/ERRMSG | 65 | 44.39 ms | 682.97 us | 5.21 ms | |
wait/io/table/sql/handler | 752 | 22.57 ms | 30.02 us | 4.44 ms | |
wait/io/file/sql/io_cache | 146 | 3.21 ms | 21.98 us | 328.74 us | |
wait/io/file/sql/misc | 6 | 1.28 ms | 212.76 us | 1.22 ms | |
wait/lock/table/sql/handler | 895 | 1.27 ms | 1.42 us | 19.07 us | |
wait/io/file/sql/casetest | 15 | 1.23 ms | 81.68 us | 1.16 ms | |
wait/io/file/myisam/kfile | 4 | 784.25 us | 196.06 us | 723.22 us | |
wait/io/file/csv/metadata | 8 | 768.51 us | 96.06 us | 450.74 us | |
wait/io/file/mysys/cnf | 5 | 626.88 us | 125.38 us | 609.18 us | |
wait/io/file/mysys/charset | 3 | 267.15 us | 89.05 us | 252.95 us | |
wait/io/file/csv/data | 4 | 265.25 us | 66.31 us | 235.67 us | |
wait/io/file/sql/pid | 3 | 92.89 us | 30.96 us | 57.60 us | |
wait/io/file/myisam/dfile | 2 | 57.06 us | 28.53 us | 55.66 us |
|