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 | 302 | 464.25 ms | 37.58 ms | |
192.168.30.20 | wait/io/file/sql/binlog | 184 | 250.20 ms | 36.44 ms | |
192.168.30.20 | wait/io/file/innodb/innodb_temp_file | 22 | 212.98 ms | 36.79 ms | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 50 | 39.22 ms | 5.21 ms | |
192.168.30.20 | wait/io/file/myisam/kfile | 4 | 784.25 us | 723.22 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/myisam/dfile | 2 | 57.06 us | 55.66 us | |
192.168.30.20 | wait/io/file/sql/misc | 2 | 24.19 us | 12.32 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 | 1026 | 5.54 s | 102.11 ms | |
background | wait/io/file/innodb/innodb_data_file | 2945 | 4.26 s | 224.32 ms | |
background | wait/io/file/innodb/innodb_temp_file | 94 | 345.35 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 |
|