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 | 2467 | 1871878873392 | 0 | 758767152 | 238437168816 | 1494 | 29589504 | 19805.5582 | 668 | 31309824 | 46870.9940 | 60899328 | |
sql/ERRMSG | 45 | 30180534912 | 2087712 | 670678536 | 2824118352 | 27 | 2770781 | 102621.5185 | 0 | 0 | 0.0000 | 2770781 | |
innodb/innodb_temp_file | 109 | 480594601872 | 0 | 4409124720 | 25032909792 | 0 | 0 | 0.0000 | 42 | 1802240 | 42910.4762 | 1802240 | |
innodb/innodb_log_file | 574 | 3031910169552 | 225984 | 5282073456 | 66252141648 | 8 | 70656 | 8832.0000 | 340 | 345600 | 1016.4706 | 416256 | |
mysys/charset | 3 | 285612624 | 2117808 | 95204208 | 270948480 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 149 | 201049487760 | 0 | 1349325384 | 37416358848 | 29 | 712 | 24.5517 | 13 | 5431 | 417.7692 | 6143 | |
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 |
|