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 | 14 | 123517810416 | 25134715584 | |
192.168.30.20 | wait/io/file/innodb/innodb_data_file | 110 | 40415743104 | 5657939232 | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 20 | 18416805264 | 3036815760 | |
192.168.30.20 | wait/io/file/sql/binlog | 24 | 146636688 | 34143648 | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 3784176 | 2127840 | |
background | wait/io/file/innodb/innodb_data_file | 1480 | 1368736073760 | 307651377792 | |
background | wait/io/file/innodb/innodb_log_file | 103 | 839217720528 | 141211348080 | |
background | wait/io/file/innodb/innodb_temp_file | 179 | 562035648768 | 34525661280 | |
background | wait/io/file/sql/binlog_index | 36 | 80761461792 | 46578819408 | |
background | wait/io/file/sql/binlog | 37 | 53910188112 | 25667074752 | |
background | wait/io/file/mysys/cnf | 5 | 4420372176 | 4392036528 | |
background | wait/io/file/sql/ERRMSG | 5 | 3389875104 | 1883658480 | |
background | wait/io/file/sql/casetest | 15 | 1293913104 | 1209644304 | |
background | wait/io/file/mysys/charset | 3 | 382322160 | 356250048 | |
background | wait/io/file/sql/pid | 3 | 50267712 | 39477504 | |
background | wait/io/file/sql/misc | 1 | 12953424 | 12953424 |
|