SELECT * FROM `x$host_summary_by_file_io_type`
|
host | event_name | total | total_latency | max_latency | |
---|---|---|---|---|---|
192.168.30.20 | wait/io/file/sql/binlog | 204 | 176218091808 | 134361908736 | |
192.168.30.20 | wait/io/file/innodb/innodb_data_file | 167 | 70931470368 | 7835475120 | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 35 | 27963451296 | 2768864736 | |
192.168.30.20 | wait/io/file/innodb/innodb_temp_file | 2 | 21018323040 | 20958118368 | |
192.168.30.20 | wait/io/file/sql/misc | 2 | 531754080 | 519214608 | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 4279440 | 2486352 | |
background | wait/io/file/innodb/innodb_log_file | 312 | 2425612670976 | 139697148096 | |
background | wait/io/file/innodb/innodb_data_file | 1691 | 1929302189760 | 326376179184 | |
background | wait/io/file/innodb/innodb_temp_file | 81 | 555861496080 | 36421306944 | |
background | wait/io/file/sql/binlog | 37 | 74200183728 | 42238673136 | |
background | wait/io/file/sql/binlog_index | 36 | 72740055168 | 37095840672 | |
background | wait/io/file/mysys/cnf | 5 | 7863302304 | 7806456240 | |
background | wait/io/file/sql/ERRMSG | 5 | 2217193440 | 1067954448 | |
background | wait/io/file/sql/casetest | 15 | 951154512 | 865178160 | |
background | wait/io/file/mysys/charset | 3 | 219175968 | 199181664 | |
background | wait/io/file/sql/pid | 3 | 49020576 | 38081472 | |
background | wait/io/file/sql/misc | 1 | 12204192 | 12204192 |
|