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 | 2287 | 813011799840 | 0 | 355492465 | 509481214830 | 1175 | 53680833 | 45685.8153 | 882 | 53680833 | 60862.6224 | 107361666 | |
innodb/innodb_data_file | 3526 | 6281689862190 | 0 | 1781534050 | 524581720960 | 1568 | 30801920 | 19644.0816 | 1286 | 49233920 | 38284.5412 | 80035840 | |
innodb/innodb_temp_file | 1416 | 1736217845840 | 0 | 1226142545 | 51015287270 | 0 | 0 | 0.0000 | 1294 | 25919488 | 20030.5162 | 25919488 | |
sql/ERRMSG | 70 | 33979051540 | 2699820 | 485414810 | 3965526780 | 42 | 4304192 | 102480.7619 | 0 | 0 | 0.0000 | 4304192 | |
innodb/innodb_log_file | 1173 | 6726533450440 | 225250 | 5734469885 | 48137213960 | 8 | 70656 | 8832.0000 | 681 | 569344 | 836.0411 | 640000 | |
mysys/charset | 3 | 262836010 | 2227060 | 87611915 | 250396380 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 421 | 244288888430 | 0 | 580258575 | 31792159710 | 96 | 980 | 10.2083 | 15 | 3633 | 242.2000 | 4613 | |
sql/binlog_index | 38 | 84942130630 | 0 | 2235318990 | 48800717780 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 2424083260 | 246980 | 484816440 | 2401921310 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
csv/metadata | 4 | 466977170 | 1046220 | 116744160 | 293987820 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | 35 | |
sql/pid | 3 | 16087090 | 761080 | 5362275 | 12895960 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 1347009840 | 0 | 89800550 | 1171908440 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 5 | 2295003350 | 0 | 459000670 | 2219937330 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 29 | 430011260 | 0 | 14827810 | 302399450 | 12 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|