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 | 169 | 82.48 ms | 488.07 us | 7.24 ms | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 15 | 30.55 ms | 2.04 ms | 6.62 ms | |
192.168.30.20 | wait/io/file/innodb/innodb_temp_file | 2 | 27.32 ms | 13.66 ms | 27.29 ms | |
192.168.30.20 | wait/io/table/sql/handler | 153 | 8.54 ms | 55.79 us | 4.30 ms | |
192.168.30.20 | wait/io/file/sql/io_cache | 66 | 2.42 ms | 36.70 us | 1.31 ms | |
192.168.30.20 | wait/io/file/sql/binlog | 24 | 2.28 ms | 94.83 us | 1.85 ms | |
192.168.30.20 | wait/lock/table/sql/handler | 84 | 104.40 us | 1.24 us | 13.77 us | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 12.02 us | 6.01 us | 10.18 us | |
background | wait/io/file/innodb/innodb_log_file | 168 | 1.03 s | 6.15 ms | 87.93 ms | |
background | wait/io/file/innodb/innodb_data_file | 1522 | 939.41 ms | 617.22 us | 343.76 ms | |
background | wait/io/file/innodb/innodb_temp_file | 169 | 583.16 ms | 3.45 ms | 43.33 ms | |
background | wait/io/file/sql/binlog_index | 36 | 86.13 ms | 2.39 ms | 43.05 ms | |
background | wait/io/file/sql/binlog | 37 | 73.26 ms | 1.98 ms | 41.52 ms | |
background | wait/io/file/sql/ERRMSG | 5 | 7.14 ms | 1.43 ms | 5.95 ms | |
background | wait/io/file/mysys/cnf | 5 | 3.08 ms | 616.78 us | 3.06 ms | |
background | wait/io/file/sql/casetest | 15 | 876.67 us | 58.44 us | 775.93 us | |
background | wait/io/file/mysys/charset | 3 | 320.63 us | 106.88 us | 289.53 us | |
background | wait/io/file/sql/pid | 3 | 17.59 us | 5.86 us | 14.24 us | |
background | wait/io/file/sql/misc | 1 | 13.45 us | 13.45 us | 13.45 us |
|