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_temp_file | 90 | 845.01 ms | 9.39 ms | 35.67 ms | |
192.168.30.20 | wait/io/file/innodb/innodb_data_file | 433 | 122.64 ms | 283.24 us | 20.65 ms | |
192.168.30.20 | wait/io/file/sql/io_cache | 2172 | 120.08 ms | 55.28 us | 26.35 ms | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 45 | 31.66 ms | 703.60 us | 3.42 ms | |
192.168.30.20 | wait/io/table/sql/handler | 7268 | 31.33 ms | 4.31 us | 9.57 ms | |
192.168.30.20 | wait/io/file/sql/binlog | 440 | 28.71 ms | 65.24 us | 23.52 ms | |
192.168.30.20 | wait/io/file/csv/metadata | 8 | 3.17 ms | 396.61 us | 1.98 ms | |
192.168.30.20 | wait/io/file/myisam/kfile | 8 | 1.16 ms | 145.05 us | 530.01 us | |
192.168.30.20 | wait/io/file/csv/data | 9 | 788.45 us | 87.61 us | 699.99 us | |
192.168.30.20 | wait/lock/table/sql/handler | 628 | 705.33 us | 1.12 us | 31.46 us | |
192.168.30.20 | wait/io/file/myisam/dfile | 4 | 122.43 us | 30.61 us | 71.70 us | |
192.168.30.20 | wait/lock/metadata/sql/mdl | 2 | 31.20 us | 15.60 us | 19.35 us | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 15.19 us | 7.59 us | 10.07 us | |
background | wait/io/file/innodb/innodb_log_file | 1035 | 6.44 s | 6.22 ms | 265.67 ms | |
background | wait/io/file/innodb/innodb_data_file | 2535 | 2.62 s | 1.03 ms | 213.56 ms | |
background | wait/io/file/innodb/innodb_temp_file | 240 | 329.85 ms | 1.37 ms | 25.72 ms | |
background | wait/io/file/sql/binlog_index | 36 | 44.83 ms | 1.25 ms | 28.98 ms | |
background | wait/io/file/sql/binlog | 37 | 32.28 ms | 872.35 us | 18.22 ms | |
background | wait/io/file/mysys/cnf | 5 | 1.45 ms | 290.70 us | 1.43 ms | |
background | wait/io/file/sql/ERRMSG | 5 | 1.41 ms | 281.41 us | 522.61 us | |
background | wait/io/file/sql/casetest | 15 | 757.75 us | 50.52 us | 686.74 us | |
background | wait/io/file/mysys/charset | 3 | 290.87 us | 96.96 us | 262.68 us | |
background | wait/io/file/sql/pid | 3 | 13.03 us | 4.34 us | 10.48 us | |
background | wait/io/file/sql/misc | 1 | 2.87 us | 2.87 us | 2.87 us |
|