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 | 3574 | 5493173891568 | 0 | 1536981864 | 485074896768 | 1299 | 26394624 | 20319.1871 | 1735 | 64176128 | 36989.1228 | 90570752 | |
innodb/innodb_temp_file | 175 | 965420453184 | 0 | 5516688144 | 48406189392 | 0 | 0 | 0.0000 | 86 | 3964928 | 46103.8140 | 3964928 | |
sql/ERRMSG | 60 | 55730160816 | 3214992 | 928835952 | 15823617744 | 36 | 3687632 | 102434.2222 | 0 | 0 | 0.0000 | 3687632 | |
innodb/innodb_log_file | 1370 | 7670135263824 | 238656 | 5598638760 | 54937272192 | 8 | 70656 | 8832.0000 | 810 | 664064 | 819.8321 | 734720 | |
mysys/charset | 3 | 965594784 | 2320032 | 321864840 | 950439072 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 927 | 206334664272 | 0 | 222583152 | 20471648208 | 223 | 1488 | 6.6726 | 14 | 3036 | 216.8571 | 4524 | |
sql/binlog_index | 38 | 39911571216 | 0 | 1050304464 | 20165128368 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 648998064 | 168960 | 129799560 | 619166064 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
csv/metadata | 4 | 674905968 | 649968 | 168726360 | 569394144 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | 35 | |
sql/pid | 3 | 19687008 | 955680 | 6562248 | 15895968 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 740309328 | 0 | 49353744 | 654047328 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 6 | 299640528 | 0 | 49940088 | 177606000 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 8 | 44188320 | 0 | 5523408 | 13078560 | 3 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|