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 | 8 | 87.53 ms | 34.33 ms | |
192.168.30.20 | wait/io/file/innodb/innodb_data_file | 95 | 37.74 ms | 7.46 ms | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 20 | 5.77 ms | 689.46 us | |
192.168.30.20 | wait/io/file/sql/io_cache | 30 | 1.21 ms | 521.95 us | |
192.168.30.20 | wait/io/file/sql/binlog | 8 | 203.24 us | 179.34 us | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 145.22 us | 143.54 us | |
background | wait/io/file/innodb/innodb_data_file | 1457 | 701.03 ms | 218.59 ms | |
background | wait/io/file/innodb/innodb_log_file | 110 | 563.64 ms | 52.20 ms | |
background | wait/io/file/innodb/innodb_temp_file | 86 | 328.54 ms | 35.82 ms | |
background | wait/io/file/sql/binlog_index | 36 | 40.96 ms | 24.97 ms | |
background | wait/io/file/sql/binlog | 37 | 31.23 ms | 16.44 ms | |
background | wait/io/file/mysys/cnf | 5 | 1.95 ms | 1.90 ms | |
background | wait/io/file/sql/ERRMSG | 5 | 1.32 ms | 485.88 us | |
background | wait/io/file/sql/casetest | 15 | 1.02 ms | 925.72 us | |
background | wait/io/file/mysys/charset | 3 | 262.33 us | 235.10 us | |
background | wait/io/file/sql/pid | 3 | 15.86 us | 12.63 us | |
background | wait/io/file/sql/misc | 1 | 3.94 us | 3.94 us |
|