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 | 9472811 | 4.60 s | 485.76 ns | 6.84 ms | |
192.168.30.20 | wait/io/file/innodb/innodb_temp_file | 44 | 465.23 ms | 10.57 ms | 36.42 ms | |
192.168.30.20 | wait/io/file/innodb/innodb_data_file | 628 | 237.46 ms | 378.12 us | 26.69 ms | |
192.168.30.20 | wait/io/file/sql/binlog | 434 | 49.87 ms | 114.92 us | 15.73 ms | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 50 | 40.22 ms | 804.37 us | 3.89 ms | |
192.168.30.20 | wait/io/file/csv/metadata | 8 | 8.17 ms | 1.02 ms | 5.75 ms | |
192.168.30.20 | wait/io/file/sql/io_cache | 78 | 3.85 ms | 49.36 us | 1.64 ms | |
192.168.30.20 | wait/io/file/myisam/kfile | 16 | 3.20 ms | 200.20 us | 2.31 ms | |
192.168.30.20 | wait/lock/table/sql/handler | 1497 | 2.02 ms | 1.35 us | 406.02 us | |
192.168.30.20 | wait/io/file/csv/data | 48 | 499.65 us | 10.41 us | 142.32 us | |
192.168.30.20 | wait/io/file/myisam/dfile | 47 | 395.83 us | 8.42 us | 270.28 us | |
192.168.30.20 | wait/io/file/sql/misc | 2 | 44.40 us | 22.20 us | 32.27 us | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 4.65 us | 2.32 us | 3.05 us | |
background | wait/io/file/innodb/innodb_log_file | 1266 | 7.59 s | 5.99 ms | 117.14 ms | |
background | wait/io/file/innodb/innodb_data_file | 3044 | 5.59 s | 1.84 ms | 224.41 ms | |
background | wait/io/file/innodb/innodb_temp_file | 198 | 394.36 ms | 1.99 ms | 31.65 ms | |
background | wait/io/file/sql/binlog_index | 36 | 55.19 ms | 1.53 ms | 29.42 ms | |
background | wait/io/file/sql/binlog | 37 | 40.50 ms | 1.09 ms | 23.02 ms | |
background | wait/io/file/sql/ERRMSG | 5 | 1.33 ms | 265.56 us | 561.37 us | |
background | wait/io/file/mysys/cnf | 5 | 1.10 ms | 219.63 us | 1.08 ms | |
background | wait/io/file/sql/casetest | 15 | 836.29 us | 55.75 us | 755.94 us | |
background | wait/io/file/mysys/charset | 3 | 333.86 us | 111.29 us | 318.01 us | |
background | wait/io/file/sql/pid | 3 | 56.95 us | 18.98 us | 36.71 us | |
background | wait/io/file/sql/misc | 1 | 12.81 us | 12.81 us | 12.81 us |
|