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 | 26 | 282090635904 | 36979765680 | |
192.168.30.20 | wait/io/file/innodb/innodb_data_file | 623 | 192157841568 | 6147723120 | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 50 | 45311545488 | 18315566016 | |
192.168.30.20 | wait/io/file/sql/binlog | 298 | 24182928528 | 19282281744 | |
192.168.30.20 | wait/io/file/myisam/kfile | 16 | 3946943616 | 1742507184 | |
192.168.30.20 | wait/io/file/csv/metadata | 8 | 2923851744 | 1466467728 | |
192.168.30.20 | wait/io/file/myisam/dfile | 20 | 2169557280 | 2027272368 | |
192.168.30.20 | wait/io/file/sql/io_cache | 30 | 1546096464 | 772154064 | |
192.168.30.20 | wait/io/file/csv/data | 52 | 493391184 | 194898528 | |
192.168.30.20 | wait/io/file/sql/misc | 1 | 28926480 | 28926480 | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 4836480 | 2767248 | |
background | wait/io/file/innodb/innodb_log_file | 1373 | 7813215186480 | 67980675840 | |
background | wait/io/file/innodb/innodb_data_file | 3190 | 5146732945728 | 237043170672 | |
background | wait/io/file/innodb/innodb_temp_file | 98 | 350509248672 | 27387626112 | |
background | wait/io/file/sql/binlog_index | 36 | 51520007088 | 27633110208 | |
background | wait/io/file/sql/binlog | 37 | 33372850368 | 16176290064 | |
background | wait/io/file/sql/ERRMSG | 5 | 1361975472 | 533651712 | |
background | wait/io/file/mysys/cnf | 5 | 1142662224 | 1124454144 | |
background | wait/io/file/sql/casetest | 15 | 887408544 | 824759760 | |
background | wait/io/file/mysys/charset | 3 | 228461376 | 214310976 | |
background | wait/io/file/sql/pid | 3 | 48352128 | 37606272 | |
background | wait/io/file/sql/misc | 1 | 11767008 | 11767008 |
|