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 | 3200 | 5180888812830 | 0 | 1619027570 | 524581720960 | 1557 | 30621696 | 19667.1137 | 1087 | 43401216 | 39927.5216 | 74022912 | |
sql/io_cache | 1439 | 780027344180 | 0 | 542062005 | 509481214830 | 727 | 33984609 | 46746.3673 | 562 | 33984609 | 60470.8345 | 67969218 | |
innodb/innodb_temp_file | 1057 | 1227803111320 | 0 | 1161592255 | 51015287270 | 0 | 0 | 0.0000 | 966 | 18513920 | 19165.5487 | 18513920 | |
sql/ERRMSG | 65 | 32809694520 | 2699820 | 504764315 | 3965526780 | 39 | 3993239 | 102390.7436 | 0 | 0 | 0.0000 | 3993239 | |
innodb/innodb_log_file | 922 | 5283865974260 | 225250 | 5730874100 | 48137213960 | 8 | 70656 | 8832.0000 | 533 | 444416 | 833.8011 | 515072 | |
mysys/charset | 3 | 262836010 | 2227060 | 87611915 | 250396380 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 259 | 146903263570 | 0 | 567193810 | 31792159710 | 59 | 832 | 14.1017 | 8 | 1666 | 208.2500 | 2498 | |
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 | 4 | 2249279190 | 0 | 562319665 | 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 |
|