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 | 387 | 208.19 ms | 537.96 us | 27.04 ms | |
192.168.30.20 | wait/io/file/sql/binlog | 559 | 159.79 ms | 285.85 us | 20.37 ms | |
192.168.30.20 | wait/io/file/innodb/innodb_temp_file | 12 | 117.36 ms | 9.78 ms | 26.26 ms | |
192.168.30.20 | wait/io/file/sql/io_cache | 69 | 65.78 ms | 953.34 us | 61.87 ms | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 55 | 39.56 ms | 719.25 us | 4.42 ms | |
192.168.30.20 | wait/io/table/sql/handler | 529 | 25.19 ms | 47.63 us | 5.50 ms | |
192.168.30.20 | wait/io/file/csv/metadata | 8 | 2.75 ms | 344.21 us | 1.95 ms | |
192.168.30.20 | wait/io/file/sql/misc | 8 | 458.47 us | 57.31 us | 351.56 us | |
192.168.30.20 | wait/io/file/csv/data | 7 | 425.58 us | 60.80 us | 371.83 us | |
192.168.30.20 | wait/lock/table/sql/handler | 286 | 406.12 us | 1.42 us | 78.29 us | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 264.98 us | 132.49 us | 263.43 us | |
background | wait/io/file/innodb/innodb_log_file | 590 | 3.50 s | 5.93 ms | 189.64 ms | |
background | wait/io/file/innodb/innodb_data_file | 2166 | 2.72 s | 1.26 ms | 198.43 ms | |
background | wait/io/file/innodb/innodb_temp_file | 102 | 319.70 ms | 3.13 ms | 23.22 ms | |
background | wait/io/file/sql/binlog_index | 36 | 49.06 ms | 1.36 ms | 26.92 ms | |
background | wait/io/file/sql/binlog | 37 | 29.63 ms | 800.81 us | 15.38 ms | |
background | wait/io/file/sql/ERRMSG | 5 | 1.21 ms | 241.88 us | 428.72 us | |
background | wait/io/file/sql/casetest | 15 | 742.06 us | 49.47 us | 665.69 us | |
background | wait/io/file/mysys/cnf | 5 | 531.93 us | 106.39 us | 515.44 us | |
background | wait/io/file/mysys/charset | 3 | 251.36 us | 83.79 us | 231.93 us | |
background | wait/io/file/sql/pid | 3 | 12.65 us | 4.22 us | 10.46 us | |
background | wait/io/file/sql/misc | 1 | 5.44 us | 5.44 us | 5.44 us |
|