SELECT * FROM `waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 1347 | 7.56 s | 5.61 ms | 137.40 ms | |
wait/io/file/innodb/innodb_data_file | 3659 | 6.23 s | 1.70 ms | 207.40 ms | |
wait/io/file/innodb/innodb_temp_file | 150 | 679.47 ms | 4.53 ms | 33.50 ms | |
wait/io/file/sql/binlog | 1013 | 403.18 ms | 398.01 us | 36.46 ms | |
wait/io/file/sql/ERRMSG | 65 | 43.99 ms | 676.78 us | 3.37 ms | |
wait/io/file/sql/binlog_index | 38 | 41.83 ms | 1.10 ms | 25.87 ms | |
wait/io/table/sql/handler | 333 | 25.13 ms | 75.47 us | 4.36 ms | |
wait/io/file/sql/io_cache | 66 | 1.90 ms | 28.72 us | 142.51 us | |
wait/io/file/mysys/cnf | 5 | 1.51 ms | 301.06 us | 1.49 ms | |
wait/io/file/sql/casetest | 15 | 906.54 us | 60.44 us | 831.57 us | |
wait/lock/table/sql/handler | 388 | 574.59 us | 1.48 us | 29.07 us | |
wait/io/file/sql/misc | 7 | 484.47 us | 69.21 us | 335.97 us | |
wait/io/file/mysys/charset | 3 | 252.65 us | 84.22 us | 229.58 us | |
wait/io/file/sql/pid | 3 | 12.50 us | 4.17 us | 9.93 us |
|