SELECT * FROM `waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 1771 | 10.48 s | 5.92 ms | 595.80 ms | |
wait/io/file/innodb/innodb_data_file | 4026 | 6.37 s | 1.58 ms | 203.27 ms | |
wait/io/file/innodb/innodb_temp_file | 138 | 726.21 ms | 5.26 ms | 43.88 ms | |
wait/lock/metadata/sql/mdl | 2 | 577.13 ms | 288.56 ms | 291.83 ms | |
wait/io/file/sql/binlog | 369 | 391.15 ms | 1.06 ms | 59.43 ms | |
wait/io/file/sql/binlog_index | 38 | 48.55 ms | 1.28 ms | 32.17 ms | |
wait/io/file/sql/ERRMSG | 60 | 35.96 ms | 599.31 us | 2.78 ms | |
wait/io/table/sql/handler | 95 | 7.50 ms | 78.98 us | 4.59 ms | |
wait/io/file/myisam/kfile | 1 | 2.83 ms | 2.83 ms | 2.83 ms | |
wait/io/file/csv/metadata | 8 | 1.75 ms | 219.13 us | 575.03 us | |
wait/io/file/sql/casetest | 15 | 944.77 us | 62.98 us | 868.01 us | |
wait/io/file/csv/data | 4 | 648.59 us | 162.15 us | 557.49 us | |
wait/io/file/mysys/cnf | 5 | 536.89 us | 107.38 us | 504.98 us | |
wait/io/file/mysys/charset | 3 | 253.26 us | 84.42 us | 233.03 us | |
wait/lock/table/sql/handler | 104 | 149.02 us | 1.43 us | 3.81 us | |
wait/io/file/sql/misc | 5 | 98.07 us | 19.61 us | 44.04 us | |
wait/io/file/myisam/dfile | 1 | 41.09 us | 41.09 us | 41.09 us | |
wait/io/file/sql/pid | 3 | 18.94 us | 6.31 us | 13.81 us |
|