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 | 19 | 2.31 MiB | 124.63 KiB | 69 | 15.89 MiB | 235.83 KiB | 18.20 MiB | 87.30 | |
@@datadir/undo_002 | 495 | 7.83 MiB | 16.19 KiB | 428 | 6.69 MiB | 16.00 KiB | 14.52 MiB | 46.07 | |
@@datadir/ibtmp1 | 0 | 0 bytes | 0 bytes | 143 | 14.05 MiB | 100.59 KiB | 14.05 MiB | 100.00 | |
@@datadir/undo_001 | 406 | 6.44 MiB | 16.24 KiB | 349 | 5.45 MiB | 16.00 KiB | 11.89 MiB | 45.86 | |
@@datadir/mysql.ibd | 411 | 6.47 MiB | 16.12 KiB | 147 | 2.30 MiB | 16.00 KiB | 8.77 MiB | 26.20 | |
@@datadir/#innodb_temp/temp_10.ibt | 0 | 0 bytes | 0 bytes | 132 | 3.44 MiB | 26.67 KiB | 3.44 MiB | 100.00 | |
@@datadir/ib_logfile1 | 2 | 64.50 KiB | 32.25 KiB | 828 | 1.31 MiB | 1.62 KiB | 1.38 MiB | 95.42 | |
@@datadir/sakila/payment.ibd | 65 | 1.06 MiB | 16.74 KiB | 0 | 0 bytes | 0 bytes | 1.06 MiB | 0.00 | |
@@datadir/sakila/rental.ibd | 20 | 368.00 KiB | 18.40 KiB | 0 | 0 bytes | 0 bytes | 368.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 | |
@@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/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 | |
@@basedir/share/mysql-8.0/english/errmsg.sys | 3 | 296.39 KiB | 98.80 KiB | 0 | 0 bytes | 0 bytes | 296.39 KiB | 0.00 | |
@@datadir/INFS1200_RELEASE/Policy.ibd | 0 | 0 bytes | 0 bytes | 9 | 240.00 KiB | 26.67 KiB | 240.00 KiB | 100.00 | |
@@datadir/INFS1200_RELEASE/Customer.ibd | 0 | 0 bytes | 0 bytes | 8 | 224.00 KiB | 28.00 KiB | 224.00 KiB | 100.00 | |
@@datadir/INFS1200_RELEASE/Vehicle.ibd | 0 | 0 bytes | 0 bytes | 8 | 224.00 KiB | 28.00 KiB | 224.00 KiB | 100.00 | |
@@datadir/INFS1200_RELEASE/VehicleCodeMapping.ibd | 0 | 0 bytes | 0 bytes | 8 | 224.00 KiB | 28.00 KiB | 224.00 KiB | 100.00 | |
@@datadir/INFS1200_RELEASE/Address.ibd | 0 | 0 bytes | 0 bytes | 8 | 224.00 KiB | 28.00 KiB | 224.00 KiB | 100.00 |
|