SELECT * FROM `host_summary_by_file_io_type`
|
host | event_name | total | total_latency | max_latency | |
---|---|---|---|---|---|
192.168.30.20 | wait/io/file/innodb/innodb_temp_file | 84 | 717.05 ms | 63.62 ms | |
192.168.30.20 | wait/io/file/innodb/innodb_data_file | 532 | 212.75 ms | 28.99 ms | |
192.168.30.20 | wait/io/file/sql/binlog | 452 | 154.82 ms | 43.49 ms | |
192.168.30.20 | wait/io/file/sql/io_cache | 856 | 150.04 ms | 87.97 ms | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 80 | 48.58 ms | 3.01 ms | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 277.21 us | 275.62 us | |
192.168.30.20 | wait/io/file/sql/misc | 2 | 43.63 us | 30.62 us | |
background | wait/io/file/innodb/innodb_log_file | 732 | 3.79 s | 38.97 ms | |
background | wait/io/file/innodb/innodb_data_file | 2257 | 2.22 s | 193.06 ms | |
background | wait/io/file/innodb/innodb_temp_file | 985 | 349.96 ms | 24.26 ms | |
background | wait/io/file/sql/binlog | 31 | 36.41 ms | 20.80 ms | |
background | wait/io/file/sql/binlog_index | 21 | 1.41 ms | 426.53 us | |
background | wait/io/file/sql/ERRMSG | 5 | 1.20 ms | 512.70 us | |
background | wait/io/file/sql/casetest | 15 | 1.15 ms | 1.09 ms | |
background | wait/io/file/mysys/charset | 3 | 255.76 us | 243.99 us | |
background | wait/io/file/mysys/cnf | 5 | 167.69 us | 152.75 us | |
background | wait/io/file/sql/pid | 3 | 26.64 us | 20.53 us | |
background | wait/io/file/sql/misc | 1 | 13.71 us | 13.71 us |
|