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 | 3012 | 4234973680080 | 0 | 1406033640 | 240508788432 | 1425 | 28459008 | 19971.2337 | 1101 | 44384256 | 40312.6757 | 72843264 | |
sql/io_cache | 322 | 223971553872 | 0 | 695563704 | 197255944512 | 158 | 7530846 | 47663.5823 | 124 | 7530846 | 60732.6290 | 15061692 | |
innodb/innodb_temp_file | 483 | 1121088211584 | 0 | 2321093544 | 192861578976 | 0 | 0 | 0.0000 | 400 | 8716288 | 21790.7200 | 8716288 | |
sql/ERRMSG | 55 | 47030339664 | 2725008 | 855097056 | 16349165184 | 33 | 3379988 | 102423.8788 | 0 | 0 | 0.0000 | 3379988 | |
innodb/innodb_log_file | 997 | 5802175837392 | 228624 | 5819634480 | 45643329072 | 8 | 70656 | 8832.0000 | 594 | 605696 | 1019.6902 | 676352 | |
mysys/charset | 3 | 279603984 | 1966800 | 93201240 | 266722368 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 265 | 221816727264 | 0 | 837044208 | 33693563904 | 58 | 828 | 14.2759 | 13 | 4565 | 351.1538 | 5393 | |
myisam/kfile | 4 | 1823976528 | 542256 | 455994000 | 1800383904 | 2 | 392 | 196.0000 | 0 | 0 | 0.0000 | 392 | |
sql/binlog_index | 38 | 46078281744 | 0 | 1212586320 | 27516535728 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 1076203920 | 679536 | 134525424 | 543671040 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 779006976 | 237600 | 155801184 | 756171504 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 47389056 | 2580864 | 15796176 | 36837504 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 936889008 | 0 | 62459232 | 858818400 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 6 | 75523536 | 0 | 12587256 | 15989952 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 10 | 310865808 | 0 | 31086528 | 240061008 | 3 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 4 | 20254080 | 248160 | 5063520 | 10132848 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|