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 | 979 | 1578031939968 | 45530987568 | |
192.168.30.20 | wait/io/file/sql/binlog | 348 | 1015349365008 | 28611997392 | |
192.168.30.20 | wait/io/file/innodb/innodb_temp_file | 30 | 307694817936 | 38544778272 | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 55 | 30286382016 | 4210302096 | |
192.168.30.20 | wait/io/file/sql/io_cache | 108 | 4645715712 | 1234757040 | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 1185037392 | 1182945456 | |
192.168.30.20 | wait/io/file/sql/misc | 8 | 782796432 | 411104496 | |
192.168.30.20 | wait/io/file/myisam/kfile | 4 | 364762992 | 234313728 | |
192.168.30.20 | wait/io/file/myisam/dfile | 4 | 300921984 | 278555376 | |
background | wait/io/file/innodb/innodb_log_file | 3607 | 16679546029872 | 101935124544 | |
background | wait/io/file/innodb/innodb_data_file | 4065 | 5880212334480 | 247828061712 | |
background | wait/io/file/innodb/innodb_temp_file | 167 | 508700761536 | 45069659712 | |
background | wait/io/file/sql/binlog_index | 36 | 55396661760 | 35810654352 | |
background | wait/io/file/sql/binlog | 37 | 33153790560 | 17249311728 | |
background | wait/io/file/sql/ERRMSG | 5 | 1182747984 | 482896656 | |
background | wait/io/file/mysys/cnf | 5 | 922050096 | 905268672 | |
background | wait/io/file/sql/casetest | 15 | 717402576 | 659876976 | |
background | wait/io/file/mysys/charset | 3 | 268474800 | 255227280 | |
background | wait/io/file/sql/pid | 3 | 14660448 | 11764368 | |
background | wait/io/file/sql/misc | 1 | 13143504 | 13143504 |
|