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 | 1788 | 1008732115776 | 0 | 564167736 | 218019888240 | 1291 | 26263552 | 20343.5724 | 291 | 19349504 | 66493.1409 | 45613056 | |
sql/ERRMSG | 35 | 17087042544 | 2510112 | 488201208 | 2538897504 | 21 | 2152954 | 102521.6190 | 0 | 0 | 0.0000 | 2152954 | |
innodb/innodb_temp_file | 106 | 438267623904 | 0 | 4134600096 | 25413330624 | 0 | 0 | 0.0000 | 42 | 1605632 | 38229.3333 | 1605632 | |
innodb/innodb_log_file | 255 | 1647535707312 | 237600 | 6460924272 | 212821987488 | 8 | 70656 | 8832.0000 | 146 | 134656 | 922.3014 | 205312 | |
mysys/charset | 3 | 228560640 | 2232912 | 76186704 | 214938240 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 89 | 37592249376 | 0 | 422384688 | 17505623520 | 19 | 672 | 35.3684 | 3 | 156 | 52.0000 | 828 | |
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 | 1 | 9635472 | 0 | 9635472 | 9635472 | 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 |
|