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 | 8 | 77344643376 | 25651501392 | |
192.168.30.20 | wait/io/file/sql/io_cache | 69 | 65780538384 | 61872143520 | |
192.168.30.20 | wait/io/file/innodb/innodb_data_file | 98 | 53237008176 | 5845513344 | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 40 | 26736216144 | 4423606704 | |
192.168.30.20 | wait/io/file/sql/binlog | 174 | 15089207232 | 12535589088 | |
192.168.30.20 | wait/io/file/csv/metadata | 4 | 2564956944 | 1953453216 | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 264975216 | 263430288 | |
192.168.30.20 | wait/io/file/csv/data | 4 | 35397648 | 15215904 | |
192.168.30.20 | wait/io/file/sql/misc | 1 | 11977152 | 11977152 | |
background | wait/io/file/innodb/innodb_log_file | 113 | 817526264544 | 189642498672 | |
background | wait/io/file/innodb/innodb_data_file | 1493 | 697756060848 | 198428218032 | |
background | wait/io/file/innodb/innodb_temp_file | 100 | 319567207344 | 23220741984 | |
background | wait/io/file/sql/binlog_index | 36 | 49057689648 | 26916316416 | |
background | wait/io/file/sql/binlog | 37 | 29630042112 | 15381775200 | |
background | wait/io/file/sql/ERRMSG | 5 | 1209415152 | 428715408 | |
background | wait/io/file/sql/casetest | 15 | 742063872 | 665690256 | |
background | wait/io/file/mysys/cnf | 5 | 531927792 | 515436768 | |
background | wait/io/file/mysys/charset | 3 | 251355456 | 231932448 | |
background | wait/io/file/sql/pid | 3 | 12653520 | 10456512 | |
background | wait/io/file/sql/misc | 1 | 5436288 | 5436288 |
|