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 | 1272 | 4864777117200 | 54585786288 | |
192.168.30.20 | wait/io/file/sql/binlog | 1265 | 1646217085920 | 36585240912 | |
192.168.30.20 | wait/io/file/innodb/innodb_temp_file | 94 | 871471102656 | 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/csv/data | 9 | 1169201088 | 965717808 | |
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 | |
background | wait/io/file/innodb/innodb_log_file | 8787 | 42274938388320 | 145649519664 | |
background | wait/io/file/innodb/innodb_data_file | 8928 | 12915807396096 | 332113968912 | |
background | wait/io/file/innodb/innodb_temp_file | 231 | 302997696672 | 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 |
|