SELECT * FROM `x$io_global_by_file_by_bytes`
|
file | count_read | total_read | avg_read | count_write | total_written | avg_write | total | write_pct | |
---|---|---|---|---|---|---|---|---|---|
/var/lib/mysql/ibdata1 | 19 | 2424832 | 127622.7368 | 54 | 15941632 | 295215.4074 | 18366464 | 86.80 | |
/var/lib/mysql/undo_002 | 495 | 8208384 | 16582.5939 | 419 | 6864896 | 16384.0000 | 15073280 | 45.54 | |
/var/lib/mysql/ibtmp1 | 0 | 0 | 0.0000 | 143 | 14729216 | 103001.5105 | 14729216 | 100.00 | |
/var/lib/mysql/undo_001 | 406 | 6750208 | 16626.1281 | 339 | 5554176 | 16384.0000 | 12304384 | 45.14 | |
/var/lib/mysql/mysql.ibd | 410 | 6766592 | 16503.8829 | 136 | 2228224 | 16384.0000 | 8994816 | 24.77 | |
/var/lib/mysql/#innodb_temp/temp_10.ibt | 0 | 0 | 0.0000 | 115 | 2801664 | 24362.2957 | 2801664 | 100.00 | |
/var/lib/mysql/ib_logfile1 | 2 | 66048 | 33024.0000 | 797 | 1349120 | 1692.7478 | 1415168 | 95.33 | |
/var/lib/mysql/sakila/film.ibd | 16 | 311296 | 19456.0000 | 0 | 0 | 0.0000 | 311296 | 0.00 | |
/usr/share/mysql-8.0/german/errmsg.sys | 3 | 311159 | 103719.6667 | 0 | 0 | 0.0000 | 311159 | 0.00 | |
/usr/share/mysql-8.0/dutch/errmsg.sys | 3 | 305286 | 101762.0000 | 0 | 0 | 0.0000 | 305286 | 0.00 | |
/usr/share/mysql-8.0/italian/errmsg.sys | 3 | 305277 | 101759.0000 | 0 | 0 | 0.0000 | 305277 | 0.00 | |
/usr/share/mysql-8.0/romanian/errmsg.sys | 3 | 305219 | 101739.6667 | 0 | 0 | 0.0000 | 305219 | 0.00 | |
/usr/share/mysql-8.0/spanish/errmsg.sys | 3 | 305161 | 101720.3333 | 0 | 0 | 0.0000 | 305161 | 0.00 | |
/usr/share/mysql-8.0/french/errmsg.sys | 3 | 304914 | 101638.0000 | 0 | 0 | 0.0000 | 304914 | 0.00 | |
/usr/share/mysql-8.0/polish/errmsg.sys | 3 | 304436 | 101478.6667 | 0 | 0 | 0.0000 | 304436 | 0.00 | |
/usr/share/mysql-8.0/english/errmsg.sys | 3 | 303507 | 101169.0000 | 0 | 0 | 0.0000 | 303507 | 0.00 | |
/var/lib/mysql/INFS1200_RELEASE/Policy.ibd | 0 | 0 | 0.0000 | 9 | 245760 | 27306.6667 | 245760 | 100.00 | |
/var/lib/mysql/INFS1200_RELEASE/VehicleCodeMapping... | 0 | 0 | 0.0000 | 8 | 229376 | 28672.0000 | 229376 | 100.00 | |
/var/lib/mysql/INFS1200_RELEASE/Customer.ibd | 0 | 0 | 0.0000 | 8 | 229376 | 28672.0000 | 229376 | 100.00 | |
/var/lib/mysql/INFS1200_RELEASE/Address.ibd | 0 | 0 | 0.0000 | 8 | 229376 | 28672.0000 | 229376 | 100.00 | |
/var/lib/mysql/INFS1200_RELEASE/Vehicle.ibd | 0 | 0 | 0.0000 | 8 | 229376 | 28672.0000 | 229376 | 100.00 | |
/var/lib/mysql/INFS1200_RELEASE/VehicleExcessRange... | 0 | 0 | 0.0000 | 7 | 212992 | 30427.4286 | 212992 | 100.00 | |
/var/lib/mysql/INFS1200_RELEASE/VehicleValue.ibd | 0 | 0 | 0.0000 | 7 | 212992 | 30427.4286 | 212992 | 100.00 | |
/var/lib/mysql/sakila/film_category.ibd | 6 | 147456 | 24576.0000 | 0 | 0 | 0.0000 | 147456 | 0.00 | |
/var/lib/mysql/sakila/address.ibd | 5 | 131072 | 26214.4000 | 0 | 0 | 0.0000 | 131072 | 0.00 |
|