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 | 2378 | 2561505753312 | 0 | 1077168048 | 264024407328 | 1381 | 27738112 | 20085.5264 | 670 | 31178752 | 46535.4507 | 58916864 | |
sql/ERRMSG | 45 | 22205782896 | 2510112 | 493461672 | 2538897504 | 27 | 2769332 | 102567.8519 | 0 | 0 | 0.0000 | 2769332 | |
innodb/innodb_temp_file | 126 | 585113659152 | 0 | 4643758944 | 26370581952 | 0 | 0 | 0.0000 | 55 | 2277376 | 41406.8364 | 2277376 | |
innodb/innodb_log_file | 568 | 3473688750576 | 237600 | 6115648968 | 212821987488 | 8 | 70656 | 8832.0000 | 335 | 310784 | 927.7134 | 381440 | |
mysys/charset | 3 | 228560640 | 2232912 | 76186704 | 214938240 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 231 | 265950561888 | 0 | 1151301096 | 17505623520 | 45 | 776 | 17.2444 | 22 | 5957 | 270.7727 | 6733 | |
sql/binlog_index | 38 | 60573022752 | 0 | 1594026720 | 40847173488 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 13819332384 | 1877040 | 1727416416 | 12210742896 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 1260207696 | 273504 | 252041328 | 1235320944 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 58526160 | 3426720 | 19508544 | 37677552 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 1055232816 | 0 | 70348608 | 979285824 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 4 | 62546880 | 0 | 15636720 | 28902720 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 4 | 759316272 | 0 | 189828936 | 654167184 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|