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 | 360800757504 | 35522260224 | |
192.168.30.20 | wait/io/file/innodb/innodb_data_file | 480 | 205035726720 | 22431159696 | |
192.168.30.20 | wait/io/file/sql/binlog | 750 | 119466961152 | 19981291968 | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 30 | 17488523712 | 3363210576 | |
192.168.30.20 | wait/io/file/myisam/kfile | 24 | 2057909040 | 882955920 | |
192.168.30.20 | wait/io/file/sql/io_cache | 38 | 795173808 | 61120752 | |
192.168.30.20 | wait/io/file/myisam/dfile | 81 | 716523984 | 238929504 | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 207642864 | 205717248 | |
192.168.30.20 | wait/io/file/sql/misc | 1 | 16185312 | 16185312 | |
background | wait/io/file/innodb/innodb_log_file | 973 | 4852499526864 | 119157586944 | |
background | wait/io/file/innodb/innodb_data_file | 2862 | 2153955434400 | 77561821392 | |
background | wait/io/file/innodb/innodb_temp_file | 226 | 265207859664 | 16466568624 | |
background | wait/io/file/sql/binlog | 55 | 30414629520 | 15574272384 | |
background | wait/io/file/sql/ERRMSG | 5 | 1449855792 | 543859008 | |
background | wait/io/file/mysys/cnf | 5 | 1132472880 | 1104593952 | |
background | wait/io/file/sql/casetest | 15 | 982810224 | 902149776 | |
background | wait/io/file/sql/binlog_index | 21 | 762638976 | 241050480 | |
background | wait/io/file/mysys/charset | 3 | 357815040 | 344602368 | |
background | wait/io/file/sql/pid | 3 | 17021136 | 13232208 | |
background | wait/io/file/sql/misc | 1 | 5800080 | 5800080 |
|