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 | 92 | 4667734380 | 0 | 50736105 | 2262650560 | 44 | 2297068 | 52206.0909 | 38 | 2297068 | 60449.1579 | 4594136 | |
sql/ERRMSG | 55 | 32706615350 | 3211800 | 594665565 | 3042780880 | 33 | 3382134 | 102488.9091 | 0 | 0 | 0.0000 | 3382134 | |
innodb/innodb_temp_file | 181 | 363652703810 | 0 | 2009130890 | 28008378940 | 0 | 0 | 0.0000 | 120 | 2686976 | 22391.4667 | 2686976 | |
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 | 347 | 59273443050 | 0 | 170816615 | 24302252180 | 83 | 928 | 11.1807 | 4 | 435 | 108.7500 | 1363 | |
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 |
|