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 | 2608 | 2616953294208 | 0 | 1003432848 | 223742561856 | 1416 | 28311552 | 19994.0339 | 794 | 34619392 | 43601.2494 | 62930944 | |
sql/io_cache | 164 | 3827474112 | 0 | 23338128 | 392218464 | 64 | 4036886 | 63076.3438 | 70 | 4036886 | 57669.8000 | 8073772 | |
innodb/innodb_temp_file | 371 | 968188620960 | 0 | 2609672736 | 88498649184 | 0 | 0 | 0.0000 | 280 | 7274496 | 25980.3429 | 7274496 | |
sql/ERRMSG | 50 | 38758712256 | 3616272 | 775174224 | 4489688544 | 30 | 3064679 | 102155.9667 | 0 | 0 | 0.0000 | 3064679 | |
innodb/innodb_log_file | 617 | 3590082898512 | 242880 | 5818610688 | 273945574320 | 8 | 70656 | 8832.0000 | 357 | 286720 | 803.1373 | 357376 | |
mysys/charset | 3 | 284158512 | 3267792 | 94719504 | 261077520 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 229 | 32825036112 | 0 | 143340648 | 14984282544 | 54 | 812 | 15.0370 | 3 | 156 | 52.0000 | 968 | |
myisam/kfile | 8 | 3016325664 | 868560 | 377040576 | 1809532560 | 4 | 799 | 199.7500 | 0 | 0 | 0.0000 | 799 | |
sql/binlog_index | 38 | 44604451584 | 0 | 1173801288 | 28562390736 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 1029912048 | 591888 | 128738808 | 547511712 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 518780592 | 165264 | 103755960 | 500110512 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 13600752 | 639936 | 4533408 | 10595376 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 826890768 | 0 | 55125840 | 754792368 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 1 | 5740944 | 0 | 5740944 | 5740944 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 4 | 336937392 | 0 | 84234216 | 288650736 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 7 | 47361600 | 401808 | 6765792 | 14252832 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|