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_temp_file | 44 | 417688007616 | 41805583248 | |
192.168.30.20 | wait/io/file/innodb/innodb_data_file | 427 | 147637655088 | 21895104528 | |
192.168.30.20 | wait/io/file/sql/binlog | 384 | 76585924800 | 25946048832 | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 70 | 37793099520 | 2549929536 | |
192.168.30.20 | wait/io/file/sql/misc | 3 | 222446928 | 200215488 | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 4634256 | 2973168 | |
background | wait/io/file/innodb/innodb_log_file | 1299 | 8899443261456 | 1069671907920 | |
background | wait/io/file/innodb/innodb_data_file | 3200 | 4293646649952 | 269997578400 | |
background | wait/io/file/innodb/innodb_temp_file | 103 | 633211592640 | 41059677648 | |
background | wait/io/file/sql/binlog_index | 36 | 88290662592 | 51349673232 | |
background | wait/io/file/sql/binlog | 37 | 54998058720 | 28192410048 | |
background | wait/io/file/sql/ERRMSG | 5 | 5222065728 | 2823334800 | |
background | wait/io/file/mysys/cnf | 5 | 3208876704 | 3191760000 | |
background | wait/io/file/sql/casetest | 15 | 1632782448 | 1410090000 | |
background | wait/io/file/mysys/charset | 3 | 1567694304 | 1552072896 | |
background | wait/io/file/sql/pid | 3 | 54961104 | 42102720 | |
background | wait/io/file/sql/misc | 1 | 13097568 | 13097568 |
|