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 | 2659 | 3043892768590 | 0 | 1144750710 | 295936092580 | 1535 | 30261248 | 19714.1681 | 733 | 32620544 | 44502.7885 | 62881792 | |
sql/io_cache | 411 | 100113252370 | 0 | 243584555 | 85376596010 | 199 | 9718993 | 48839.1608 | 162 | 9718993 | 59993.7840 | 19437986 | |
innodb/innodb_temp_file | 304 | 918959824330 | 0 | 3022893955 | 51015287270 | 0 | 0 | 0.0000 | 231 | 5292032 | 22909.2294 | 5292032 | |
sql/ERRMSG | 50 | 26458343590 | 2699820 | 529166840 | 3965526780 | 30 | 3063505 | 102116.8333 | 0 | 0 | 0.0000 | 3063505 | |
innodb/innodb_log_file | 587 | 3414906301080 | 225250 | 5817557455 | 48137213960 | 8 | 70656 | 8832.0000 | 336 | 267776 | 796.9524 | 338432 | |
mysys/charset | 3 | 262836010 | 2227060 | 87611915 | 250396380 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 137 | 107694033700 | 0 | 786087785 | 31792159710 | 30 | 716 | 23.8667 | 5 | 652 | 130.4000 | 1368 | |
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 | 3 | 2237305960 | 0 | 745768565 | 2219937330 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 13 | 362776520 | 0 | 27905825 | 302399450 | 5 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|