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 | 1969 | 792358329480 | 0 | 402416545 | 509481214830 | 1007 | 46274129 | 45952.4618 | 762 | 46274129 | 60727.2034 | 92548258 | |
innodb/innodb_data_file | 3302 | 5600586115950 | 0 | 1696119250 | 524581720960 | 1557 | 30621696 | 19667.1137 | 1148 | 45072384 | 39261.6585 | 75694080 | |
innodb/innodb_temp_file | 1284 | 1483216919700 | 0 | 1155153285 | 51015287270 | 0 | 0 | 0.0000 | 1177 | 23019520 | 19557.7910 | 23019520 | |
sql/ERRMSG | 70 | 33979051540 | 2699820 | 485414810 | 3965526780 | 42 | 4304192 | 102480.7619 | 0 | 0 | 0.0000 | 4304192 | |
innodb/innodb_log_file | 1017 | 5868239714120 | 225250 | 5770147100 | 48137213960 | 8 | 70656 | 8832.0000 | 587 | 482816 | 822.5145 | 553472 | |
mysys/charset | 3 | 262836010 | 2227060 | 87611915 | 250396380 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 347 | 230203643940 | 0 | 663411070 | 31792159710 | 78 | 908 | 11.6410 | 14 | 3252 | 232.2857 | 4160 | |
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 |
|