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 | 2097 | 1976059484784 | 0 | 942326880 | 263654187984 | 1260 | 25755648 | 20440.9905 | 560 | 27639808 | 49356.8000 | 53395456 | |
sql/ERRMSG | 50 | 31212731616 | 2876544 | 624254400 | 3225092640 | 30 | 3074922 | 102497.4000 | 0 | 0 | 0.0000 | 3074922 | |
innodb/innodb_temp_file | 90 | 414376987728 | 0 | 4604188512 | 38326994640 | 0 | 0 | 0.0000 | 30 | 1146880 | 38229.3333 | 1146880 | |
innodb/innodb_log_file | 382 | 2206666633776 | 233376 | 5776614096 | 101666392608 | 8 | 70656 | 8832.0000 | 220 | 220672 | 1003.0545 | 291328 | |
mysys/charset | 3 | 273569472 | 2276208 | 91189824 | 259209456 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 211 | 102295948656 | 0 | 484814880 | 24200875776 | 48 | 788 | 16.4167 | 6 | 1097 | 182.8333 | 1885 | |
myisam/kfile | 4 | 560402304 | 1872816 | 140100576 | 500391936 | 2 | 392 | 196.0000 | 0 | 0 | 0.0000 | 392 | |
sql/binlog_index | 38 | 59993520048 | 0 | 1578776760 | 33981628560 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 1813054848 | 582384 | 362610864 | 1793264880 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 49991568 | 2950464 | 16663680 | 39023424 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 1081329744 | 0 | 72088632 | 1016893680 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 3 | 1546738512 | 0 | 515579328 | 1530312432 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 2 | 29064288 | 1075536 | 14532144 | 27988752 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|