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 | 2745 | 3329529709840 | 0 | 1212943425 | 295936092580 | 1544 | 30408704 | 19694.7565 | 779 | 33964032 | 43599.5276 | 64372736 | |
sql/io_cache | 921 | 137567905580 | 0 | 149367780 | 85376596010 | 459 | 21802313 | 47499.5926 | 362 | 21802313 | 60227.3840 | 43604626 | |
innodb/innodb_temp_file | 582 | 1010929815380 | 0 | 1736992585 | 51015287270 | 0 | 0 | 0.0000 | 503 | 10141696 | 20162.4175 | 10141696 | |
sql/ERRMSG | 50 | 26458343590 | 2699820 | 529166840 | 3965526780 | 30 | 3063505 | 102116.8333 | 0 | 0 | 0.0000 | 3063505 | |
innodb/innodb_log_file | 659 | 3855791233470 | 225250 | 5850972895 | 48137213960 | 8 | 70656 | 8832.0000 | 377 | 296448 | 786.3342 | 367104 | |
mysys/charset | 3 | 262836010 | 2227060 | 87611915 | 250396380 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 173 | 107883635370 | 0 | 623604625 | 31792159710 | 39 | 752 | 19.2821 | 5 | 652 | 130.4000 | 1404 | |
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 | 18 | 388356970 | 0 | 21575240 | 302399450 | 7 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|