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 | 1772 | 1136658275280 | 0 | 641454792 | 236989496832 | 1244 | 25493504 | 20493.1704 | 310 | 19808256 | 63897.6000 | 45301760 | |
sql/ERRMSG | 40 | 24588674880 | 3735072 | 614716872 | 2431143264 | 24 | 2458654 | 102443.9167 | 0 | 0 | 0.0000 | 2458654 | |
innodb/innodb_temp_file | 96 | 410197120080 | 0 | 4272886464 | 28895705520 | 0 | 0 | 0.0000 | 34 | 1343488 | 39514.3529 | 1343488 | |
innodb/innodb_log_file | 256 | 1245107897616 | 224928 | 4863702624 | 69460488768 | 8 | 70656 | 8832.0000 | 145 | 134656 | 928.6621 | 205312 | |
mysys/charset | 3 | 340026192 | 3411936 | 113342064 | 320246784 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 135 | 64997728752 | 0 | 481464456 | 22624848048 | 30 | 716 | 23.8667 | 4 | 417 | 104.2500 | 1133 | |
sql/binlog_index | 38 | 52519085520 | 0 | 1382081184 | 32431751616 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 1484811504 | 259776 | 296962248 | 1459366656 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
csv/metadata | 4 | 1318728576 | 1613040 | 329682144 | 1035302928 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | 35 | |
sql/pid | 3 | 47488848 | 2952048 | 15829440 | 37332240 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 1296065760 | 0 | 86404296 | 1223740848 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 2 | 558532128 | 0 | 279266064 | 545467824 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 2 | 43269600 | 0 | 21634800 | 30068016 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|