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 | 133 | 48.06 ms | 6.22 ms | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 20 | 6.76 ms | 959.61 us | |
192.168.30.20 | wait/io/file/csv/metadata | 8 | 768.51 us | 450.74 us | |
192.168.30.20 | wait/io/file/csv/data | 4 | 265.25 us | 235.67 us | |
192.168.30.20 | wait/io/file/sql/binlog | 4 | 31.23 us | 26.97 us | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 3.92 us | 2.48 us | |
background | wait/io/file/innodb/innodb_log_file | 170 | 855.63 ms | 102.11 ms | |
background | wait/io/file/innodb/innodb_data_file | 1442 | 664.17 ms | 224.32 ms | |
background | wait/io/file/innodb/innodb_temp_file | 80 | 344.72 ms | 26.36 ms | |
background | wait/io/file/sql/binlog_index | 36 | 53.04 ms | 29.30 ms | |
background | wait/io/file/sql/binlog | 37 | 33.93 ms | 15.69 ms | |
background | wait/io/file/sql/casetest | 15 | 1.23 ms | 1.16 ms | |
background | wait/io/file/sql/ERRMSG | 5 | 1.16 ms | 482.41 us | |
background | wait/io/file/mysys/cnf | 5 | 626.88 us | 609.18 us | |
background | wait/io/file/mysys/charset | 3 | 267.15 us | 252.95 us | |
background | wait/io/file/sql/pid | 3 | 92.89 us | 57.60 us | |
background | wait/io/file/sql/misc | 1 | 13.67 us | 13.67 us |
|