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 | 2944 | 4159809421680 | 0 | 1412978688 | 245734052256 | 1427 | 28491776 | 19966.2060 | 980 | 40419328 | 41244.2122 | 68911104 | |
sql/ERRMSG | 90 | 41786386752 | 2667456 | 464293104 | 2228172672 | 54 | 5523665 | 102290.0926 | 0 | 0 | 0.0000 | 5523665 | |
innodb/innodb_temp_file | 200 | 1048925321136 | 0 | 5244626376 | 51072935232 | 0 | 0 | 0.0000 | 104 | 4718592 | 45371.0769 | 4718592 | |
innodb/innodb_log_file | 895 | 5743489018080 | 238128 | 6417305928 | 882802842768 | 8 | 70656 | 8832.0000 | 533 | 625664 | 1173.8537 | 696320 | |
mysys/charset | 3 | 274181952 | 2162688 | 91393896 | 255841344 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 965 | 351647873280 | 0 | 364401840 | 28350300528 | 228 | 1508 | 6.6140 | 23 | 9409 | 409.0870 | 10917 | |
myisam/kfile | 4 | 284691264 | 859584 | 71172816 | 252417792 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | 442 | |
sql/binlog_index | 38 | 53681801712 | 0 | 1412678784 | 32443576704 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 593739168 | 129360 | 118747728 | 575282928 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 51635760 | 2633136 | 17211744 | 40952208 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 757598688 | 0 | 50506368 | 695138928 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 7 | 94093824 | 0 | 13441824 | 22205040 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 2 | 8642304 | 642048 | 4321152 | 8000256 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|