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 | 2070 | 1816987190304 | 0 | 877771488 | 281476249824 | 1255 | 25673728 | 20457.1538 | 558 | 27672576 | 49592.4301 | 53346304 | |
innodb/innodb_temp_file | 141 | 899610716928 | 0 | 6380217624 | 39085644576 | 0 | 0 | 0.0000 | 65 | 2768896 | 42598.4000 | 2768896 | |
sql/ERRMSG | 40 | 32446117968 | 2755632 | 811152936 | 9278350752 | 24 | 2457332 | 102388.8333 | 0 | 0 | 0.0000 | 2457332 | |
innodb/innodb_log_file | 379 | 2171316991008 | 227568 | 5729068488 | 63198434112 | 8 | 70656 | 8832.0000 | 220 | 200192 | 909.9636 | 270848 | |
mysys/charset | 3 | 341592240 | 2270400 | 113863992 | 319848144 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 151 | 65004399504 | 0 | 430492656 | 26435003760 | 34 | 732 | 21.5294 | 4 | 394 | 98.5000 | 1126 | |
sql/binlog_index | 38 | 82209040320 | 0 | 2163395784 | 53063484144 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 14342219232 | 244464 | 2868443688 | 14322375936 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
csv/metadata | 4 | 661642608 | 663696 | 165410520 | 601390416 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | 35 | |
sql/pid | 3 | 24521904 | 780912 | 8173968 | 17727600 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 967200432 | 0 | 64479888 | 881860320 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 2 | 188742048 | 0 | 94371024 | 183763008 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 2 | 190163424 | 0 | 95081712 | 179878512 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|