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 | 604 | 816705908832 | 42656919888 | |
192.168.30.20 | wait/io/file/innodb/innodb_temp_file | 70 | 732255821088 | 40232739888 | |
192.168.30.20 | wait/io/file/sql/binlog | 598 | 586471259616 | 33505697808 | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 60 | 37681343568 | 2487203664 | |
192.168.30.20 | wait/io/file/csv/data | 2 | 1603078224 | 1595143968 | |
192.168.30.20 | wait/io/file/csv/metadata | 4 | 410187888 | 346495248 | |
192.168.30.20 | wait/io/file/sql/misc | 4 | 73709856 | 31174704 | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 4344384 | 2588784 | |
background | wait/io/file/innodb/innodb_log_file | 1628 | 8529534800160 | 51935101152 | |
background | wait/io/file/innodb/innodb_data_file | 3039 | 4540466932848 | 238416612192 | |
background | wait/io/file/innodb/innodb_temp_file | 114 | 374074943088 | 29048863536 | |
background | wait/io/file/sql/binlog_index | 36 | 47095923600 | 27479243088 | |
background | wait/io/file/sql/binlog | 37 | 37138414896 | 16550643648 | |
background | wait/io/file/mysys/cnf | 5 | 2139715776 | 2117292144 | |
background | wait/io/file/sql/ERRMSG | 5 | 1315584864 | 397905024 | |
background | wait/io/file/sql/casetest | 15 | 823374288 | 761524896 | |
background | wait/io/file/mysys/charset | 3 | 290212032 | 277324608 | |
background | wait/io/file/sql/pid | 3 | 52460496 | 40607424 | |
background | wait/io/file/sql/misc | 1 | 10328736 | 10328736 |
|