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 | 8 | 96.02 ms | 12.00 ms | 40.68 ms | |
192.168.30.20 | wait/io/file/innodb/innodb_data_file | 182 | 60.56 ms | 332.74 us | 8.55 ms | |
192.168.30.20 | wait/io/table/sql/handler | 263 | 49.42 ms | 187.90 us | 41.77 ms | |
192.168.30.20 | wait/io/file/sql/binlog | 46 | 21.11 ms | 458.96 us | 20.82 ms | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 20 | 8.36 ms | 417.94 us | 2.59 ms | |
192.168.30.20 | wait/lock/table/sql/handler | 172 | 181.89 us | 1.06 us | 13.51 us | |
192.168.30.20 | wait/io/file/sql/misc | 1 | 14.87 us | 14.87 us | 14.87 us | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 5.40 us | 2.70 us | 3.22 us | |
background | wait/io/file/innodb/innodb_log_file | 350 | 1.78 s | 5.10 ms | 35.07 ms | |
background | wait/io/file/innodb/innodb_data_file | 1588 | 952.15 ms | 599.59 us | 226.00 ms | |
background | wait/io/file/innodb/innodb_temp_file | 82 | 320.72 ms | 3.91 ms | 24.52 ms | |
background | wait/io/file/sql/binlog_index | 36 | 50.64 ms | 1.41 ms | 29.78 ms | |
background | wait/io/file/sql/binlog | 37 | 34.03 ms | 919.60 us | 16.90 ms | |
background | wait/io/file/sql/ERRMSG | 5 | 1.39 ms | 277.26 us | 475.47 us | |
background | wait/io/file/sql/casetest | 15 | 887.83 us | 59.19 us | 803.11 us | |
background | wait/io/file/mysys/cnf | 5 | 790.14 us | 158.03 us | 769.42 us | |
background | wait/io/file/mysys/charset | 3 | 230.68 us | 76.89 us | 214.98 us | |
background | wait/io/file/sql/pid | 3 | 21.95 us | 7.32 us | 11.87 us | |
background | wait/io/file/sql/misc | 1 | 4.43 us | 4.43 us | 4.43 us |
|