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/ibtmp1 | 0 | 0 | 0.0000 | 143 | 14729216 | 103001.5105 | 14729216 | 100.00 | |
/var/lib/mysql/ibdata1 | 20 | 2441216 | 122060.8000 | 66 | 8503296 | 128837.8182 | 10944512 | 77.69 | |
/var/lib/mysql/undo_001 | 388 | 6406144 | 16510.6804 | 213 | 3489792 | 16384.0000 | 9895936 | 35.26 | |
/var/lib/mysql/undo_002 | 384 | 6340608 | 16512.0000 | 215 | 3522560 | 16384.0000 | 9863168 | 35.71 | |
/var/lib/mysql/mysql.ibd | 359 | 5931008 | 16520.9136 | 37 | 606208 | 16384.0000 | 6537216 | 9.27 | |
/var/lib/mysql/#innodb_temp/temp_8.ibt | 0 | 0 | 0.0000 | 18 | 1015808 | 56433.7778 | 1015808 | 100.00 | |
/var/lib/mysql/#innodb_temp/temp_9.ibt | 0 | 0 | 0.0000 | 17 | 933888 | 54934.5882 | 933888 | 100.00 | |
/var/lib/mysql/sakila/rental.ibd | 53 | 917504 | 17311.3962 | 0 | 0 | 0.0000 | 917504 | 0.00 | |
/var/lib/mysql/sakila/payment.ibd | 50 | 868352 | 17367.0400 | 0 | 0 | 0.0000 | 868352 | 0.00 | |
/var/lib/mysql/#innodb_temp/temp_10.ibt | 0 | 0 | 0.0000 | 14 | 688128 | 49152.0000 | 688128 | 100.00 | |
/var/lib/mysql/#innodb_temp/temp_7.ibt | 0 | 0 | 0.0000 | 9 | 540672 | 60074.6667 | 540672 | 100.00 | |
/var/lib/mysql/sakila/film_actor.ibd | 17 | 327680 | 19275.2941 | 0 | 0 | 0.0000 | 327680 | 0.00 | |
/usr/share/mysql-8.0/ukrainian/errmsg.sys | 3 | 313356 | 104452.0000 | 0 | 0 | 0.0000 | 313356 | 0.00 | |
/var/lib/mysql/ib_logfile1 | 2 | 66048 | 33024.0000 | 273 | 247296 | 905.8462 | 313344 | 78.92 | |
/var/lib/mysql/sakila/inventory.ibd | 16 | 311296 | 19456.0000 | 0 | 0 | 0.0000 | 311296 | 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/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/swedish/errmsg.sys | 3 | 304360 | 101453.3333 | 0 | 0 | 0.0000 | 304360 | 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/english/errmsg.sys | 3 | 303507 | 101169.0000 | 0 | 0 | 0.0000 | 303507 | 0.00 |
|