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 | 21 | 2457600 | 117028.5714 | 78 | 18055168 | 231476.5128 | 20512768 | 88.02 | |
/var/lib/mysql/ibtmp1 | 0 | 0 | 0.0000 | 143 | 14729216 | 103001.5105 | 14729216 | 100.00 | |
/var/lib/mysql/undo_002 | 391 | 6455296 | 16509.7084 | 451 | 7389184 | 16384.0000 | 13844480 | 53.37 | |
/var/lib/mysql/undo_001 | 388 | 6406144 | 16510.6804 | 361 | 5914624 | 16384.0000 | 12320768 | 48.01 | |
/var/lib/mysql/mysql.ibd | 430 | 7094272 | 16498.3070 | 204 | 3342336 | 16384.0000 | 10436608 | 32.03 | |
/var/lib/mysql/#innodb_temp/temp_10.ibt | 0 | 0 | 0.0000 | 341 | 7159808 | 20996.5044 | 7159808 | 100.00 | |
/var/lib/mysql/sakila/payment.ibd | 65 | 1114112 | 17140.1846 | 0 | 0 | 0.0000 | 1114112 | 0.00 | |
/var/lib/mysql/ib_logfile1 | 2 | 66048 | 33024.0000 | 618 | 609792 | 986.7184 | 675840 | 90.23 | |
/var/lib/mysql/sakila/rental.ibd | 22 | 409600 | 18618.1818 | 0 | 0 | 0.0000 | 409600 | 0.00 | |
/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 | |
/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/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/norwegian/errmsg.sys | 3 | 303577 | 101192.3333 | 0 | 0 | 0.0000 | 303577 | 0.00 | |
/usr/share/mysql-8.0/english/errmsg.sys | 3 | 303507 | 101169.0000 | 0 | 0 | 0.0000 | 303507 | 0.00 | |
/var/lib/mysql/Rental_Mobil/Tb_transaksi.ibd | 0 | 0 | 0.0000 | 9 | 245760 | 27306.6667 | 245760 | 100.00 | |
/var/lib/mysql/Rental_Mobil/Tb_rekening.ibd | 0 | 0 | 0.0000 | 8 | 229376 | 28672.0000 | 229376 | 100.00 | |
/var/lib/mysql/Rental_Mobil/Tb_mobil.ibd | 0 | 0 | 0.0000 | 7 | 212992 | 30427.4286 | 212992 | 100.00 | |
/var/lib/mysql/#innodb_temp/temp_9.ibt | 0 | 0 | 0.0000 | 5 | 212992 | 42598.4000 | 212992 | 100.00 | |
/var/lib/mysql/Rental_Mobil/Tb_bank.ibd | 0 | 0 | 0.0000 | 7 | 212992 | 30427.4286 | 212992 | 100.00 |
|