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 | 1454 | 1931540757168 | 33625497312 | |
192.168.30.20 | wait/io/file/innodb/innodb_temp_file | 172 | 1485051051264 | 34506066144 | |
192.168.30.20 | wait/io/file/innodb/innodb_data_file | 688 | 965926196928 | 35831249520 | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 50 | 38797784256 | 9018566832 | |
192.168.30.20 | wait/io/file/sql/io_cache | 48 | 8163907488 | 7347689184 | |
192.168.30.20 | wait/io/file/csv/metadata | 8 | 4179483264 | 1603221312 | |
192.168.30.20 | wait/io/file/csv/data | 9 | 1158915648 | 805551648 | |
192.168.30.20 | wait/io/file/myisam/kfile | 4 | 618404160 | 594906048 | |
192.168.30.20 | wait/io/file/sql/misc | 5 | 572665104 | 293603904 | |
192.168.30.20 | wait/io/file/myisam/dfile | 2 | 9832944 | 9354576 | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 5592048 | 3021216 | |
background | wait/io/file/innodb/innodb_log_file | 3704 | 19454767097568 | 232667263488 | |
background | wait/io/file/innodb/innodb_data_file | 5792 | 11126060827728 | 198498515952 | |
background | wait/io/file/innodb/innodb_temp_file | 371 | 1259463704400 | 430788258912 | |
background | wait/io/file/sql/binlog_index | 36 | 51560047968 | 34978297728 | |
background | wait/io/file/sql/binlog | 37 | 28157115888 | 15152027088 | |
background | wait/io/file/mysys/cnf | 5 | 1336449312 | 1318897536 | |
background | wait/io/file/sql/ERRMSG | 5 | 1232995632 | 369688176 | |
background | wait/io/file/sql/casetest | 15 | 910048128 | 839172576 | |
background | wait/io/file/mysys/charset | 3 | 304270560 | 262034784 | |
background | wait/io/file/sql/pid | 3 | 12713712 | 10369392 | |
background | wait/io/file/sql/misc | 1 | 4122624 | 4122624 |
|