SELECT * FROM `x$io_global_by_wait_by_bytes`
|
event_name | total | total_latency | min_latency | avg_latency | max_latency | count_read | total_read | avg_read | count_write | total_written | avg_written | total_requested | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
innodb/innodb_data_file | 3258 | 3216475875360 | 0 | 987254664 | 242471506992 | 1384 | 27787264 | 20077.5029 | 1296 | 50970624 | 39329.1852 | 78757888 | |
sql/ERRMSG | 50 | 28983245280 | 3174336 | 579664800 | 4451891136 | 30 | 3075875 | 102529.1667 | 0 | 0 | 0.0000 | 3075875 | |
innodb/innodb_log_file | 1871 | 8432501742720 | 232848 | 4506948864 | 197508048144 | 8 | 70656 | 8832.0000 | 1283 | 2272768 | 1771.4482 | 2343424 | |
innodb/innodb_temp_file | 96 | 419126381520 | 0 | 4365899736 | 30208774464 | 0 | 0 | 0.0000 | 34 | 1343488 | 39514.3529 | 1343488 | |
mysys/charset | 3 | 270749952 | 3197568 | 90249984 | 251069280 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 300 | 494603757648 | 0 | 1648678944 | 35791880784 | 59 | 1273 | 21.5763 | 33 | 6283 | 190.3939 | 7556 | |
myisam/kfile | 9 | 2356579632 | 0 | 261842064 | 1490811168 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | 442 | |
sql/binlog_index | 38 | 60652208496 | 0 | 1596110736 | 40560766752 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 1653512784 | 960960 | 206689032 | 580464192 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 467779488 | 192720 | 93555792 | 452013936 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 47904912 | 2732400 | 15968304 | 37781568 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 731474304 | 0 | 48764760 | 663495360 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 1 | 12466608 | 0 | 12466608 | 12466608 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 10 | 104652768 | 0 | 10465224 | 39130608 | 3 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 9 | 380714928 | 0 | 42301512 | 266388144 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|