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 | 48 | 573064523856 | 49191033936 | |
192.168.30.20 | wait/io/file/sql/io_cache | 750 | 343894369104 | 105749784096 | |
192.168.30.20 | wait/io/file/innodb/innodb_data_file | 496 | 249200634144 | 22255220064 | |
192.168.30.20 | wait/io/file/sql/binlog | 434 | 61864474320 | 15036842304 | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 50 | 37113394032 | 3911589264 | |
192.168.30.20 | wait/io/file/myisam/kfile | 8 | 1798121424 | 1427748960 | |
192.168.30.20 | wait/io/file/myisam/dfile | 6 | 856023168 | 822652512 | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 9456480 | 7385664 | |
background | wait/io/file/innodb/innodb_log_file | 842 | 5493728533392 | 514274779392 | |
background | wait/io/file/innodb/innodb_data_file | 2497 | 3328519026624 | 230532567936 | |
background | wait/io/file/innodb/innodb_temp_file | 277 | 372902742432 | 22791131616 | |
background | wait/io/file/sql/binlog_index | 36 | 43064045904 | 25015762464 | |
background | wait/io/file/sql/binlog | 37 | 32014705008 | 15701941200 | |
background | wait/io/file/sql/ERRMSG | 5 | 1230800208 | 517698720 | |
background | wait/io/file/sql/casetest | 15 | 798468528 | 736870992 | |
background | wait/io/file/mysys/cnf | 5 | 559637760 | 538400016 | |
background | wait/io/file/mysys/charset | 3 | 276328800 | 264410256 | |
background | wait/io/file/sql/pid | 3 | 23237808 | 18142080 | |
background | wait/io/file/sql/misc | 1 | 14223792 | 14223792 |
|