SELECT * FROM `x$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 | 440 | 510376197408 | 30182736672 | |
192.168.30.20 | wait/io/file/innodb/innodb_temp_file | 18 | 194493246816 | 32726664960 | |
192.168.30.20 | wait/io/file/sql/binlog | 422 | 186528164592 | 19549278672 | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 60 | 40981881600 | 2740245024 | |
192.168.30.20 | wait/io/file/sql/io_cache | 262 | 9236249088 | 1956218880 | |
192.168.30.20 | wait/io/file/sql/misc | 3 | 212647248 | 174205680 | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 5005440 | 2949408 | |
background | wait/io/file/innodb/innodb_log_file | 762 | 5049851039904 | 702658584144 | |
background | wait/io/file/innodb/innodb_data_file | 2313 | 3295256088432 | 260410094208 | |
background | wait/io/file/innodb/innodb_temp_file | 128 | 477063087072 | 91363610976 | |
background | wait/io/file/sql/binlog_index | 36 | 53129153616 | 30405174096 | |
background | wait/io/file/sql/binlog | 37 | 37121717424 | 18991388064 | |
background | wait/io/file/sql/ERRMSG | 5 | 1193332272 | 428328384 | |
background | wait/io/file/sql/casetest | 15 | 756694224 | 691358976 | |
background | wait/io/file/mysys/cnf | 5 | 620978688 | 585911040 | |
background | wait/io/file/mysys/charset | 3 | 266793648 | 254642784 | |
background | wait/io/file/sql/pid | 3 | 48508416 | 38550336 | |
background | wait/io/file/sql/misc | 1 | 13172016 | 13172016 |
|