SELECT * FROM `waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_data_file | 2757 | 3.29 s | 1.19 ms | 255.55 ms | |
wait/io/file/innodb/innodb_log_file | 539 | 3.20 s | 5.94 ms | 49.26 ms | |
wait/io/file/innodb/innodb_temp_file | 460 | 1.65 s | 3.58 ms | 185.60 ms | |
wait/io/table/sql/handler | 41506 | 100.41 ms | 2.42 us | 13.90 ms | |
wait/io/file/sql/io_cache | 776 | 84.40 ms | 108.76 us | 22.27 ms | |
wait/io/file/sql/binlog | 489 | 51.39 ms | 105.08 us | 21.69 ms | |
wait/io/file/sql/binlog_index | 38 | 45.95 ms | 1.21 ms | 23.18 ms | |
wait/io/file/sql/ERRMSG | 55 | 34.82 ms | 633.08 us | 3.10 ms | |
wait/io/file/myisam/kfile | 16 | 4.00 ms | 250.10 us | 2.25 ms | |
wait/io/file/sql/casetest | 15 | 844.01 us | 56.27 us | 775.58 us | |
wait/io/file/mysys/cnf | 5 | 551.48 us | 110.30 us | 535.64 us | |
wait/lock/table/sql/handler | 397 | 505.84 us | 1.27 us | 18.74 us | |
wait/io/file/mysys/charset | 3 | 297.82 us | 99.27 us | 283.83 us | |
wait/io/file/myisam/dfile | 8 | 83.97 us | 10.50 us | 37.11 us | |
wait/io/file/sql/pid | 3 | 47.82 us | 15.94 us | 38.01 us | |
wait/io/file/sql/misc | 1 | 12.97 us | 12.97 us | 12.97 us |
|