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 | 72 | 14761984 | 205027.5556 | 17203200 | 85.81 | |
/var/lib/mysql/ibtmp1 | 0 | 0 | 0.0000 | 143 | 14729216 | 103001.5105 | 14729216 | 100.00 | |
/var/lib/mysql/undo_001 | 388 | 6406144 | 16510.6804 | 313 | 5128192 | 16384.0000 | 11534336 | 44.46 | |
/var/lib/mysql/undo_002 | 382 | 6307840 | 16512.6702 | 300 | 4915200 | 16384.0000 | 11223040 | 43.80 | |
/var/lib/mysql/mysql.ibd | 363 | 5996544 | 16519.4050 | 155 | 2539520 | 16384.0000 | 8536064 | 29.75 | |
/var/lib/mysql/ib_logfile1 | 2 | 66048 | 33024.0000 | 855 | 1098752 | 1285.0901 | 1164800 | 94.33 | |
/var/lib/mysql/sakila/rental.ibd | 68 | 1163264 | 17106.8235 | 0 | 0 | 0.0000 | 1163264 | 0.00 | |
/var/lib/mysql/sakila/payment.ibd | 65 | 1114112 | 17140.1846 | 0 | 0 | 0.0000 | 1114112 | 0.00 | |
/var/lib/mysql/#innodb_temp/temp_10.ibt | 0 | 0 | 0.0000 | 14 | 557056 | 39789.7143 | 557056 | 100.00 | |
/var/lib/mysql/sakila/inventory.ibd | 19 | 360448 | 18970.9474 | 0 | 0 | 0.0000 | 360448 | 0.00 | |
/var/lib/mysql/sakila/film_actor.ibd | 17 | 327680 | 19275.2941 | 0 | 0 | 0.0000 | 327680 | 0.00 | |
/var/lib/mysql/HospitalDB/nurse.ibd | 0 | 0 | 0.0000 | 14 | 327680 | 23405.7143 | 327680 | 100.00 | |
/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/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/serbian/errmsg.sys | 3 | 305888 | 101962.6667 | 0 | 0 | 0.0000 | 305888 | 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/czech/errmsg.sys | 3 | 304266 | 101422.0000 | 0 | 0 | 0.0000 | 304266 | 0.00 | |
/usr/share/mysql-8.0/danish/errmsg.sys | 3 | 304266 | 101422.0000 | 0 | 0 | 0.0000 | 304266 | 0.00 | |
/usr/share/mysql-8.0/slovak/errmsg.sys | 3 | 304033 | 101344.3333 | 0 | 0 | 0.0000 | 304033 | 0.00 |
|