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 | 2450 | 8446311587210 | 47776500200 | |
192.168.30.20 | wait/io/file/innodb/innodb_data_file | 1354 | 4068491332730 | 317823628720 | |
192.168.30.20 | wait/io/file/innodb/innodb_temp_file | 76 | 731540552290 | 32766726890 | |
192.168.30.20 | wait/io/file/sql/io_cache | 852 | 78619630250 | 25985497730 | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 85 | 64181853610 | 5554524550 | |
192.168.30.20 | wait/io/file/csv/metadata | 8 | 4901006460 | 4019805140 | |
192.168.30.20 | wait/io/file/myisam/kfile | 29 | 2721129180 | 1086472970 | |
192.168.30.20 | wait/io/file/csv/data | 4 | 564572960 | 498319780 | |
192.168.30.20 | wait/io/file/sql/misc | 15 | 551682300 | 358524860 | |
192.168.30.20 | wait/io/file/myisam/dfile | 23 | 222538520 | 36835530 | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 214283770 | 212816730 | |
192.168.30.20 | wait/io/file/sql/SDI | 3 | 64555060 | 46617740 | |
background | wait/io/file/innodb/innodb_log_file | 12224 | 54927521744400 | 623214074890 | |
background | wait/io/file/innodb/innodb_data_file | 10206 | 23390919381090 | 530253306610 | |
background | wait/io/file/innodb/innodb_temp_file | 292 | 372693245590 | 29592485870 | |
background | wait/io/file/sql/binlog_index | 36 | 44211650240 | 21880607980 | |
background | wait/io/file/sql/binlog | 37 | 35656026660 | 17469079840 | |
background | wait/io/file/sql/ERRMSG | 5 | 1485951990 | 609404070 | |
background | wait/io/file/sql/casetest | 15 | 1326120950 | 1233029630 | |
background | wait/io/file/mysys/cnf | 5 | 449749520 | 428984650 | |
background | wait/io/file/mysys/charset | 3 | 312535170 | 290202560 | |
background | wait/io/file/sql/pid | 3 | 47634810 | 36642610 | |
background | wait/io/file/sql/misc | 1 | 6207890 | 6207890 |
|