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 | 3517 | 6248513607480 | 0 | 1776659905 | 524581720960 | 1568 | 30801920 | 19644.0816 | 1281 | 49102848 | 38331.6534 | 79904768 | |
innodb/innodb_temp_file | 1413 | 1716707716390 | 0 | 1214938080 | 51015287270 | 0 | 0 | 0.0000 | 1292 | 25821184 | 19985.4365 | 25821184 | |
sql/ERRMSG | 70 | 33979051540 | 2699820 | 485414810 | 3965526780 | 42 | 4304192 | 102480.7619 | 0 | 0 | 0.0000 | 4304192 | |
innodb/innodb_log_file | 1167 | 6683849129820 | 225250 | 5727376895 | 48137213960 | 8 | 70656 | 8832.0000 | 678 | 567808 | 837.4749 | 638464 | |
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 |
|