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 | 2617 | 3164333755968 | 0 | 1209145344 | 204107782560 | 1505 | 29769728 | 19780.5502 | 690 | 31178752 | 45186.5971 | 60948480 | |
innodb/innodb_temp_file | 616 | 1187843419488 | 0 | 1928316984 | 33646830096 | 0 | 0 | 0.0000 | 520 | 11534336 | 22181.4154 | 11534336 | |
sql/io_cache | 154 | 16421171184 | 0 | 106630920 | 12979834560 | 54 | 3971412 | 73544.6667 | 70 | 3971412 | 56734.4571 | 7942824 | |
sql/ERRMSG | 55 | 27224894400 | 2483184 | 494997888 | 2411078736 | 33 | 3382422 | 102497.6364 | 0 | 0 | 0.0000 | 3382422 | |
innodb/innodb_log_file | 558 | 3263234546352 | 232320 | 5848090512 | 283309614192 | 8 | 70656 | 8832.0000 | 318 | 276480 | 869.4340 | 347136 | |
mysys/charset | 3 | 278992032 | 1943568 | 92997168 | 267183312 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 467 | 109787492496 | 0 | 235090944 | 24051409536 | 112 | 1044 | 9.3214 | 6 | 1194 | 199.0000 | 2238 | |
myisam/kfile | 4 | 283186992 | 764016 | 70796616 | 249570288 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | 442 | |
sql/binlog_index | 38 | 79966011312 | 0 | 2104368552 | 42666337824 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 628430352 | 175824 | 125685912 | 607543200 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 20008032 | 806256 | 6669168 | 11877888 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 1222589808 | 0 | 81505776 | 1157854368 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 3 | 215864352 | 0 | 71954784 | 199829520 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 2 | 8373552 | 420288 | 4186776 | 7953264 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|