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 | 2121 | 1687974281664 | 0 | 795838824 | 258246555072 | 1319 | 26722304 | 20259.5178 | 540 | 27049984 | 50092.5630 | 53772288 | |
sql/io_cache | 84 | 3183314640 | 0 | 37896408 | 1052430192 | 26 | 2046588 | 78714.9231 | 38 | 2037840 | 53627.3684 | 4084428 | |
sql/ERRMSG | 55 | 46639871520 | 3753024 | 847997568 | 3930366000 | 33 | 3372236 | 102188.9697 | 0 | 0 | 0.0000 | 3372236 | |
innodb/innodb_temp_file | 126 | 643098577968 | 0 | 5103956880 | 214033899024 | 0 | 0 | 0.0000 | 65 | 1785856 | 27474.7077 | 1785856 | |
innodb/innodb_log_file | 360 | 1849941134448 | 230208 | 5138725152 | 42848650416 | 8 | 70656 | 8832.0000 | 206 | 185344 | 899.7282 | 256000 | |
mysys/charset | 3 | 275608080 | 3404016 | 91869360 | 252613152 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 155 | 52995201072 | 0 | 341904288 | 20919070656 | 35 | 736 | 21.0286 | 4 | 409 | 102.2500 | 1145 | |
sql/binlog_index | 38 | 62476060944 | 0 | 1644106728 | 30830712528 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 948244704 | 149424 | 189648888 | 932293296 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
csv/metadata | 4 | 585411024 | 664752 | 146352624 | 512901840 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | 35 | |
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 | 2 | 17400240 | 0 | 8700120 | 12468720 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 2 | 17784624 | 0 | 8892312 | 10619136 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|