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 | 1805 | 2046790626144 | 0 | 1133955768 | 524990971824 | 1294 | 26312704 | 20334.3926 | 329 | 20627456 | 62697.4347 | 46940160 | |
sql/io_cache | 100 | 9186255408 | 0 | 91862496 | 3797253504 | 36 | 2505330 | 69592.5000 | 44 | 2505330 | 56939.3182 | 5010660 | |
sql/ERRMSG | 40 | 106234644912 | 2319504 | 2655865872 | 67664871120 | 24 | 2453018 | 102209.0833 | 0 | 0 | 0.0000 | 2453018 | |
innodb/innodb_temp_file | 111 | 542835230784 | 0 | 4890407280 | 70915918128 | 0 | 0 | 0.0000 | 42 | 1933312 | 46031.2381 | 1933312 | |
innodb/innodb_log_file | 334 | 2831186983152 | 238656 | 8476607568 | 398995159728 | 8 | 70656 | 8832.0000 | 193 | 168448 | 872.7876 | 239104 | |
mysys/charset | 3 | 197447712 | 1380720 | 65815728 | 185371824 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 61 | 29061133200 | 0 | 476411760 | 15087689232 | 12 | 644 | 53.6667 | 3 | 156 | 52.0000 | 800 | |
sql/binlog_index | 38 | 71333736144 | 0 | 1877203416 | 36688196160 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 2131779936 | 274032 | 426355776 | 2108416464 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
csv/metadata | 4 | 10543248672 | 563376 | 2635812168 | 6359604240 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | 35 | |
sql/pid | 3 | 27559488 | 1201200 | 9186408 | 15838416 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 1264089552 | 0 | 84272496 | 1191444672 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 1 | 5214000 | 0 | 5214000 | 5214000 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 2 | 1307380800 | 0 | 653690400 | 1263702528 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|