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_data_file | 100 | 42.25 ms | 4.85 ms | |
192.168.30.20 | wait/io/file/innodb/innodb_temp_file | 4 | 37.26 ms | 21.01 ms | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 20 | 8.66 ms | 1.32 ms | |
192.168.30.20 | wait/io/file/sql/binlog | 24 | 2.79 ms | 1.91 ms | |
192.168.30.20 | wait/io/file/sql/io_cache | 48 | 1.64 ms | 292.76 us | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 4.55 us | 2.96 us | |
background | wait/io/file/innodb/innodb_log_file | 173 | 1.60 s | 717.03 ms | |
background | wait/io/file/innodb/innodb_data_file | 1523 | 825.59 ms | 211.14 ms | |
background | wait/io/file/innodb/innodb_temp_file | 82 | 354.21 ms | 27.11 ms | |
background | wait/io/file/sql/binlog | 37 | 52.76 ms | 31.94 ms | |
background | wait/io/file/sql/binlog_index | 36 | 45.10 ms | 23.76 ms | |
background | wait/io/file/mysys/cnf | 5 | 1.72 ms | 1.71 ms | |
background | wait/io/file/sql/ERRMSG | 5 | 1.31 ms | 401.69 us | |
background | wait/io/file/sql/casetest | 15 | 937.51 us | 864.43 us | |
background | wait/io/file/mysys/charset | 3 | 283.03 us | 273.07 us | |
background | wait/io/file/sql/pid | 3 | 52.97 us | 35.30 us | |
background | wait/io/file/sql/misc | 1 | 4.96 us | 4.96 us |
|