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 | 987973 | 628.15 ms | 635.71 ns | 7.51 ms | |
192.168.30.20 | wait/io/file/innodb/innodb_temp_file | 16 | 182.84 ms | 11.43 ms | 37.67 ms | |
192.168.30.20 | wait/io/file/innodb/innodb_data_file | 404 | 112.47 ms | 278.38 us | 10.69 ms | |
192.168.30.20 | wait/io/file/sql/binlog | 72 | 34.57 ms | 480.20 us | 14.70 ms | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 30 | 20.26 ms | 675.23 us | 4.00 ms | |
192.168.30.20 | wait/io/file/sql/io_cache | 266 | 9.16 ms | 34.44 us | 4.43 ms | |
192.168.30.20 | wait/io/file/csv/metadata | 8 | 1.25 ms | 156.13 us | 717.03 us | |
192.168.30.20 | wait/lock/table/sql/handler | 1137 | 1.14 ms | 1.01 us | 21.91 us | |
192.168.30.20 | wait/io/file/myisam/kfile | 4 | 814.14 us | 203.54 us | 788.29 us | |
192.168.30.20 | wait/io/file/myisam/dfile | 8 | 314.02 us | 39.25 us | 291.82 us | |
192.168.30.20 | wait/io/file/csv/data | 4 | 312.11 us | 78.03 us | 279.37 us | |
192.168.30.20 | wait/io/file/sql/misc | 2 | 27.31 us | 13.66 us | 15.01 us | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 5.21 us | 2.60 us | 3.41 us | |
background | wait/io/file/innodb/innodb_log_file | 1351 | 7.29 s | 5.40 ms | 116.20 ms | |
background | wait/io/file/innodb/innodb_data_file | 3142 | 2.88 s | 916.73 us | 234.40 ms | |
background | wait/io/file/innodb/innodb_temp_file | 217 | 473.02 ms | 2.18 ms | 57.66 ms | |
background | wait/io/file/sql/binlog_index | 36 | 58.51 ms | 1.63 ms | 35.55 ms | |
background | wait/io/file/sql/binlog | 37 | 40.72 ms | 1.10 ms | 20.91 ms | |
background | wait/io/file/sql/ERRMSG | 5 | 1.24 ms | 248.42 us | 419.45 us | |
background | wait/io/file/sql/casetest | 15 | 1.12 ms | 74.37 us | 1.05 ms | |
background | wait/io/file/mysys/cnf | 5 | 575.30 us | 115.06 us | 559.23 us | |
background | wait/io/file/mysys/charset | 3 | 297.09 us | 99.03 us | 281.40 us | |
background | wait/io/file/sql/pid | 3 | 44.13 us | 14.71 us | 34.66 us | |
background | wait/io/file/sql/misc | 1 | 6.83 us | 6.83 us | 6.83 us |
|