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 | 627 | 1289569207872 | 165580142640 | |
192.168.30.20 | wait/io/file/sql/binlog | 174 | 531883459008 | 35378364384 | |
192.168.30.20 | wait/io/file/innodb/innodb_temp_file | 36 | 331466143536 | 26235850608 | |
192.168.30.20 | wait/io/file/sql/io_cache | 193 | 141169940208 | 52669449888 | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 50 | 31215834144 | 5326272864 | |
192.168.30.20 | wait/io/file/myisam/dfile | 9 | 3585647472 | 3541577424 | |
192.168.30.20 | wait/io/file/csv/metadata | 4 | 2305119168 | 1785216048 | |
192.168.30.20 | wait/io/file/myisam/kfile | 8 | 1314681456 | 731079888 | |
192.168.30.20 | wait/io/file/sql/misc | 4 | 366390816 | 204941088 | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 177771264 | 175215216 | |
192.168.30.20 | wait/io/file/csv/data | 6 | 48172080 | 23233056 | |
background | wait/io/file/innodb/innodb_log_file | 3508 | 17958870438432 | 294223736400 | |
background | wait/io/file/innodb/innodb_data_file | 5380 | 6918623295936 | 251848197216 | |
background | wait/io/file/innodb/innodb_temp_file | 251 | 466639826928 | 29585920320 | |
background | wait/io/file/sql/binlog_index | 36 | 54616427184 | 36329059536 | |
background | wait/io/file/sql/binlog | 37 | 30547601568 | 15741487344 | |
background | wait/io/file/sql/casetest | 15 | 1262424240 | 1195881984 | |
background | wait/io/file/sql/ERRMSG | 5 | 1251667824 | 519982848 | |
background | wait/io/file/mysys/cnf | 5 | 509667312 | 473435424 | |
background | wait/io/file/mysys/charset | 3 | 321451680 | 310701072 | |
background | wait/io/file/sql/pid | 3 | 31360032 | 24302784 | |
background | wait/io/file/sql/misc | 1 | 13806672 | 13806672 |
|