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 | 2615 | 2825507428128 | 0 | 1080499728 | 236989496832 | 1403 | 28098560 | 20027.4840 | 840 | 36454400 | 43398.0952 | 64552960 | |
sql/ERRMSG | 55 | 31961600352 | 3360192 | 581119968 | 2431143264 | 33 | 3372727 | 102203.8485 | 0 | 0 | 0.0000 | 3372727 | |
innodb/innodb_temp_file | 102 | 442914557712 | 0 | 4342299456 | 28895705520 | 0 | 0 | 0.0000 | 38 | 1540096 | 40528.8421 | 1540096 | |
sql/io_cache | 32 | 79722721056 | 0 | 2491335000 | 76795241424 | 8 | 748714 | 93589.2500 | 14 | 748714 | 53479.5714 | 1497428 | |
innodb/innodb_log_file | 779 | 3982580600064 | 224928 | 5112426792 | 69460488768 | 8 | 70656 | 8832.0000 | 464 | 439296 | 946.7586 | 509952 | |
mysys/charset | 3 | 340026192 | 3411936 | 113342064 | 320246784 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 415 | 431096218608 | 0 | 1038785880 | 31118033232 | 87 | 944 | 10.8506 | 30 | 8491 | 283.0333 | 9435 | |
myisam/kfile | 4 | 482726640 | 976800 | 120681528 | 461875920 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | 442 | |
sql/binlog_index | 38 | 52519085520 | 0 | 1382081184 | 32431751616 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 1484811504 | 259776 | 296962248 | 1459366656 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
csv/metadata | 4 | 1318728576 | 1613040 | 329682144 | 1035302928 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | 35 | |
sql/pid | 3 | 47488848 | 2952048 | 15829440 | 37332240 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 1296065760 | 0 | 86404296 | 1223740848 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 4 | 590885328 | 0 | 147721200 | 545467824 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 2 | 43269600 | 0 | 21634800 | 30068016 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 2 | 8428992 | 628848 | 4214496 | 7800144 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|