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 | 2557 | 2447417398280 | 0 | 957143960 | 252199155390 | 1530 | 30179328 | 19725.0510 | 646 | 30031872 | 46488.9659 | 60211200 | |
sql/io_cache | 368 | 36484523720 | 0 | 99142595 | 24382973300 | 176 | 9200644 | 52276.3864 | 152 | 9200644 | 60530.5526 | 18401288 | |
innodb/innodb_temp_file | 311 | 709559421330 | 0 | 2281541350 | 250169501840 | 0 | 0 | 0.0000 | 247 | 4964352 | 20098.5911 | 4964352 | |
sql/ERRMSG | 55 | 32706615350 | 3211800 | 594665565 | 3042780880 | 33 | 3382134 | 102488.9091 | 0 | 0 | 0.0000 | 3382134 | |
innodb/innodb_log_file | 572 | 3250629412790 | 244860 | 5682918375 | 85594214540 | 8 | 70656 | 8832.0000 | 329 | 266240 | 809.2401 | 336896 | |
mysys/charset | 3 | 284870230 | 3742860 | 94956655 | 262639910 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 355 | 59492941490 | 0 | 167585735 | 24302252180 | 85 | 936 | 11.0118 | 4 | 435 | 108.7500 | 1371 | |
myisam/dfile | 31 | 5257455310 | 190800 | 169595230 | 5225955820 | 25 | 975 | 39.0000 | 0 | 0 | 0.0000 | 975 | |
myisam/kfile | 8 | 1074374130 | 603670 | 134296700 | 691063820 | 4 | 849 | 212.2500 | 0 | 0 | 0.0000 | 849 | |
sql/binlog_index | 38 | 57196475870 | 0 | 1505170320 | 38045260830 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 2274109160 | 1734160 | 284263645 | 1115690280 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 1505398220 | 150520 | 301079485 | 1475720340 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 16600660 | 701190 | 5533465 | 13659160 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 779602440 | 0 | 51973390 | 694077400 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 2 | 518994020 | 0 | 259497010 | 516041390 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 4 | 89042120 | 0 | 22260530 | 31432710 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|