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 | 87 | 13942784 | 160261.8851 | 16384000 | 85.10 | |
/var/lib/mysql/ibtmp1 | 0 | 0 | 0.0000 | 143 | 14729216 | 103001.5105 | 14729216 | 100.00 | |
/var/lib/mysql/undo_001 | 388 | 6406144 | 16510.6804 | 306 | 5013504 | 16384.0000 | 11419648 | 43.90 | |
/var/lib/mysql/undo_002 | 385 | 6356992 | 16511.6675 | 270 | 4423680 | 16384.0000 | 10780672 | 41.03 | |
/var/lib/mysql/mysql.ibd | 429 | 7077888 | 16498.5734 | 193 | 3162112 | 16384.0000 | 10240000 | 30.88 | |
/var/lib/mysql/#innodb_temp/temp_10.ibt | 0 | 0 | 0.0000 | 315 | 6012928 | 19088.6603 | 6012928 | 100.00 | |
/var/lib/mysql/world/Country.MYD | 3936 | 1027296 | 261.0000 | 0 | 0 | 0.0000 | 1027296 | 0.00 | |
/var/lib/mysql/sakila/rental.ibd | 53 | 917504 | 17311.3962 | 0 | 0 | 0.0000 | 917504 | 0.00 | |
/var/lib/mysql/sakila/payment.ibd | 48 | 835584 | 17408.0000 | 0 | 0 | 0.0000 | 835584 | 0.00 | |
/var/lib/mysql/ib_logfile1 | 2 | 66048 | 33024.0000 | 479 | 565760 | 1181.1273 | 631808 | 89.55 | |
/usr/share/mysql-8.0/russian/errmsg.sys | 3 | 318782 | 106260.6667 | 0 | 0 | 0.0000 | 318782 | 0.00 | |
/usr/share/mysql-8.0/ukrainian/errmsg.sys | 3 | 313356 | 104452.0000 | 0 | 0 | 0.0000 | 313356 | 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/italian/errmsg.sys | 3 | 305277 | 101759.0000 | 0 | 0 | 0.0000 | 305277 | 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.ibd | 15 | 294912 | 19660.8000 | 0 | 0 | 0.0000 | 294912 | 0.00 | |
/var/lib/mysql/sakila/film_actor.ibd | 15 | 294912 | 19660.8000 | 0 | 0 | 0.0000 | 294912 | 0.00 | |
/var/lib/mysql/sakila/inventory.ibd | 14 | 278528 | 19894.8571 | 0 | 0 | 0.0000 | 278528 | 0.00 | |
/var/lib/mysql/latihan_pertemuan3/kue.ibd | 0 | 0 | 0.0000 | 7 | 212992 | 30427.4286 | 212992 | 100.00 | |
/var/lib/mysql/latihan_pertemuan3/bahan_baku.ibd | 0 | 0 | 0.0000 | 7 | 212992 | 30427.4286 | 212992 | 100.00 | |
/var/lib/mysql/sakila/customer.ibd | 8 | 180224 | 22528.0000 | 0 | 0 | 0.0000 | 180224 | 0.00 |
|