SELECT * FROM `x$host_summary_by_file_io_type`
|
host | event_name | total | total_latency | max_latency | |
---|---|---|---|---|---|
192.168.30.20 | wait/io/file/sql/binlog | 432 | 836775406896 | 27766424400 | |
192.168.30.20 | wait/io/file/innodb/innodb_data_file | 846 | 773926864128 | 43248693312 | |
192.168.30.20 | wait/io/file/innodb/innodb_temp_file | 42 | 356167338384 | 26034060624 | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 50 | 24453500016 | 2282153280 | |
192.168.30.20 | wait/io/file/csv/metadata | 4 | 15070001760 | 11137947744 | |
192.168.30.20 | wait/io/file/sql/misc | 11 | 1591125888 | 1429414272 | |
192.168.30.20 | wait/io/file/sql/io_cache | 30 | 540561120 | 52316880 | |
192.168.30.20 | wait/io/file/myisam/kfile | 4 | 258429600 | 180760272 | |
192.168.30.20 | wait/io/file/myisam/dfile | 4 | 158462304 | 134402928 | |
192.168.30.20 | wait/io/file/csv/data | 2 | 44731104 | 39568848 | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 5470080 | 3414576 | |
background | wait/io/file/innodb/innodb_log_file | 3751 | 16262225444256 | 108843807072 | |
background | wait/io/file/innodb/innodb_data_file | 4299 | 4488524193648 | 222708028752 | |
background | wait/io/file/innodb/innodb_temp_file | 105 | 309057410112 | 29779137168 | |
background | wait/io/file/sql/binlog_index | 36 | 53595575616 | 31704022416 | |
background | wait/io/file/sql/binlog | 37 | 42993901104 | 26497828896 | |
background | wait/io/file/sql/ERRMSG | 5 | 1333602336 | 525080160 | |
background | wait/io/file/mysys/cnf | 5 | 1044017568 | 1024878096 | |
background | wait/io/file/sql/casetest | 15 | 847455312 | 761021184 | |
background | wait/io/file/mysys/charset | 3 | 256689840 | 238868256 | |
background | wait/io/file/sql/pid | 3 | 13083840 | 10640784 | |
background | wait/io/file/sql/misc | 1 | 4794240 | 4794240 |
|