SELECT * FROM `waits_by_host_by_latency`
|
host | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
192.168.30.20 | wait/io/file/innodb/innodb_data_file | 754 | 2.12 s | 2.81 ms | 53.44 ms | |
192.168.30.20 | wait/io/file/sql/binlog | 461 | 1.70 s | 3.69 ms | 38.66 ms | |
192.168.30.20 | wait/io/file/innodb/innodb_temp_file | 14 | 134.75 ms | 9.63 ms | 28.73 ms | |
192.168.30.20 | wait/io/table/sql/handler | 7538 | 97.00 ms | 12.87 us | 34.23 ms | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 65 | 34.78 ms | 535.14 us | 3.50 ms | |
192.168.30.20 | wait/io/file/sql/io_cache | 185 | 29.88 ms | 161.53 us | 24.86 ms | |
192.168.30.20 | wait/io/file/myisam/dfile | 7529 | 26.57 ms | 3.53 us | 13.39 ms | |
192.168.30.20 | wait/io/file/sql/SDI | 210 | 25.45 ms | 121.19 us | 5.16 ms | |
192.168.30.20 | wait/io/file/myisam/kfile | 2443 | 7.40 ms | 3.03 us | 383.45 us | |
192.168.30.20 | wait/lock/table/sql/handler | 1388 | 1.53 ms | 1.10 us | 79.48 us | |
192.168.30.20 | wait/io/file/sql/misc | 3 | 263.65 us | 87.88 us | 241.78 us | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 5.32 us | 2.66 us | 3.35 us | |
background | wait/io/file/innodb/innodb_log_file | 4208 | 17.89 s | 4.25 ms | 259.96 ms | |
background | wait/io/file/innodb/innodb_data_file | 3994 | 5.62 s | 1.41 ms | 221.64 ms | |
background | wait/io/file/innodb/innodb_temp_file | 175 | 370.97 ms | 2.12 ms | 27.55 ms | |
background | wait/io/file/sql/binlog_index | 36 | 50.74 ms | 1.41 ms | 31.87 ms | |
background | wait/io/file/sql/binlog | 37 | 42.51 ms | 1.15 ms | 20.11 ms | |
background | wait/io/file/sql/ERRMSG | 5 | 1.28 ms | 256.78 us | 598.54 us | |
background | wait/io/file/mysys/cnf | 5 | 1.15 ms | 230.01 us | 1.13 ms | |
background | wait/io/file/sql/casetest | 15 | 722.07 us | 48.14 us | 655.97 us | |
background | wait/io/file/mysys/charset | 3 | 293.49 us | 97.83 us | 270.64 us | |
background | wait/io/file/sql/pid | 3 | 47.61 us | 15.87 us | 37.09 us | |
background | wait/io/file/sql/misc | 1 | 13.30 us | 13.30 us | 13.30 us |
|