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 | 2270 | 3334548981456 | 0 | 1468964112 | 837623198016 | 1369 | 27541504 | 20117.9722 | 579 | 28065792 | 48472.8705 | 55607296 | |
innodb/innodb_temp_file | 219 | 1197142682736 | 0 | 5466404856 | 39850749312 | 0 | 0 | 0.0000 | 121 | 5128192 | 42381.7521 | 5128192 | |
sql/ERRMSG | 50 | 32762266416 | 1789392 | 655245096 | 2572983072 | 30 | 3077145 | 102571.5000 | 0 | 0 | 0.0000 | 3077145 | |
innodb/innodb_log_file | 389 | 3190287125520 | 225456 | 8201252136 | 978536922000 | 8 | 70656 | 8832.0000 | 223 | 217088 | 973.4888 | 287744 | |
mysys/charset | 3 | 262635648 | 1749264 | 87545040 | 251495904 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 429 | 81189718368 | 0 | 189253416 | 21335727600 | 103 | 1008 | 9.7864 | 5 | 855 | 171.0000 | 1863 | |
myisam/kfile | 4 | 1743502992 | 705408 | 435875616 | 1720581984 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | 442 | |
sql/binlog_index | 38 | 47628761664 | 0 | 1253388312 | 24610129632 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 410106576 | 152064 | 82021104 | 390734784 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 24039312 | 1413456 | 8012928 | 19306848 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 1024427712 | 0 | 68294952 | 964450080 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 2 | 41836608 | 0 | 20918304 | 27988224 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 2 | 10393680 | 542784 | 5196840 | 9850896 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|