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 | 67 | 8847360 | 132050.1493 | 11288576 | 78.37 | |
/var/lib/mysql/undo_001 | 388 | 6406144 | 16510.6804 | 225 | 3686400 | 16384.0000 | 10092544 | 36.53 | |
/var/lib/mysql/undo_002 | 384 | 6340608 | 16512.0000 | 216 | 3538944 | 16384.0000 | 9879552 | 35.82 | |
/var/lib/mysql/mysql.ibd | 435 | 7176192 | 16496.9931 | 41 | 671744 | 16384.0000 | 7847936 | 8.56 | |
/var/lib/mysql/#innodb_temp/temp_9.ibt | 0 | 0 | 0.0000 | 48 | 1245184 | 25941.3333 | 1245184 | 100.00 | |
/var/lib/mysql/#innodb_temp/temp_10.ibt | 0 | 0 | 0.0000 | 13 | 737280 | 56713.8462 | 737280 | 100.00 | |
/var/lib/mysql/ib_logfile1 | 2 | 66048 | 33024.0000 | 345 | 294912 | 854.8174 | 360960 | 81.70 | |
/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/korean/errmsg.sys | 3 | 306547 | 102182.3333 | 0 | 0 | 0.0000 | 306547 | 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/polish/errmsg.sys | 3 | 304436 | 101478.6667 | 0 | 0 | 0.0000 | 304436 | 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/hungarian/errmsg.sys | 3 | 304148 | 101382.6667 | 0 | 0 | 0.0000 | 304148 | 0.00 | |
/usr/share/mysql-8.0/english/errmsg.sys | 3 | 303507 | 101169.0000 | 0 | 0 | 0.0000 | 303507 | 0.00 | |
/var/lib/mysql/vedettfak/fa.ibd | 10 | 212992 | 21299.2000 | 0 | 0 | 0.0000 | 212992 | 0.00 | |
/var/lib/mysql/sakila/film_category.ibd | 8 | 180224 | 22528.0000 | 0 | 0 | 0.0000 | 180224 | 0.00 | |
/var/lib/mysql/sakila/city.ibd | 7 | 163840 | 23405.7143 | 0 | 0 | 0.0000 | 163840 | 0.00 | |
/var/lib/mysql/sakila/actor.ibd | 5 | 131072 | 26214.4000 | 0 | 0 | 0.0000 | 131072 | 0.00 | |
/var/lib/mysql/sakila/film.ibd | 5 | 131072 | 26214.4000 | 0 | 0 | 0.0000 | 131072 | 0.00 |
|