SELECT * FROM `waits_by_host_by_latency`
|
host | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
192.168.30.20 | wait/io/file/sql/ERRMSG | 45 | 456.85 ms | 10.15 ms | 433.41 ms | |
192.168.30.20 | wait/io/file/innodb/innodb_temp_file | 24 | 204.47 ms | 8.52 ms | 24.57 ms | |
192.168.30.20 | wait/io/file/innodb/innodb_data_file | 205 | 134.64 ms | 656.80 us | 33.95 ms | |
192.168.30.20 | wait/io/file/sql/binlog | 90 | 64.27 ms | 714.10 us | 13.83 ms | |
192.168.30.20 | wait/io/table/sql/handler | 12 | 4.37 ms | 363.84 us | 2.99 ms | |
192.168.30.20 | wait/io/file/csv/metadata | 8 | 2.29 ms | 286.72 us | 1.36 ms | |
192.168.30.20 | wait/io/file/csv/data | 4 | 618.03 us | 154.51 us | 509.95 us | |
192.168.30.20 | wait/io/file/sql/misc | 3 | 372.70 us | 124.23 us | 332.75 us | |
192.168.30.20 | wait/lock/table/sql/handler | 44 | 53.25 us | 1.21 us | 2.58 us | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 11.22 us | 5.61 us | 9.40 us | |
background | wait/io/file/innodb/innodb_log_file | 386 | 2.65 s | 6.85 ms | 613.06 ms | |
background | wait/io/file/innodb/innodb_data_file | 1715 | 1.31 s | 766.51 us | 209.04 ms | |
background | wait/io/file/innodb/innodb_temp_file | 87 | 374.59 ms | 4.31 ms | 31.01 ms | |
background | wait/io/file/sql/binlog_index | 36 | 55.21 ms | 1.53 ms | 34.13 ms | |
background | wait/io/file/sql/binlog | 37 | 36.70 ms | 991.78 us | 18.16 ms | |
background | wait/io/file/mysys/cnf | 5 | 1.32 ms | 263.42 us | 1.29 ms | |
background | wait/io/file/sql/ERRMSG | 5 | 1.29 ms | 258.75 us | 395.48 us | |
background | wait/io/file/sql/casetest | 15 | 913.43 us | 60.90 us | 852.84 us | |
background | wait/io/file/mysys/charset | 3 | 241.19 us | 80.40 us | 230.00 us | |
background | wait/io/file/sql/pid | 3 | 47.58 us | 15.86 us | 36.90 us | |
background | wait/io/file/sql/misc | 1 | 12.44 us | 12.44 us | 12.44 us |
|