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 | 10 | 103519013136 | 28712490576 | |
192.168.30.20 | wait/io/file/sql/binlog | 146 | 65771770416 | 20735355696 | |
192.168.30.20 | wait/io/file/innodb/innodb_data_file | 239 | 59721200880 | 6449757072 | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 40 | 15989403408 | 1952149584 | |
192.168.30.20 | wait/io/file/csv/metadata | 8 | 865630128 | 429928752 | |
192.168.30.20 | wait/io/file/sql/misc | 3 | 279312528 | 242633424 | |
192.168.30.20 | wait/io/file/csv/data | 4 | 244469280 | 204447936 | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 5969568 | 4282080 | |
background | wait/io/file/innodb/innodb_log_file | 653 | 3875462250528 | 274770808224 | |
background | wait/io/file/innodb/innodb_data_file | 2066 | 1791993857280 | 215713337664 | |
background | wait/io/file/innodb/innodb_temp_file | 88 | 320067363792 | 24310839696 | |
background | wait/io/file/sql/binlog_index | 36 | 55015944192 | 35059058496 | |
background | wait/io/file/sql/binlog | 37 | 28531579824 | 15480154800 | |
background | wait/io/file/sql/ERRMSG | 5 | 1287308880 | 594924528 | |
background | wait/io/file/sql/casetest | 15 | 1098153936 | 980356080 | |
background | wait/io/file/mysys/cnf | 5 | 576322032 | 549733008 | |
background | wait/io/file/mysys/charset | 3 | 243054768 | 216931440 | |
background | wait/io/file/sql/pid | 3 | 21464784 | 16901280 | |
background | wait/io/file/sql/misc | 1 | 6629040 | 6629040 |
|