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 | 23 | 2490368 | 108276.8696 | 203 | 38699008 | 190635.5074 | 41189376 | 93.95 | |
/var/lib/mysql/mysql.ibd | 460 | 7585792 | 16490.8522 | 837 | 13713408 | 16384.0000 | 21299200 | 64.38 | |
/var/lib/mysql/undo_001 | 385 | 6356992 | 16511.6675 | 565 | 9256960 | 16384.0000 | 15613952 | 59.29 | |
/var/lib/mysql/undo_002 | 387 | 6389760 | 16511.0078 | 561 | 9191424 | 16384.0000 | 15581184 | 58.99 | |
/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 | 416 | 9043968 | 21740.3077 | 9043968 | 100.00 | |
/var/lib/mysql/ib_logfile1 | 2 | 66048 | 33024.0000 | 1949 | 2661888 | 1365.7712 | 2727936 | 97.58 | |
/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/sakila/film_actor.ibd | 17 | 327680 | 19275.2941 | 0 | 0 | 0.0000 | 327680 | 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 | |
/var/lib/mysql/sakila/inventory.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/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/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/czech/errmsg.sys | 3 | 304266 | 101422.0000 | 0 | 0 | 0.0000 | 304266 | 0.00 | |
/usr/share/mysql-8.0/slovak/errmsg.sys | 3 | 304033 | 101344.3333 | 0 | 0 | 0.0000 | 304033 | 0.00 |
|