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 | 2564 | 2246408065440 | 0 | 876134160 | 238437168816 | 1501 | 29704192 | 19789.6016 | 734 | 33308672 | 45379.6621 | 63012864 | |
sql/io_cache | 165 | 83436086976 | 0 | 505672992 | 74938409040 | 72 | 4115702 | 57162.5278 | 68 | 4115702 | 60525.0294 | 8231404 | |
sql/ERRMSG | 60 | 38984396352 | 2087712 | 649739904 | 2824118352 | 36 | 3685521 | 102375.5833 | 0 | 0 | 0.0000 | 3685521 | |
innodb/innodb_temp_file | 165 | 731747446320 | 0 | 4434832776 | 91521852048 | 0 | 0 | 0.0000 | 91 | 3063808 | 33668.2198 | 3063808 | |
innodb/innodb_log_file | 647 | 3468699108336 | 225984 | 5361204024 | 66252141648 | 8 | 70656 | 8832.0000 | 385 | 382976 | 994.7429 | 453632 | |
mysys/charset | 3 | 285612624 | 2117808 | 95204208 | 270948480 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 187 | 220347991248 | 0 | 1178331264 | 37416358848 | 38 | 748 | 19.6842 | 14 | 5647 | 403.3571 | 6395 | |
myisam/kfile | 8 | 935002992 | 628848 | 116875176 | 674303520 | 4 | 834 | 208.5000 | 0 | 0 | 0.0000 | 834 | |
sql/binlog_index | 38 | 53199003792 | 0 | 1399973784 | 28980230400 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 2197926192 | 1002144 | 274740576 | 1292414112 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 474758592 | 275616 | 94951560 | 456456528 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 68445168 | 5137968 | 22814880 | 50582928 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 721327728 | 0 | 48088392 | 650074656 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 2 | 25307040 | 0 | 12653520 | 13080672 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 4 | 665567760 | 0 | 166391808 | 602982336 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 4 | 19891344 | 330528 | 4972704 | 9797568 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|