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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sql/io_cache | 1497 | 180880884096 | 0 | 120828840 | 33372872016 | 670 | 34518846 | 51520.6657 | 597 | 34444488 | 57695.9598 | 68963334 | |
innodb/innodb_data_file | 2771 | 3476829207984 | 0 | 1254719928 | 258246555072 | 1450 | 28868608 | 19909.3848 | 872 | 36847616 | 42256.4404 | 65716224 | |
innodb/innodb_temp_file | 832 | 2346571507632 | 0 | 2820398328 | 394185231264 | 0 | 0 | 0.0000 | 715 | 16105472 | 22525.1357 | 16105472 | |
sql/ERRMSG | 75 | 66228081744 | 3753024 | 883040928 | 3930366000 | 45 | 4608504 | 102411.2000 | 0 | 0 | 0.0000 | 4608504 | |
innodb/innodb_log_file | 694 | 4262232401328 | 230208 | 6141544992 | 106825795296 | 8 | 70656 | 8832.0000 | 397 | 346624 | 873.1083 | 417280 | |
mysys/charset | 3 | 275608080 | 3404016 | 91869360 | 252613152 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 778 | 354836576160 | 0 | 456087984 | 220899293472 | 189 | 1499 | 7.9312 | 9 | 1765 | 196.1111 | 3264 | |
sql/binlog_index | 38 | 62476060944 | 0 | 1644106728 | 30830712528 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 1877252784 | 664752 | 234656400 | 786369936 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 948244704 | 149424 | 189648888 | 932293296 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 54952656 | 2823744 | 18317376 | 33554400 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 799340256 | 0 | 53289192 | 713658000 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 5 | 53131056 | 0 | 10626000 | 13691040 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 4 | 763434672 | 0 | 190858536 | 662017488 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|