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_temp_file | 46 | 461.67 ms | 10.04 ms | 35.67 ms | |
192.168.30.20 | wait/io/file/innodb/innodb_data_file | 399 | 113.50 ms | 284.46 us | 20.65 ms | |
192.168.30.20 | wait/io/file/sql/io_cache | 644 | 29.45 ms | 45.72 us | 8.65 ms | |
192.168.30.20 | wait/io/table/sql/handler | 2487 | 23.03 ms | 9.26 us | 9.57 ms | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 25 | 13.76 ms | 550.30 us | 2.92 ms | |
192.168.30.20 | wait/io/file/sql/binlog | 168 | 3.33 ms | 19.83 us | 344.11 us | |
192.168.30.20 | wait/io/file/csv/metadata | 8 | 3.17 ms | 396.61 us | 1.98 ms | |
192.168.30.20 | wait/io/file/myisam/kfile | 4 | 582.27 us | 145.57 us | 523.61 us | |
192.168.30.20 | wait/lock/table/sql/handler | 383 | 440.82 us | 1.15 us | 31.46 us | |
192.168.30.20 | wait/io/file/csv/data | 4 | 59.93 us | 14.98 us | 25.19 us | |
192.168.30.20 | wait/io/file/myisam/dfile | 2 | 49.52 us | 24.76 us | 48.18 us | |
192.168.30.20 | wait/lock/metadata/sql/mdl | 2 | 31.20 us | 15.60 us | 19.35 us | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 15.19 us | 7.59 us | 10.07 us | |
background | wait/io/file/innodb/innodb_log_file | 703 | 4.48 s | 6.37 ms | 265.67 ms | |
background | wait/io/file/innodb/innodb_data_file | 2076 | 1.74 s | 838.31 us | 213.56 ms | |
background | wait/io/file/innodb/innodb_temp_file | 218 | 328.64 ms | 1.51 ms | 25.72 ms | |
background | wait/io/file/sql/binlog_index | 36 | 44.83 ms | 1.25 ms | 28.98 ms | |
background | wait/io/file/sql/binlog | 37 | 32.28 ms | 872.35 us | 18.22 ms | |
background | wait/io/file/mysys/cnf | 5 | 1.45 ms | 290.70 us | 1.43 ms | |
background | wait/io/file/sql/ERRMSG | 5 | 1.41 ms | 281.41 us | 522.61 us | |
background | wait/io/file/sql/casetest | 15 | 757.75 us | 50.52 us | 686.74 us | |
background | wait/io/file/mysys/charset | 3 | 290.87 us | 96.96 us | 262.68 us | |
background | wait/io/file/sql/pid | 3 | 13.03 us | 4.34 us | 10.48 us | |
background | wait/io/file/sql/misc | 1 | 2.87 us | 2.87 us | 2.87 us |
|