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 | 38 | 391177306080 | 50268884688 | |
192.168.30.20 | wait/io/file/innodb/innodb_data_file | 376 | 167777603664 | 25236543552 | |
192.168.30.20 | wait/io/file/sql/binlog | 208 | 113346972288 | 17497332336 | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 75 | 99121649616 | 41455897296 | |
192.168.30.20 | wait/io/file/sql/misc | 2 | 3945401328 | 2058355728 | |
192.168.30.20 | wait/io/file/sql/io_cache | 76 | 3429721152 | 1682676864 | |
192.168.30.20 | wait/io/file/csv/metadata | 8 | 1231888944 | 542461920 | |
192.168.30.20 | wait/io/file/csv/data | 8 | 1076579328 | 1019349408 | |
192.168.30.20 | wait/io/file/myisam/kfile | 4 | 623650896 | 605203632 | |
192.168.30.20 | wait/io/file/myisam/dfile | 28 | 253508640 | 222261072 | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 227082768 | 225502464 | |
background | wait/io/file/innodb/innodb_log_file | 825 | 5503326134592 | 645069400272 | |
background | wait/io/file/innodb/innodb_data_file | 2480 | 3589609750848 | 219243206688 | |
background | wait/io/file/innodb/innodb_temp_file | 103 | 358606109664 | 23118789936 | |
background | wait/io/file/sql/binlog_index | 36 | 59509495584 | 37563417408 | |
background | wait/io/file/sql/binlog | 37 | 47061223440 | 23075624352 | |
background | wait/io/file/sql/ERRMSG | 5 | 1256392368 | 582566688 | |
background | wait/io/file/sql/casetest | 15 | 1121506848 | 1060128432 | |
background | wait/io/file/mysys/cnf | 5 | 1076903520 | 1054386960 | |
background | wait/io/file/mysys/charset | 3 | 226582752 | 217047072 | |
background | wait/io/file/sql/pid | 3 | 61074288 | 37010688 | |
background | wait/io/file/sql/misc | 1 | 7484400 | 7484400 |
|