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_temp_file | 46 | 538008929568 | 75335976144 | |
192.168.30.20 | wait/io/file/innodb/innodb_data_file | 360 | 168533068704 | 36703852944 | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 50 | 36800822784 | 4277304240 | |
192.168.30.20 | wait/io/file/sql/binlog | 280 | 32168983440 | 15708300960 | |
192.168.30.20 | wait/io/file/csv/metadata | 8 | 806057472 | 466282608 | |
192.168.30.20 | wait/io/file/sql/misc | 1 | 253549296 | 253549296 | |
192.168.30.20 | wait/io/file/csv/data | 4 | 30249648 | 9227328 | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 15396480 | 13359456 | |
background | wait/io/file/innodb/innodb_log_file | 632 | 3499804625856 | 41200234416 | |
background | wait/io/file/innodb/innodb_data_file | 2149 | 2169477293808 | 218527803120 | |
background | wait/io/file/innodb/innodb_temp_file | 118 | 351638728320 | 46630821600 | |
background | wait/io/file/sql/binlog_index | 36 | 58986182112 | 38680576176 | |
background | wait/io/file/sql/binlog | 37 | 34822324416 | 16751351760 | |
background | wait/io/file/sql/casetest | 15 | 1324576704 | 1246439568 | |
background | wait/io/file/sql/ERRMSG | 5 | 1262132784 | 543779280 | |
background | wait/io/file/mysys/cnf | 5 | 637156080 | 604287552 | |
background | wait/io/file/mysys/charset | 3 | 324928560 | 305747904 | |
background | wait/io/file/sql/pid | 3 | 12249072 | 9874128 | |
background | wait/io/file/sql/misc | 1 | 3645312 | 3645312 |
|