SELECT * FROM `waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 1668 | 6.53 s | 3.92 ms | 83.11 ms | |
wait/io/file/innodb/innodb_data_file | 3136 | 3.32 s | 1.06 ms | 1.01 s | |
wait/io/file/sql/binlog | 364 | 512.64 ms | 1.41 ms | 26.76 ms | |
wait/io/file/innodb/innodb_temp_file | 93 | 410.70 ms | 4.42 ms | 29.64 ms | |
wait/lock/metadata/sql/mdl | 2 | 74.47 ms | 37.24 ms | 48.51 ms | |
wait/io/file/sql/binlog_index | 38 | 48.26 ms | 1.27 ms | 26.31 ms | |
wait/io/file/sql/ERRMSG | 30 | 18.38 ms | 612.64 us | 3.61 ms | |
wait/io/file/csv/metadata | 8 | 1.63 ms | 203.50 us | 573.35 us | |
wait/io/file/sql/casetest | 15 | 1.10 ms | 73.34 us | 1.03 ms | |
wait/io/file/myisam/dfile | 4 | 682.84 us | 170.71 us | 636.10 us | |
wait/io/file/myisam/kfile | 4 | 479.94 us | 119.99 us | 310.75 us | |
wait/io/file/mysys/cnf | 5 | 463.03 us | 92.61 us | 443.22 us | |
wait/io/file/mysys/charset | 3 | 332.28 us | 110.76 us | 319.27 us | |
wait/io/file/sql/misc | 4 | 269.59 us | 67.40 us | 241.83 us | |
wait/io/file/csv/data | 4 | 71.65 us | 17.91 us | 40.56 us | |
wait/io/file/sql/pid | 3 | 55.85 us | 18.62 us | 35.05 us | |
wait/lock/table/sql/handler | 2 | 2.52 us | 1.26 us | 1.48 us |
|