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 | 742 | 1914965304912 | 52632546384 | |
192.168.30.20 | wait/io/file/sql/binlog | 840 | 1285875568560 | 30357545328 | |
192.168.30.20 | wait/io/file/innodb/innodb_temp_file | 52 | 444202732512 | 26749129968 | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 60 | 41445418608 | 3273490176 | |
192.168.30.20 | wait/io/file/myisam/kfile | 16 | 6446175120 | 2394573456 | |
192.168.30.20 | wait/io/file/csv/metadata | 8 | 1503552864 | 579162144 | |
192.168.30.20 | wait/io/file/csv/data | 16 | 495246048 | 309311376 | |
192.168.30.20 | wait/io/file/sql/misc | 12 | 387312816 | 150705984 | |
192.168.30.20 | wait/io/file/myisam/dfile | 8 | 78802416 | 28873680 | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 3684912 | 2591952 | |
background | wait/io/file/innodb/innodb_log_file | 3011 | 16495691813040 | 97290811728 | |
background | wait/io/file/innodb/innodb_data_file | 4590 | 9034998016176 | 231838889040 | |
background | wait/io/file/innodb/innodb_temp_file | 111 | 362346521856 | 22349413152 | |
background | wait/io/file/sql/binlog_index | 36 | 43344708528 | 26736764208 | |
background | wait/io/file/sql/binlog | 37 | 32445000720 | 15652989792 | |
background | wait/io/file/sql/ERRMSG | 5 | 1392955344 | 539589600 | |
background | wait/io/file/sql/casetest | 15 | 1088326800 | 1023528528 | |
background | wait/io/file/mysys/cnf | 5 | 625965648 | 592297728 | |
background | wait/io/file/mysys/charset | 3 | 299109360 | 283838544 | |
background | wait/io/file/sql/pid | 3 | 44773344 | 35503248 | |
background | wait/io/file/sql/misc | 1 | 9788064 | 9788064 |
|