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 | 374 | 381.12 ms | 1.02 ms | 40.22 ms | |
192.168.30.20 | wait/io/file/sql/binlog | 148 | 188.73 ms | 1.28 ms | 20.39 ms | |
192.168.30.20 | wait/io/table/sql/handler | 7573 | 45.66 ms | 6.03 us | 6.36 ms | |
192.168.30.20 | wait/io/file/innodb/innodb_temp_file | 4 | 35.17 ms | 8.79 ms | 18.50 ms | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 20 | 21.07 ms | 1.05 ms | 4.32 ms | |
192.168.30.20 | wait/io/file/csv/metadata | 8 | 2.63 ms | 328.58 us | 1.19 ms | |
192.168.30.20 | wait/io/file/sql/io_cache | 66 | 2.63 ms | 39.81 us | 734.02 us | |
192.168.30.20 | wait/lock/table/sql/handler | 561 | 547.75 us | 976.27 ns | 4.52 us | |
192.168.30.20 | wait/io/file/csv/data | 12 | 171.48 us | 14.29 us | 39.79 us | |
192.168.30.20 | wait/io/file/sql/misc | 5 | 117.24 us | 23.45 us | 33.61 us | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 4.91 us | 2.46 us | 2.89 us | |
background | wait/io/file/innodb/innodb_log_file | 944 | 5.64 s | 5.98 ms | 42.23 ms | |
background | wait/io/file/innodb/innodb_data_file | 2646 | 4.29 s | 1.62 ms | 212.26 ms | |
background | wait/io/file/innodb/innodb_temp_file | 87 | 339.23 ms | 3.90 ms | 31.70 ms | |
background | wait/io/file/sql/binlog_index | 36 | 44.94 ms | 1.25 ms | 26.33 ms | |
background | wait/io/file/sql/binlog | 37 | 37.15 ms | 1.00 ms | 20.52 ms | |
background | wait/io/file/mysys/cnf | 5 | 5.38 ms | 1.08 ms | 5.36 ms | |
background | wait/io/file/sql/ERRMSG | 5 | 2.21 ms | 441.52 us | 1.34 ms | |
background | wait/io/file/sql/casetest | 15 | 771.58 us | 51.44 us | 694.34 us | |
background | wait/io/file/mysys/charset | 3 | 248.14 us | 82.71 us | 234.13 us | |
background | wait/io/file/sql/pid | 3 | 61.78 us | 20.59 us | 53.00 us | |
background | wait/io/file/sql/misc | 1 | 12.71 us | 12.71 us | 12.71 us |
|