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 | 44 | 504.19 ms | 88.77 ms | |
192.168.30.20 | wait/io/file/innodb/innodb_data_file | 334 | 153.56 ms | 13.57 ms | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 20 | 29.14 ms | 9.88 ms | |
192.168.30.20 | wait/io/file/sql/binlog | 118 | 14.52 ms | 13.10 ms | |
192.168.30.20 | wait/io/file/sql/io_cache | 80 | 6.48 ms | 2.45 ms | |
192.168.30.20 | wait/io/file/myisam/kfile | 8 | 2.10 ms | 1.80 ms | |
192.168.30.20 | wait/io/file/csv/metadata | 4 | 656.34 us | 540.84 us | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 317.90 us | 316.10 us | |
192.168.30.20 | wait/io/file/sql/misc | 1 | 312.69 us | 312.69 us | |
192.168.30.20 | wait/io/file/myisam/dfile | 4 | 51.55 us | 28.55 us | |
192.168.30.20 | wait/io/file/csv/data | 2 | 39.83 us | 32.49 us | |
background | wait/io/file/innodb/innodb_log_file | 322 | 1.72 s | 130.58 ms | |
background | wait/io/file/innodb/innodb_data_file | 1660 | 1.18 s | 259.71 ms | |
background | wait/io/file/innodb/innodb_temp_file | 101 | 380.75 ms | 39.00 ms | |
background | wait/io/file/sql/binlog_index | 36 | 46.80 ms | 28.16 ms | |
background | wait/io/file/sql/binlog | 37 | 39.03 ms | 21.79 ms | |
background | wait/io/file/sql/ERRMSG | 5 | 2.21 ms | 1.35 ms | |
background | wait/io/file/sql/casetest | 15 | 768.66 us | 706.85 us | |
background | wait/io/file/mysys/cnf | 5 | 566.29 us | 544.07 us | |
background | wait/io/file/mysys/charset | 3 | 269.23 us | 253.66 us | |
background | wait/io/file/sql/pid | 3 | 47.60 us | 37.07 us | |
background | wait/io/file/sql/misc | 1 | 11.72 us | 11.72 us |
|