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 | 2105 | 1197844314480 | 0 | 569046984 | 175740836304 | 1492 | 29949952 | 20073.6944 | 277 | 18333696 | 66186.6282 | 48283648 | |
sql/io_cache | 538 | 94263514224 | 0 | 175210992 | 29629451280 | 254 | 12941112 | 50949.2598 | 214 | 12941112 | 60472.4860 | 25882224 | |
innodb/innodb_temp_file | 684 | 716129825664 | 0 | 1046973312 | 30137064672 | 0 | 0 | 0.0000 | 602 | 11960320 | 19867.6412 | 11960320 | |
sql/ERRMSG | 70 | 44052488832 | 3446256 | 629321088 | 3963641088 | 42 | 4292458 | 102201.3810 | 0 | 0 | 0.0000 | 4292458 | |
innodb/innodb_log_file | 244 | 1299894123792 | 226512 | 5327434728 | 38959229232 | 8 | 70656 | 8832.0000 | 128 | 117248 | 916.0000 | 187904 | |
mysys/charset | 3 | 250019616 | 16318368 | 83339784 | 204451104 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 321 | 54520015968 | 0 | 169844136 | 20968599168 | 78 | 12902 | 165.4103 | 4 | 474 | 118.5000 | 13376 | |
sql/binlog_index | 23 | 2393642592 | 0 | 104071176 | 1695927024 | 5 | 160 | 32.0000 | 0 | 0 | 0.0000 | 160 | |
mysys/cnf | 5 | 251046576 | 229680 | 50209104 | 232838496 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 17302032 | 827904 | 5767344 | 14227488 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 766622736 | 0 | 51108024 | 696089856 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 2 | 23291664 | 0 | 11645832 | 13735392 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|