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 | 130 | 77.32 ms | 594.73 us | 4.87 ms | |
192.168.30.20 | wait/io/file/innodb/innodb_temp_file | 4 | 46.45 ms | 11.61 ms | 34.72 ms | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 20 | 10.30 ms | 515.04 us | 2.57 ms | |
192.168.30.20 | wait/io/table/sql/handler | 16 | 750.87 us | 46.93 us | 671.18 us | |
192.168.30.20 | wait/io/file/csv/metadata | 4 | 719.79 us | 179.95 us | 550.50 us | |
192.168.30.20 | wait/io/file/csv/data | 13 | 345.24 us | 26.56 us | 286.67 us | |
192.168.30.20 | wait/io/file/sql/binlog | 40 | 222.81 us | 5.57 us | 28.83 us | |
192.168.30.20 | wait/lock/table/sql/handler | 7 | 10.82 us | 1.55 us | 3.03 us | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 6.05 us | 3.03 us | 4.07 us | |
background | wait/io/file/innodb/innodb_data_file | 1604 | 1.84 s | 1.15 ms | 532.47 ms | |
background | wait/io/file/innodb/innodb_log_file | 219 | 1.25 s | 5.70 ms | 34.92 ms | |
background | wait/io/file/innodb/innodb_temp_file | 82 | 398.24 ms | 4.86 ms | 28.38 ms | |
background | wait/io/file/sql/binlog_index | 36 | 51.01 ms | 1.42 ms | 31.18 ms | |
background | wait/io/file/sql/binlog | 37 | 40.71 ms | 1.10 ms | 21.13 ms | |
background | wait/io/file/sql/ERRMSG | 5 | 1.42 ms | 284.24 us | 488.57 us | |
background | wait/io/file/mysys/cnf | 5 | 923.68 us | 184.74 us | 907.46 us | |
background | wait/io/file/sql/casetest | 15 | 822.66 us | 54.84 us | 760.79 us | |
background | wait/io/file/mysys/charset | 3 | 312.01 us | 104.00 us | 285.17 us | |
background | wait/io/file/sql/pid | 3 | 62.47 us | 20.82 us | 36.67 us | |
background | wait/io/file/sql/misc | 1 | 13.62 us | 13.62 us | 13.62 us |
|