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 | 445 | 784305712608 | 33632816448 | |
192.168.30.20 | wait/io/file/sql/binlog | 400 | 370029215424 | 24892198320 | |
192.168.30.20 | wait/io/file/innodb/innodb_temp_file | 20 | 216832576224 | 39035314560 | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 50 | 21875604432 | 3160976544 | |
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/sql/misc | 4 | 186289488 | 158440656 | |
192.168.30.20 | wait/io/file/csv/data | 4 | 177989856 | 143681472 | |
background | wait/io/file/innodb/innodb_log_file | 1595 | 7962207111936 | 125073982704 | |
background | wait/io/file/innodb/innodb_data_file | 2744 | 3789893091072 | 245195382960 | |
background | wait/io/file/innodb/innodb_temp_file | 98 | 296300628096 | 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 |
|