SELECT * FROM `io_global_by_file_by_bytes`
|
file | count_read | total_read | avg_read | count_write | total_written | avg_write | total | write_pct | |
---|---|---|---|---|---|---|---|---|---|
@@datadir/ibdata1 | 20 | 2.33 MiB | 119.20 KiB | 171 | 37.31 MiB | 223.44 KiB | 39.64 MiB | 94.13 | |
@@datadir/undo_001 | 388 | 6.11 MiB | 16.12 KiB | 1147 | 17.92 MiB | 16.00 KiB | 24.03 MiB | 74.58 | |
@@datadir/undo_002 | 385 | 6.06 MiB | 16.12 KiB | 992 | 15.50 MiB | 16.00 KiB | 21.56 MiB | 71.88 | |
@@datadir/ibtmp1 | 0 | 0 bytes | 0 bytes | 143 | 14.05 MiB | 100.59 KiB | 14.05 MiB | 100.00 | |
@@datadir/#innodb_temp/temp_10.ibt | 0 | 0 bytes | 0 bytes | 439 | 10.17 MiB | 23.73 KiB | 10.17 MiB | 100.00 | |
@@datadir/mysql.ibd | 443 | 6.97 MiB | 16.11 KiB | 109 | 1.70 MiB | 16.00 KiB | 8.67 MiB | 19.64 | |
@@datadir/#innodb_temp/temp_9.ibt | 0 | 0 bytes | 0 bytes | 109 | 2.33 MiB | 21.87 KiB | 2.33 MiB | 100.00 | |
@@datadir/ib_logfile1 | 2 | 64.50 KiB | 32.25 KiB | 1207 | 923.00 KiB | 783 bytes | 987.50 KiB | 93.47 | |
@@datadir/sakila/rental.ibd | 51 | 864.00 KiB | 16.94 KiB | 0 | 0 bytes | 0 bytes | 864.00 KiB | 0.00 | |
@@datadir/sakila/payment.ibd | 48 | 816.00 KiB | 17.00 KiB | 0 | 0 bytes | 0 bytes | 816.00 KiB | 0.00 | |
@@datadir/sakila/film_actor.ibd | 17 | 320.00 KiB | 18.82 KiB | 0 | 0 bytes | 0 bytes | 320.00 KiB | 0.00 | |
@@basedir/share/mysql-8.0/ukrainian/errmsg.sys | 3 | 306.01 KiB | 102.00 KiB | 0 | 0 bytes | 0 bytes | 306.01 KiB | 0.00 | |
@@datadir/sakila/film.ibd | 16 | 304.00 KiB | 19.00 KiB | 0 | 0 bytes | 0 bytes | 304.00 KiB | 0.00 | |
@@datadir/sakila/inventory.ibd | 16 | 304.00 KiB | 19.00 KiB | 0 | 0 bytes | 0 bytes | 304.00 KiB | 0.00 | |
@@basedir/share/mysql-8.0/german/errmsg.sys | 3 | 303.87 KiB | 101.29 KiB | 0 | 0 bytes | 0 bytes | 303.87 KiB | 0.00 | |
@@basedir/share/mysql-8.0/japanese/errmsg.sys | 3 | 303.67 KiB | 101.22 KiB | 0 | 0 bytes | 0 bytes | 303.67 KiB | 0.00 | |
@@basedir/share/mysql-8.0/korean/errmsg.sys | 3 | 299.36 KiB | 99.79 KiB | 0 | 0 bytes | 0 bytes | 299.36 KiB | 0.00 | |
@@basedir/share/mysql-8.0/portuguese/errmsg.sys | 3 | 299.28 KiB | 99.76 KiB | 0 | 0 bytes | 0 bytes | 299.28 KiB | 0.00 | |
@@basedir/share/mysql-8.0/dutch/errmsg.sys | 3 | 298.13 KiB | 99.38 KiB | 0 | 0 bytes | 0 bytes | 298.13 KiB | 0.00 | |
@@basedir/share/mysql-8.0/italian/errmsg.sys | 3 | 298.12 KiB | 99.37 KiB | 0 | 0 bytes | 0 bytes | 298.12 KiB | 0.00 | |
@@basedir/share/mysql-8.0/romanian/errmsg.sys | 3 | 298.07 KiB | 99.36 KiB | 0 | 0 bytes | 0 bytes | 298.07 KiB | 0.00 | |
@@basedir/share/mysql-8.0/spanish/errmsg.sys | 3 | 298.01 KiB | 99.34 KiB | 0 | 0 bytes | 0 bytes | 298.01 KiB | 0.00 | |
@@basedir/share/mysql-8.0/french/errmsg.sys | 3 | 297.77 KiB | 99.26 KiB | 0 | 0 bytes | 0 bytes | 297.77 KiB | 0.00 | |
@@basedir/share/mysql-8.0/polish/errmsg.sys | 3 | 297.30 KiB | 99.10 KiB | 0 | 0 bytes | 0 bytes | 297.30 KiB | 0.00 | |
@@basedir/share/mysql-8.0/hungarian/errmsg.sys | 3 | 297.02 KiB | 99.01 KiB | 0 | 0 bytes | 0 bytes | 297.02 KiB | 0.00 |
|