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 | 2949 | 4624758141696 | 0 | 1568246064 | 298234394304 | 1387 | 27836416 | 20069.5141 | 1023 | 41271296 | 40343.3978 | 69107712 | |
innodb/innodb_temp_file | 140 | 729232564896 | 0 | 5208803952 | 82642472880 | 0 | 0 | 0.0000 | 62 | 2850816 | 45980.9032 | 2850816 | |
sql/ERRMSG | 40 | 27586430256 | 2397120 | 689660664 | 6081809712 | 24 | 2463961 | 102665.0417 | 0 | 0 | 0.0000 | 2463961 | |
sql/io_cache | 30 | 1063695072 | 0 | 35456256 | 616296384 | 8 | 557824 | 69728.0000 | 12 | 549076 | 45756.3333 | 1106900 | |
innodb/innodb_log_file | 1018 | 6043571095584 | 224400 | 5936710296 | 99833878848 | 8 | 70656 | 8832.0000 | 587 | 443392 | 755.3526 | 514048 | |
mysys/charset | 3 | 238410480 | 1387056 | 79470072 | 227110752 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
myisam/kfile | 12 | 18071312688 | 566016 | 1505942592 | 14553833184 | 6 | 1296 | 216.0000 | 0 | 0 | 0.0000 | 1296 | |
sql/binlog | 157 | 54855467040 | 0 | 349397664 | 30959904096 | 36 | 740 | 20.5556 | 3 | 156 | 52.0000 | 896 | |
sql/binlog_index | 38 | 54650271456 | 0 | 1438164816 | 32506641024 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
myisam/dfile | 17 | 596610960 | 749232 | 35094576 | 429983136 | 1 | 261 | 261.0000 | 0 | 0 | 0.0000 | 261 | |
csv/metadata | 8 | 1824382032 | 802032 | 228047688 | 666153840 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 2807748240 | 287760 | 561549648 | 2774676432 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 52881840 | 2871792 | 17627280 | 42031968 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 1066686720 | 0 | 71112360 | 1002731664 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 1 | 16668960 | 0 | 16668960 | 16668960 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 48 | 1783324752 | 0 | 37152456 | 1421957328 | 19 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|