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 | 328 | 44924928 | 136966.2439 | 47366144 | 94.85 | |
/var/lib/mysql/undo_001 | 389 | 6422528 | 16510.3548 | 931 | 15253504 | 16384.0000 | 21676032 | 70.37 | |
/var/lib/mysql/undo_002 | 385 | 6356992 | 16511.6675 | 916 | 15007744 | 16384.0000 | 21364736 | 70.25 | |
/var/lib/mysql/mysql.ibd | 465 | 7667712 | 16489.7032 | 496 | 8126464 | 16384.0000 | 15794176 | 51.45 | |
/var/lib/mysql/ibtmp1 | 0 | 0 | 0.0000 | 143 | 14729216 | 103001.5105 | 14729216 | 100.00 | |
/var/lib/mysql/#innodb_temp/temp_10.ibt | 0 | 0 | 0.0000 | 241 | 6307840 | 26173.6100 | 6307840 | 100.00 | |
/var/lib/mysql/ib_logfile1 | 2 | 66048 | 33024.0000 | 1766 | 2135040 | 1208.9694 | 2201088 | 97.00 | |
/var/lib/mysql/#innodb_temp/temp_9.ibt | 0 | 0 | 0.0000 | 56 | 1703936 | 30427.4286 | 1703936 | 100.00 | |
/var/lib/mysql/sakila/rental.ibd | 51 | 884736 | 17347.7647 | 0 | 0 | 0.0000 | 884736 | 0.00 | |
/var/lib/mysql/sakila/payment.ibd | 48 | 835584 | 17408.0000 | 0 | 0 | 0.0000 | 835584 | 0.00 | |
/var/lib/mysql/klo/ChangeLogs.ibd | 0 | 0 | 0.0000 | 27 | 540672 | 20024.8889 | 540672 | 100.00 | |
/var/lib/mysql/klo/Vehicles.ibd | 0 | 0 | 0.0000 | 20 | 425984 | 21299.2000 | 425984 | 100.00 | |
/var/lib/mysql/klo/Rentals.ibd | 0 | 0 | 0.0000 | 20 | 425984 | 21299.2000 | 425984 | 100.00 | |
/var/lib/mysql/klo/RentalPoints.ibd | 0 | 0 | 0.0000 | 20 | 425984 | 21299.2000 | 425984 | 100.00 | |
/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/korean/errmsg.sys | 3 | 306547 | 102182.3333 | 0 | 0 | 0.0000 | 306547 | 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/english/errmsg.sys | 3 | 303507 | 101169.0000 | 0 | 0 | 0.0000 | 303507 | 0.00 | |
/var/lib/mysql/klo/Parks.ibd | 0 | 0 | 0.0000 | 12 | 294912 | 24576.0000 | 294912 | 100.00 |
|