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 | 58 | 598291092960 | 50977920576 | |
192.168.30.20 | wait/io/file/innodb/innodb_data_file | 480 | 467834530944 | 30740427168 | |
192.168.30.20 | wait/io/file/sql/binlog | 292 | 198856223808 | 20827371840 | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 60 | 42152940720 | 2864760624 | |
192.168.30.20 | wait/io/file/myisam/kfile | 21 | 2295150528 | 1281086400 | |
192.168.30.20 | wait/io/file/sql/misc | 3 | 272887296 | 235190736 | |
192.168.30.20 | wait/io/file/sql/SDI | 3 | 195865824 | 177977184 | |
192.168.30.20 | wait/io/file/myisam/dfile | 10 | 125609088 | 54300576 | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 5649072 | 3231360 | |
background | wait/io/file/innodb/innodb_log_file | 917 | 5364419461632 | 245169108096 | |
background | wait/io/file/innodb/innodb_data_file | 2475 | 3488663457840 | 209873030400 | |
background | wait/io/file/innodb/innodb_temp_file | 109 | 358145300832 | 24086502000 | |
background | wait/io/file/sql/binlog_index | 36 | 49418211744 | 23993015376 | |
background | wait/io/file/sql/binlog | 37 | 33113952432 | 15888046944 | |
background | wait/io/file/sql/ERRMSG | 5 | 1256002176 | 376837824 | |
background | wait/io/file/sql/casetest | 15 | 777264576 | 706328304 | |
background | wait/io/file/mysys/cnf | 5 | 612185904 | 597354384 | |
background | wait/io/file/mysys/charset | 3 | 344773968 | 324261168 | |
background | wait/io/file/sql/pid | 3 | 51514848 | 40038768 | |
background | wait/io/file/sql/misc | 1 | 12394800 | 12394800 |
|