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/undo_001 | 388 | 6.11 MiB | 16.12 KiB | 210 | 3.28 MiB | 16.00 KiB | 9.39 MiB | 34.94 | |
@@datadir/ibdata1 | 20 | 2.33 MiB | 119.20 KiB | 17 | 6.67 MiB | 401.88 KiB | 9.00 MiB | 74.13 | |
@@datadir/undo_002 | 384 | 6.05 MiB | 16.12 KiB | 185 | 2.89 MiB | 16.00 KiB | 8.94 MiB | 32.34 | |
@@datadir/mysql.ibd | 413 | 6.50 MiB | 16.12 KiB | 20 | 320.00 KiB | 16.00 KiB | 6.81 MiB | 4.59 | |
@@datadir/#innodb_temp/temp_9.ibt | 0 | 0 bytes | 0 bytes | 107 | 1.98 MiB | 18.99 KiB | 1.98 MiB | 100.00 | |
@@datadir/sakila/payment.ibd | 50 | 848.00 KiB | 16.96 KiB | 0 | 0 bytes | 0 bytes | 848.00 KiB | 0.00 | |
@@datadir/#innodb_temp/temp_10.ibt | 0 | 0 bytes | 0 bytes | 10 | 544.00 KiB | 54.40 KiB | 544.00 KiB | 100.00 | |
@@datadir/ib_logfile1 | 2 | 64.50 KiB | 32.25 KiB | 287 | 257.00 KiB | 917 bytes | 321.50 KiB | 79.94 | |
@@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/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/english/errmsg.sys | 3 | 296.39 KiB | 98.80 KiB | 0 | 0 bytes | 0 bytes | 296.39 KiB | 0.00 | |
@@datadir/sakila/customer.ibd | 6 | 144.00 KiB | 24.00 KiB | 0 | 0 bytes | 0 bytes | 144.00 KiB | 0.00 | |
@@datadir/sakila/address.ibd | 5 | 128.00 KiB | 25.60 KiB | 0 | 0 bytes | 0 bytes | 128.00 KiB | 0.00 | |
@@datadir/sakila/rental.ibd | 5 | 128.00 KiB | 25.60 KiB | 0 | 0 bytes | 0 bytes | 128.00 KiB | 0.00 | |
@@datadir/sakila/staff.ibd | 5 | 128.00 KiB | 25.60 KiB | 0 | 0 bytes | 0 bytes | 128.00 KiB | 0.00 | |
@@datadir/sakila/store.ibd | 5 | 128.00 KiB | 25.60 KiB | 0 | 0 bytes | 0 bytes | 128.00 KiB | 0.00 | |
@@datadir/#innodb_temp/temp_7.ibt | 0 | 0 bytes | 0 bytes | 3 | 112.00 KiB | 37.33 KiB | 112.00 KiB | 100.00 | |
@@datadir/#innodb_temp/temp_6.ibt | 0 | 0 bytes | 0 bytes | 3 | 112.00 KiB | 37.33 KiB | 112.00 KiB | 100.00 | |
@@datadir/#innodb_temp/temp_5.ibt | 0 | 0 bytes | 0 bytes | 3 | 112.00 KiB | 37.33 KiB | 112.00 KiB | 100.00 | |
@@datadir/#innodb_temp/temp_4.ibt | 0 | 0 bytes | 0 bytes | 3 | 112.00 KiB | 37.33 KiB | 112.00 KiB | 100.00 |
|