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 | 60 | 568183502832 | 29078382432 | |
192.168.30.20 | wait/io/file/innodb/innodb_data_file | 390 | 102793530048 | 14129867136 | |
192.168.30.20 | wait/io/file/sql/binlog | 334 | 100653137904 | 30980635488 | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 40 | 23948551440 | 2822892864 | |
192.168.30.20 | wait/io/file/sql/io_cache | 374 | 13042533504 | 3040726128 | |
192.168.30.20 | wait/io/file/myisam/kfile | 16 | 9773495424 | 6897871728 | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 179584944 | 177977184 | |
192.168.30.20 | wait/io/file/myisam/dfile | 8 | 77865744 | 30187872 | |
192.168.30.20 | wait/io/file/sql/misc | 1 | 10656096 | 10656096 | |
background | wait/io/file/innodb/innodb_log_file | 417 | 2322202927440 | 75712846176 | |
background | wait/io/file/innodb/innodb_data_file | 1968 | 2194019453472 | 269024469648 | |
background | wait/io/file/innodb/innodb_temp_file | 194 | 308282014656 | 24641749440 | |
background | wait/io/file/sql/binlog_index | 36 | 44532204288 | 26920753200 | |
background | wait/io/file/sql/binlog | 37 | 39599425536 | 26009121072 | |
background | wait/io/file/sql/ERRMSG | 5 | 1272526464 | 422303904 | |
background | wait/io/file/sql/casetest | 15 | 777302064 | 703951248 | |
background | wait/io/file/mysys/cnf | 5 | 615337008 | 592396992 | |
background | wait/io/file/mysys/charset | 3 | 252366576 | 239019264 | |
background | wait/io/file/sql/pid | 3 | 23300112 | 13526304 | |
background | wait/io/file/sql/misc | 1 | 2742960 | 2742960 |
|