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 | 2763 | 2104913758464 | 0 | 761821632 | 212105484624 | 1551 | 30523392 | 19679.8143 | 905 | 38649856 | 42707.0232 | 69173248 | |
sql/io_cache | 216 | 13382544384 | 0 | 61956048 | 10471738992 | 112 | 5006536 | 44701.2143 | 84 | 5006536 | 59601.6190 | 10013072 | |
innodb/innodb_temp_file | 541 | 1280212087440 | 0 | 2366380896 | 523078155600 | 0 | 0 | 0.0000 | 460 | 9568256 | 20800.5565 | 9568256 | |
sql/ERRMSG | 60 | 37640992224 | 2965776 | 627349800 | 5760901872 | 36 | 3686474 | 102402.0556 | 0 | 0 | 0.0000 | 3686474 | |
innodb/innodb_log_file | 697 | 4837916827920 | 233904 | 6941057112 | 606311815824 | 8 | 70656 | 8832.0000 | 409 | 331776 | 811.1883 | 402432 | |
mysys/charset | 3 | 194306640 | 1450944 | 64768704 | 180987312 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 206 | 74262348864 | 0 | 360496752 | 15815939568 | 48 | 935 | 19.4792 | 5 | 667 | 133.4000 | 1602 | |
myisam/kfile | 8 | 1182726864 | 679008 | 147840792 | 646831680 | 4 | 834 | 208.5000 | 0 | 0 | 0.0000 | 834 | |
sql/binlog_index | 38 | 51093437472 | 0 | 1344564144 | 33556398480 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 1329204096 | 163680 | 265840608 | 1311682416 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
csv/metadata | 4 | 501489648 | 720192 | 125372280 | 435771072 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | 35 | |
sql/pid | 3 | 14643024 | 619872 | 4880832 | 12215280 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 853153488 | 0 | 56876688 | 783241536 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 3 | 40312272 | 0 | 13437336 | 26147616 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 2 | 19057104 | 0 | 9528552 | 13035792 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 4 | 17387568 | 368544 | 4346760 | 9474960 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|