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 | 133 | 43194870048 | 3100395936 | |
192.168.30.20 | wait/io/file/innodb/innodb_temp_file | 2 | 16705130112 | 16643964480 | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 25 | 13088339616 | 1896182112 | |
192.168.30.20 | wait/io/file/sql/binlog | 66 | 11593822416 | 11248948656 | |
192.168.30.20 | wait/io/file/sql/io_cache | 30 | 540561120 | 52316880 | |
192.168.30.20 | wait/io/file/sql/misc | 1 | 14323584 | 14323584 | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 5470080 | 3414576 | |
background | wait/io/file/innodb/innodb_log_file | 433 | 2126458815888 | 76102733520 | |
background | wait/io/file/innodb/innodb_data_file | 1823 | 822397089888 | 222708028752 | |
background | wait/io/file/innodb/innodb_temp_file | 81 | 308475785376 | 29779137168 | |
background | wait/io/file/sql/binlog_index | 36 | 53595575616 | 31704022416 | |
background | wait/io/file/sql/binlog | 37 | 42993901104 | 26497828896 | |
background | wait/io/file/sql/ERRMSG | 5 | 1333602336 | 525080160 | |
background | wait/io/file/mysys/cnf | 5 | 1044017568 | 1024878096 | |
background | wait/io/file/sql/casetest | 15 | 847455312 | 761021184 | |
background | wait/io/file/mysys/charset | 3 | 256689840 | 238868256 | |
background | wait/io/file/sql/pid | 3 | 13083840 | 10640784 | |
background | wait/io/file/sql/misc | 1 | 4794240 | 4794240 |
|