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 | 2256 | 2247129501936 | 0 | 996068040 | 223221679296 | 1376 | 27656192 | 20098.9767 | 558 | 27443200 | 49181.3620 | 55099392 | |
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 | 405 | 3317381216160 | 230736 | 8191064640 | 383062636176 | 8 | 70656 | 8832.0000 | 230 | 196608 | 854.8174 | 267264 | |
mysys/charset | 3 | 279998400 | 3159024 | 93332712 | 260718480 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 433 | 36787130688 | 0 | 84958632 | 16357430496 | 105 | 1016 | 9.6762 | 3 | 156 | 52.0000 | 1172 | |
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 |
|