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 | 2599 | 2614576237360 | 0 | 1005993000 | 252199155390 | 1537 | 30294016 | 19709.8347 | 663 | 30490624 | 45988.8748 | 60784640 | |
sql/io_cache | 462 | 38246306790 | 0 | 82784145 | 24382973300 | 222 | 11514208 | 51865.8018 | 190 | 11514208 | 60601.0947 | 23028416 | |
innodb/innodb_temp_file | 402 | 724018622690 | 0 | 1801041230 | 250169501840 | 0 | 0 | 0.0000 | 337 | 6504448 | 19301.0326 | 6504448 | |
sql/ERRMSG | 55 | 32706615350 | 3211800 | 594665565 | 3042780880 | 33 | 3382134 | 102488.9091 | 0 | 0 | 0.0000 | 3382134 | |
innodb/innodb_log_file | 595 | 3404846672120 | 244860 | 5722431200 | 85594214540 | 8 | 70656 | 8832.0000 | 342 | 272896 | 797.9415 | 343552 | |
mysys/charset | 3 | 284870230 | 3742860 | 94956655 | 262639910 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 375 | 59588603840 | 0 | 158902745 | 24302252180 | 90 | 956 | 10.6222 | 4 | 435 | 108.7500 | 1391 | |
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 |
|