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 | 20 | 2441216 | 122060.8000 | 81 | 13844480 | 170919.5062 | 16285696 | 85.01 | |
/var/lib/mysql/ibtmp1 | 0 | 0 | 0.0000 | 143 | 14729216 | 103001.5105 | 14729216 | 100.00 | |
/var/lib/mysql/undo_002 | 384 | 6340608 | 16512.0000 | 361 | 5914624 | 16384.0000 | 12255232 | 48.26 | |
/var/lib/mysql/undo_001 | 388 | 6406144 | 16510.6804 | 316 | 5177344 | 16384.0000 | 11583488 | 44.70 | |
/var/lib/mysql/mysql.ibd | 410 | 6766592 | 16503.8829 | 91 | 1490944 | 16384.0000 | 8257536 | 18.06 | |
/var/lib/mysql/sakila/payment.ibd | 67 | 1146880 | 17117.6119 | 0 | 0 | 0.0000 | 1146880 | 0.00 | |
/var/lib/mysql/#innodb_temp/temp_10.ibt | 0 | 0 | 0.0000 | 18 | 884736 | 49152.0000 | 884736 | 100.00 | |
/var/lib/mysql/ib_logfile1 | 2 | 66048 | 33024.0000 | 479 | 409600 | 855.1148 | 475648 | 86.11 | |
/var/lib/mysql/sakila/rental.ibd | 22 | 409600 | 18618.1818 | 0 | 0 | 0.0000 | 409600 | 0.00 | |
/var/lib/mysql/sakila/film_actor.ibd | 17 | 327680 | 19275.2941 | 0 | 0 | 0.0000 | 327680 | 0.00 | |
/var/lib/mysql/sakila/film.ibd | 16 | 311296 | 19456.0000 | 0 | 0 | 0.0000 | 311296 | 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/slovak/errmsg.sys | 3 | 304033 | 101344.3333 | 0 | 0 | 0.0000 | 304033 | 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/inventory.ibd | 12 | 245760 | 20480.0000 | 0 | 0 | 0.0000 | 245760 | 0.00 | |
/var/lib/mysql/eletronica/Cliente.ibd | 0 | 0 | 0.0000 | 7 | 212992 | 30427.4286 | 212992 | 100.00 | |
/var/lib/mysql/sakila/address.ibd | 9 | 196608 | 21845.3333 | 0 | 0 | 0.0000 | 196608 | 0.00 | |
/var/lib/mysql/sakila/film_category.ibd | 8 | 180224 | 22528.0000 | 0 | 0 | 0.0000 | 180224 | 0.00 | |
/var/lib/mysql/sakila/city.ibd | 7 | 163840 | 23405.7143 | 0 | 0 | 0.0000 | 163840 | 0.00 | |
/var/lib/mysql/sakila/customer.ibd | 7 | 163840 | 23405.7143 | 0 | 0 | 0.0000 | 163840 | 0.00 | |
/var/lib/mysql/sakila/staff.ibd | 6 | 147456 | 24576.0000 | 0 | 0 | 0.0000 | 147456 | 0.00 | |
/var/lib/mysql/pw/usuario.ibd | 5 | 131072 | 26214.4000 | 0 | 0 | 0.0000 | 131072 | 0.00 | |
/var/lib/mysql/#innodb_temp/temp_6.ibt | 0 | 0 | 0.0000 | 3 | 114688 | 38229.3333 | 114688 | 100.00 |
|