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 | 374 | 982499600544 | 0 | 2627004072 | 88498649184 | 0 | 0 | 0.0000 | 282 | 7372800 | 26144.6809 | 7372800 | |
sql/ERRMSG | 55 | 42835087152 | 3616272 | 778819536 | 4489688544 | 33 | 3375632 | 102291.8788 | 0 | 0 | 0.0000 | 3375632 | |
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 | 237 | 32863130256 | 0 | 138662832 | 14984282544 | 56 | 820 | 14.6429 | 3 | 156 | 52.0000 | 976 | |
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 |
|