SELECT * FROM `waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 1411 | 8.83 s | 6.25 ms | 517.86 ms | |
wait/io/file/innodb/innodb_data_file | 3348 | 5.52 s | 1.65 ms | 245.25 ms | |
wait/io/file/sql/binlog | 759 | 776.25 ms | 1.02 ms | 29.28 ms | |
wait/io/file/innodb/innodb_temp_file | 114 | 485.44 ms | 4.26 ms | 29.46 ms | |
wait/io/table/sql/handler | 2453 | 104.78 ms | 42.72 us | 86.74 ms | |
wait/io/file/sql/binlog_index | 38 | 46.66 ms | 1.23 ms | 23.96 ms | |
wait/io/file/sql/ERRMSG | 60 | 30.75 ms | 512.45 us | 3.28 ms | |
wait/io/file/myisam/dfile | 82 | 1.53 ms | 18.72 us | 1.47 ms | |
wait/io/file/sql/casetest | 15 | 962.17 us | 64.14 us | 902.09 us | |
wait/io/file/mysys/cnf | 5 | 856.53 us | 171.31 us | 838.52 us | |
wait/lock/table/sql/handler | 486 | 651.89 us | 1.34 us | 23.05 us | |
wait/io/file/mysys/charset | 3 | 305.34 us | 101.78 us | 292.37 us | |
wait/io/file/myisam/kfile | 4 | 250.04 us | 62.51 us | 228.06 us | |
wait/io/file/sql/misc | 7 | 129.32 us | 18.47 us | 60.33 us | |
wait/io/file/sql/pid | 3 | 51.57 us | 17.19 us | 37.36 us |
|