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 | 42 | 413.22 ms | 9.84 ms | 30.10 ms | |
192.168.30.20 | wait/io/file/innodb/innodb_data_file | 506 | 186.08 ms | 367.74 us | 54.84 ms | |
192.168.30.20 | wait/io/file/sql/io_cache | 588 | 166.13 ms | 282.54 us | 47.57 ms | |
192.168.30.20 | wait/io/table/sql/handler | 20335 | 124.31 ms | 6.11 us | 55.89 ms | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 75 | 32.03 ms | 427.03 us | 3.28 ms | |
192.168.30.20 | wait/io/file/sql/binlog | 176 | 30.91 ms | 175.65 us | 13.11 ms | |
192.168.30.20 | wait/lock/table/sql/handler | 2298 | 2.94 ms | 1.28 us | 421.35 us | |
192.168.30.20 | wait/io/file/myisam/dfile | 33 | 767.20 us | 23.25 us | 717.41 us | |
192.168.30.20 | wait/io/file/myisam/kfile | 8 | 394.83 us | 49.35 us | 181.51 us | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 168.75 us | 84.38 us | 167.47 us | |
192.168.30.20 | wait/lock/metadata/sql/mdl | 2 | 59.06 us | 29.53 us | 29.83 us | |
192.168.30.20 | wait/io/file/sql/misc | 2 | 23.46 us | 11.73 us | 14.02 us | |
background | wait/io/file/innodb/innodb_log_file | 1022 | 5.97 s | 5.84 ms | 183.75 ms | |
background | wait/io/file/innodb/innodb_data_file | 2849 | 4.41 s | 1.55 ms | 440.77 ms | |
background | wait/io/file/innodb/innodb_temp_file | 599 | 315.62 ms | 526.91 us | 20.41 ms | |
background | wait/io/file/sql/binlog_index | 36 | 58.15 ms | 1.62 ms | 40.00 ms | |
background | wait/io/file/sql/binlog | 37 | 32.25 ms | 871.62 us | 15.10 ms | |
background | wait/io/file/sql/ERRMSG | 5 | 1.16 ms | 231.58 us | 445.36 us | |
background | wait/io/file/sql/casetest | 15 | 893.49 us | 59.57 us | 831.22 us | |
background | wait/io/file/mysys/cnf | 5 | 614.48 us | 122.89 us | 590.59 us | |
background | wait/io/file/mysys/charset | 3 | 242.49 us | 80.83 us | 223.66 us | |
background | wait/io/file/sql/pid | 3 | 13.65 us | 4.55 us | 11.18 us | |
background | wait/io/file/sql/misc | 1 | 2.72 us | 2.72 us | 2.72 us |
|