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 | 22 | 2473984 | 112453.8182 | 114 | 21807104 | 191290.3860 | 24281088 | 89.81 | |
/var/lib/mysql/undo_001 | 461 | 7651328 | 16597.2408 | 622 | 10190848 | 16384.0000 | 17842176 | 57.12 | |
/var/lib/mysql/ibtmp1 | 0 | 0 | 0.0000 | 143 | 14729216 | 103001.5105 | 14729216 | 100.00 | |
/var/lib/mysql/undo_002 | 396 | 6586368 | 16632.2424 | 441 | 7225344 | 16384.0000 | 13811712 | 52.31 | |
/var/lib/mysql/mysql.ibd | 537 | 8847360 | 16475.5307 | 151 | 2473984 | 16384.0000 | 11321344 | 21.85 | |
/var/lib/mysql/#innodb_temp/temp_9.ibt | 0 | 0 | 0.0000 | 270 | 6193152 | 22937.6000 | 6193152 | 100.00 | |
/var/lib/mysql/ib_logfile1 | 2 | 66048 | 33024.0000 | 636 | 599552 | 942.6918 | 665600 | 90.08 | |
/usr/share/mysql-8.0/russian/errmsg.sys | 3 | 318782 | 106260.6667 | 0 | 0 | 0.0000 | 318782 | 0.00 | |
/var/lib/mysql/sakila/film.ibd | 16 | 311296 | 19456.0000 | 0 | 0 | 0.0000 | 311296 | 0.00 | |
/var/lib/mysql/#innodb_temp/temp_10.ibt | 0 | 0 | 0.0000 | 7 | 311296 | 44470.8571 | 311296 | 100.00 | |
/var/lib/mysql/sakila/inventory.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/japanese/errmsg.sys | 3 | 310953 | 103651.0000 | 0 | 0 | 0.0000 | 310953 | 0.00 | |
/usr/share/mysql-8.0/portuguese/errmsg.sys | 3 | 306467 | 102155.6667 | 0 | 0 | 0.0000 | 306467 | 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/english/errmsg.sys | 3 | 303507 | 101169.0000 | 0 | 0 | 0.0000 | 303507 | 0.00 | |
/var/lib/mysql/sakila/film_actor.ibd | 15 | 294912 | 19660.8000 | 0 | 0 | 0.0000 | 294912 | 0.00 | |
/var/lib/mysql/indexing_lab/products.ibd | 7 | 163840 | 23405.7143 | 6 | 98304 | 16384.0000 | 262144 | 37.50 | |
/var/lib/mysql/hospital/paciente.ibd | 0 | 0 | 0.0000 | 7 | 212992 | 30427.4286 | 212992 | 100.00 | |
/var/lib/mysql/foodstore/students.ibd | 0 | 0 | 0.0000 | 7 | 212992 | 30427.4286 | 212992 | 100.00 | |
/var/lib/mysql/binlog.000010 | 89 | 211198 | 2373.0112 | 1 | 1 | 1.0000 | 211199 | 0.00 | |
/var/lib/mysql/sakila/city.ibd | 7 | 163840 | 23405.7143 | 0 | 0 | 0.0000 | 163840 | 0.00 | |
/var/lib/mysql/sakila/film_category.ibd | 7 | 163840 | 23405.7143 | 0 | 0 | 0.0000 | 163840 | 0.00 | |
/var/lib/mysql/Rental_Mobil/Tb_pelanggan.ibd | 5 | 131072 | 26214.4000 | 1 | 16384 | 16384.0000 | 147456 | 11.11 |
|