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/ibtmp1 | 0 | 0 bytes | 0 bytes | 143 | 14.05 MiB | 100.59 KiB | 14.05 MiB | 100.00 | |
@@datadir/mysql.ibd | 367 | 5.78 MiB | 16.13 KiB | 51 | 816.00 KiB | 16.00 KiB | 6.58 MiB | 12.11 | |
@@datadir/undo_001 | 384 | 6.05 MiB | 16.12 KiB | 30 | 480.00 KiB | 16.00 KiB | 6.52 MiB | 7.19 | |
@@datadir/undo_002 | 384 | 6.05 MiB | 16.12 KiB | 28 | 448.00 KiB | 16.00 KiB | 6.48 MiB | 6.75 | |
@@datadir/ibdata1 | 23 | 2.38 MiB | 105.74 KiB | 19 | 2.45 MiB | 132.21 KiB | 4.83 MiB | 50.81 | |
@@datadir/#innodb_temp/temp_10.ibt | 0 | 0 bytes | 0 bytes | 197 | 3.83 MiB | 19.90 KiB | 3.83 MiB | 100.00 | |
@@datadir/ib_logfile1 | 2 | 64.50 KiB | 32.25 KiB | 333 | 615.50 KiB | 1.85 KiB | 680.00 KiB | 90.51 | |
@@basedir/share/mysql-8.0/russian/errmsg.sys | 3 | 311.31 KiB | 103.77 KiB | 0 | 0 bytes | 0 bytes | 311.31 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/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/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/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/czech/errmsg.sys | 3 | 297.13 KiB | 99.04 KiB | 0 | 0 bytes | 0 bytes | 297.13 KiB | 0.00 | |
@@basedir/share/mysql-8.0/slovak/errmsg.sys | 3 | 296.91 KiB | 98.97 KiB | 0 | 0 bytes | 0 bytes | 296.91 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/HospitalDB/patient.ibd | 0 | 0 bytes | 0 bytes | 9 | 240.00 KiB | 26.67 KiB | 240.00 KiB | 100.00 | |
@@datadir/HospitalDB/nurse.ibd | 0 | 0 bytes | 0 bytes | 8 | 224.00 KiB | 28.00 KiB | 224.00 KiB | 100.00 | |
@@datadir/HospitalDB/specialist.ibd | 0 | 0 bytes | 0 bytes | 7 | 208.00 KiB | 29.71 KiB | 208.00 KiB | 100.00 | |
@@datadir/HospitalDB/ward.ibd | 0 | 0 bytes | 0 bytes | 7 | 208.00 KiB | 29.71 KiB | 208.00 KiB | 100.00 | |
@@datadir/HospitalDB/doctor.ibd | 0 | 0 bytes | 0 bytes | 7 | 208.00 KiB | 29.71 KiB | 208.00 KiB | 100.00 | |
@@datadir/sakila/address.ibd | 9 | 192.00 KiB | 21.33 KiB | 0 | 0 bytes | 0 bytes | 192.00 KiB | 0.00 | |
@@datadir/sakila/film_actor.ibd | 7 | 160.00 KiB | 22.86 KiB | 0 | 0 bytes | 0 bytes | 160.00 KiB | 0.00 | |
@@datadir/sakila/city.ibd | 6 | 144.00 KiB | 24.00 KiB | 0 | 0 bytes | 0 bytes | 144.00 KiB | 0.00 |
|