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 | 24 | 2506752 | 104448.0000 | 81 | 14024704 | 173144.4938 | 16531456 | 84.84 | |
/var/lib/mysql/ibtmp1 | 0 | 0 | 0.0000 | 143 | 14729216 | 103001.5105 | 14729216 | 100.00 | |
/var/lib/mysql/undo_002 | 390 | 6438912 | 16510.0308 | 383 | 6275072 | 16384.0000 | 12713984 | 49.36 | |
/var/lib/mysql/undo_001 | 389 | 6422528 | 16510.3548 | 324 | 5308416 | 16384.0000 | 11730944 | 45.25 | |
/var/lib/mysql/mysql.ibd | 472 | 7782400 | 16488.1356 | 82 | 1343488 | 16384.0000 | 9125888 | 14.72 | |
/var/lib/mysql/#innodb_temp/temp_10.ibt | 0 | 0 | 0.0000 | 456 | 9109504 | 19976.9825 | 9109504 | 100.00 | |
/var/lib/mysql/ib_logfile1 | 2 | 66048 | 33024.0000 | 445 | 375296 | 843.3618 | 441344 | 85.03 | |
/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 | |
/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/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/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/polish/errmsg.sys | 3 | 304436 | 101478.6667 | 0 | 0 | 0.0000 | 304436 | 0.00 | |
/usr/share/mysql-8.0/hungarian/errmsg.sys | 3 | 304148 | 101382.6667 | 0 | 0 | 0.0000 | 304148 | 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_pelanggan.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/customer.ibd | 9 | 196608 | 21845.3333 | 0 | 0 | 0.0000 | 196608 | 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 | 6 | 147456 | 24576.0000 | 0 | 0 | 0.0000 | 147456 | 0.00 |
|