SELECT * FROM `waits_by_host_by_latency`
|
host | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
192.168.30.20 | wait/io/table/sql/handler | 456133 | 360.69 ms | 790.68 ns | 20.68 ms | |
192.168.30.20 | wait/io/file/innodb/innodb_temp_file | 22 | 273.23 ms | 12.42 ms | 38.20 ms | |
192.168.30.20 | wait/io/file/innodb/innodb_data_file | 576 | 158.92 ms | 275.91 us | 6.27 ms | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 45 | 47.35 ms | 1.05 ms | 4.68 ms | |
192.168.30.20 | wait/io/file/sql/binlog | 366 | 39.38 ms | 107.59 us | 20.28 ms | |
192.168.30.20 | wait/io/file/myisam/dfile | 53531 | 16.49 ms | 307.82 ns | 1.93 ms | |
192.168.30.20 | wait/io/file/myisam/kfile | 16 | 3.63 ms | 226.84 us | 1.73 ms | |
192.168.30.20 | wait/io/file/csv/metadata | 8 | 2.55 ms | 318.45 us | 1.37 ms | |
192.168.30.20 | wait/io/file/csv/data | 21 | 2.34 ms | 111.51 us | 2.06 ms | |
192.168.30.20 | wait/io/file/sql/io_cache | 104 | 2.34 ms | 22.48 us | 171.84 us | |
192.168.30.20 | wait/lock/table/sql/handler | 730 | 723.17 us | 990.53 ns | 6.48 us | |
192.168.30.20 | wait/io/file/sql/misc | 1 | 574.93 us | 574.93 us | 574.93 us | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 7.42 us | 3.71 us | 5.84 us | |
background | wait/io/file/innodb/innodb_log_file | 1033 | 6.31 s | 6.11 ms | 285.64 ms | |
background | wait/io/file/innodb/innodb_data_file | 2848 | 4.25 s | 1.49 ms | 239.17 ms | |
background | wait/io/file/innodb/innodb_temp_file | 100 | 345.06 ms | 3.45 ms | 25.82 ms | |
background | wait/io/file/sql/binlog_index | 36 | 48.48 ms | 1.35 ms | 28.86 ms | |
background | wait/io/file/sql/binlog | 37 | 41.44 ms | 1.12 ms | 19.22 ms | |
background | wait/io/file/mysys/cnf | 5 | 1.61 ms | 322.63 us | 1.60 ms | |
background | wait/io/file/sql/ERRMSG | 5 | 1.46 ms | 292.43 us | 551.98 us | |
background | wait/io/file/sql/casetest | 15 | 786.71 us | 52.45 us | 718.18 us | |
background | wait/io/file/mysys/charset | 3 | 320.45 us | 106.82 us | 281.45 us | |
background | wait/io/file/sql/pid | 3 | 48.54 us | 16.18 us | 38.06 us | |
background | wait/io/file/sql/misc | 1 | 10.71 us | 10.71 us | 10.71 us |
|