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 | 3263 | 937095429520 | 0 | 287188185 | 509481214830 | 1697 | 76115393 | 44852.9128 | 1246 | 76115393 | 61087.7953 | 152230786 | |
innodb/innodb_data_file | 3952 | 7623827158320 | 0 | 1929105925 | 524581720960 | 1570 | 30834688 | 19639.9287 | 1587 | 58703872 | 36990.4675 | 89538560 | |
innodb/innodb_temp_file | 2006 | 2130787169500 | 0 | 1062206920 | 51015287270 | 0 | 0 | 0.0000 | 1862 | 36667392 | 19692.4769 | 36667392 | |
sql/ERRMSG | 70 | 33979051540 | 2699820 | 485414810 | 3965526780 | 42 | 4304192 | 102480.7619 | 0 | 0 | 0.0000 | 4304192 | |
innodb/innodb_log_file | 1685 | 9243115019800 | 225250 | 5485528090 | 48137213960 | 8 | 70656 | 8832.0000 | 1018 | 900608 | 884.6837 | 971264 | |
mysys/charset | 3 | 262836010 | 2227060 | 87611915 | 250396380 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 533 | 414927163200 | 0 | 778474865 | 31792159710 | 119 | 1072 | 9.0084 | 25 | 7576 | 303.0400 | 8648 | |
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 | 6 | 2306119040 | 0 | 384353085 | 2219937330 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 34 | 776456360 | 0 | 22836905 | 336246310 | 14 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|