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 | 1254 | 4778583097200 | 54585786288 | |
192.168.30.20 | wait/io/file/sql/binlog | 1059 | 1606388759712 | 36585240912 | |
192.168.30.20 | wait/io/file/innodb/innodb_temp_file | 70 | 664707701856 | 39035314560 | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 65 | 30912586848 | 5403006048 | |
192.168.30.20 | wait/io/file/sql/io_cache | 82 | 2210635152 | 505066848 | |
192.168.30.20 | wait/io/file/sql/misc | 11 | 789777648 | 260730624 | |
192.168.30.20 | wait/io/file/csv/metadata | 8 | 511410768 | 213491520 | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 186641136 | 185323248 | |
192.168.30.20 | wait/io/file/csv/data | 4 | 177989856 | 143681472 | |
background | wait/io/file/innodb/innodb_log_file | 7557 | 36123014555760 | 125073982704 | |
background | wait/io/file/innodb/innodb_data_file | 7132 | 11239608943200 | 332113968912 | |
background | wait/io/file/innodb/innodb_temp_file | 211 | 302544159984 | 20648900448 | |
background | wait/io/file/sql/binlog_index | 36 | 43136448960 | 26377545216 | |
background | wait/io/file/sql/binlog | 37 | 33570653424 | 19391306352 | |
background | wait/io/file/sql/ERRMSG | 5 | 1228097904 | 574175712 | |
background | wait/io/file/sql/casetest | 15 | 929067744 | 804072192 | |
background | wait/io/file/mysys/cnf | 5 | 704283888 | 685674000 | |
background | wait/io/file/mysys/charset | 3 | 225954432 | 210361536 | |
background | wait/io/file/sql/pid | 3 | 13593888 | 11100144 | |
background | wait/io/file/sql/misc | 1 | 7151232 | 7151232 |
|