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 | 2296 | 2365006452864 | 0 | 1030054872 | 223221679296 | 1388 | 27852800 | 20066.8588 | 576 | 27967488 | 48554.6667 | 55820288 | |
sql/io_cache | 144 | 146477726736 | 0 | 1017206256 | 140106021792 | 51 | 3528082 | 69178.0784 | 63 | 3528082 | 56001.3016 | 7056164 | |
innodb/innodb_temp_file | 254 | 1171908908016 | 0 | 4613814480 | 339520727568 | 0 | 0 | 0.0000 | 178 | 4620288 | 25956.6742 | 4620288 | |
sql/ERRMSG | 65 | 323993037456 | 3363888 | 4984508232 | 176066553168 | 39 | 3983290 | 102135.6410 | 0 | 0 | 0.0000 | 3983290 | |
innodb/innodb_log_file | 432 | 3507492297408 | 230736 | 8119195128 | 383062636176 | 8 | 70656 | 8832.0000 | 245 | 204288 | 833.8286 | 274944 | |
mysys/charset | 3 | 279998400 | 3159024 | 93332712 | 260718480 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 469 | 36966954816 | 0 | 78820632 | 16357430496 | 114 | 1052 | 9.2281 | 3 | 156 | 52.0000 | 1208 | |
myisam/kfile | 8 | 967441200 | 802032 | 120929952 | 740952960 | 4 | 834 | 208.5000 | 0 | 0 | 0.0000 | 834 | |
myisam/dfile | 16 | 733658640 | 798864 | 45853632 | 605196768 | 5 | 335 | 67.0000 | 0 | 0 | 0.0000 | 335 | |
sql/binlog_index | 38 | 46118799936 | 0 | 1213652616 | 24105143040 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 500778960 | 165264 | 100155792 | 483924144 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 12647712 | 552816 | 4215816 | 10187760 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 746447328 | 0 | 49762944 | 664790016 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 1 | 2897136 | 0 | 2897136 | 2897136 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|