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 | 2479 | 2331930855408 | 0 | 940673976 | 188781886656 | 1398 | 28016640 | 20040.5150 | 734 | 33079296 | 45067.1608 | 61095936 | |
sql/ERRMSG | 45 | 33745981632 | 2761968 | 749910480 | 3564680592 | 27 | 2768491 | 102536.7037 | 0 | 0 | 0.0000 | 2768491 | |
innodb/innodb_temp_file | 99 | 426442669488 | 0 | 4307501616 | 43748242560 | 0 | 0 | 0.0000 | 36 | 1441792 | 40049.7778 | 1441792 | |
innodb/innodb_log_file | 558 | 3370638863328 | 222288 | 6040571328 | 108660565728 | 8 | 70656 | 8832.0000 | 327 | 336384 | 1028.6972 | 407040 | |
mysys/charset | 3 | 291259584 | 2387616 | 97086528 | 274430112 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 371 | 123764464032 | 0 | 333596736 | 27557859120 | 87 | 944 | 10.8506 | 8 | 1387 | 173.3750 | 2331 | |
myisam/kfile | 8 | 3181839408 | 518496 | 397729728 | 2872910832 | 4 | 834 | 208.5000 | 0 | 0 | 0.0000 | 834 | |
sql/binlog_index | 38 | 45062148912 | 0 | 1185846024 | 28846088304 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 1650871200 | 164208 | 330174240 | 1626563664 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
csv/metadata | 4 | 475856832 | 482592 | 118964208 | 398192256 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | 35 | |
sql/pid | 3 | 25556256 | 1381776 | 8518752 | 20205504 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 721550016 | 0 | 48103176 | 658399632 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 3 | 45559536 | 0 | 15186336 | 26408448 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 2 | 172276368 | 0 | 86138184 | 163187904 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 4 | 24330768 | 303600 | 6082560 | 16465680 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|