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 | 106 | 18.80 MiB | 181.58 KiB | 21.12 MiB | 88.98 | |
@@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 | 479 | 7.48 MiB | 16.00 KiB | 13.59 MiB | 55.06 | |
@@datadir/undo_002 | 385 | 6.06 MiB | 16.12 KiB | 461 | 7.20 MiB | 16.00 KiB | 13.27 MiB | 54.30 | |
@@datadir/mysql.ibd | 441 | 6.94 MiB | 16.11 KiB | 155 | 2.42 MiB | 16.00 KiB | 9.36 MiB | 25.88 | |
@@datadir/#innodb_temp/temp_10.ibt | 0 | 0 bytes | 0 bytes | 38 | 1.16 MiB | 31.16 KiB | 1.16 MiB | 100.00 | |
@@datadir/sakila/rental.ibd | 53 | 896.00 KiB | 16.91 KiB | 0 | 0 bytes | 0 bytes | 896.00 KiB | 0.00 | |
@@datadir/sakila/payment.ibd | 50 | 848.00 KiB | 16.96 KiB | 0 | 0 bytes | 0 bytes | 848.00 KiB | 0.00 | |
@@datadir/ib_logfile1 | 2 | 64.50 KiB | 32.25 KiB | 759 | 723.00 KiB | 975 bytes | 787.50 KiB | 91.81 | |
@@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/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/danish/errmsg.sys | 3 | 297.13 KiB | 99.04 KiB | 0 | 0 bytes | 0 bytes | 297.13 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/sakila/film_actor.ibd | 15 | 288.00 KiB | 19.20 KiB | 0 | 0 bytes | 0 bytes | 288.00 KiB | 0.00 | |
@@datadir/sakila/inventory.ibd | 14 | 272.00 KiB | 19.43 KiB | 0 | 0 bytes | 0 bytes | 272.00 KiB | 0.00 | |
@@datadir/Inventory_Husan_Preet_Singh/Products.ibd | 0 | 0 bytes | 0 bytes | 7 | 208.00 KiB | 29.71 KiB | 208.00 KiB | 100.00 | |
@@datadir/Inventory_Husan_Preet_Singh/Suppliers.ib... | 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/staff.ibd | 8 | 176.00 KiB | 22.00 KiB | 0 | 0 bytes | 0 bytes | 176.00 KiB | 0.00 | |
@@datadir/sakila/customer.ibd | 8 | 176.00 KiB | 22.00 KiB | 0 | 0 bytes | 0 bytes | 176.00 KiB | 0.00 |
|