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 | 1634 | 4641722840832 | 44032606992 | |
192.168.30.20 | wait/io/file/sql/binlog | 1019 | 2099648106336 | 40000099920 | |
192.168.30.20 | wait/io/file/innodb/innodb_temp_file | 68 | 613147593168 | 31120601952 | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 55 | 27198642768 | 2282153280 | |
192.168.30.20 | wait/io/file/csv/metadata | 8 | 15293194752 | 11137947744 | |
192.168.30.20 | wait/io/file/sql/misc | 17 | 1669233456 | 1429414272 | |
192.168.30.20 | wait/io/file/sql/io_cache | 90 | 1505664864 | 52316880 | |
192.168.30.20 | wait/io/file/myisam/kfile | 4 | 258429600 | 180760272 | |
192.168.30.20 | wait/io/file/myisam/dfile | 4 | 158462304 | 134402928 | |
192.168.30.20 | wait/io/file/csv/data | 4 | 58489728 | 39568848 | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 5470080 | 3414576 | |
background | wait/io/file/innodb/innodb_log_file | 8110 | 36361152182256 | 229806344064 | |
background | wait/io/file/innodb/innodb_data_file | 5457 | 7801105214496 | 239722177200 | |
background | wait/io/file/innodb/innodb_temp_file | 115 | 309396970080 | 29779137168 | |
background | wait/io/file/sql/binlog_index | 36 | 53595575616 | 31704022416 | |
background | wait/io/file/sql/binlog | 37 | 42993901104 | 26497828896 | |
background | wait/io/file/sql/ERRMSG | 5 | 1333602336 | 525080160 | |
background | wait/io/file/mysys/cnf | 5 | 1044017568 | 1024878096 | |
background | wait/io/file/sql/casetest | 15 | 847455312 | 761021184 | |
background | wait/io/file/mysys/charset | 3 | 256689840 | 238868256 | |
background | wait/io/file/sql/pid | 3 | 13083840 | 10640784 | |
background | wait/io/file/sql/misc | 1 | 4794240 | 4794240 |
|