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 | 1750 | 1057733854848 | 0 | 604419288 | 229702018128 | 1268 | 25886720 | 20415.3943 | 267 | 18399232 | 68910.9813 | 44285952 | |
sql/ERRMSG | 30 | 15823182672 | 2191728 | 527439264 | 3123706080 | 18 | 1834248 | 101902.6667 | 0 | 0 | 0.0000 | 1834248 | |
innodb/innodb_temp_file | 103 | 420965606160 | 0 | 4087044720 | 50684885328 | 0 | 0 | 0.0000 | 38 | 1605632 | 42253.4737 | 1605632 | |
innodb/innodb_log_file | 206 | 1325371770624 | 239712 | 6433843416 | 113426092560 | 8 | 70656 | 8832.0000 | 114 | 110592 | 970.1053 | 181248 | |
mysys/charset | 3 | 313866432 | 2500608 | 104622144 | 299010096 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 83 | 86328655248 | 0 | 1040104032 | 18784296432 | 16 | 660 | 41.2500 | 6 | 817 | 136.1667 | 1477 | |
sql/binlog_index | 38 | 48500469600 | 0 | 1276328064 | 31678756032 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 950297568 | 144672 | 190059408 | 930933696 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 13255440 | 596112 | 4418304 | 10589040 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 1070517360 | 0 | 71367648 | 1004475120 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 4 | 45350448 | 0 | 11337480 | 20076144 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|