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 | 21 | 2.34 MiB | 114.29 KiB | 67 | 15.97 MiB | 244.06 KiB | 18.31 MiB | 87.20 | |
@@datadir/ibtmp1 | 0 | 0 bytes | 0 bytes | 143 | 14.05 MiB | 100.59 KiB | 14.05 MiB | 100.00 | |
@@datadir/undo_002 | 390 | 6.14 MiB | 16.12 KiB | 450 | 7.03 MiB | 16.00 KiB | 13.17 MiB | 53.38 | |
@@datadir/undo_001 | 390 | 6.14 MiB | 16.12 KiB | 436 | 6.81 MiB | 16.00 KiB | 12.95 MiB | 52.59 | |
@@datadir/mysql.ibd | 440 | 6.92 MiB | 16.11 KiB | 80 | 1.25 MiB | 16.00 KiB | 8.17 MiB | 15.30 | |
@@datadir/#innodb_temp/temp_10.ibt | 0 | 0 bytes | 0 bytes | 194 | 4.22 MiB | 22.27 KiB | 4.22 MiB | 100.00 | |
@@datadir/#innodb_temp/temp_9.ibt | 0 | 0 bytes | 0 bytes | 212 | 4.12 MiB | 19.92 KiB | 4.12 MiB | 100.00 | |
@@datadir/sakila/rental.ibd | 70 | 1.14 MiB | 16.69 KiB | 0 | 0 bytes | 0 bytes | 1.14 MiB | 0.00 | |
@@datadir/sakila/payment.ibd | 67 | 1.09 MiB | 16.72 KiB | 0 | 0 bytes | 0 bytes | 1.09 MiB | 0.00 | |
@@datadir/ib_logfile1 | 2 | 64.50 KiB | 32.25 KiB | 547 | 445.00 KiB | 833 bytes | 509.50 KiB | 87.34 | |
@@datadir/sakila/inventory.ibd | 19 | 352.00 KiB | 18.53 KiB | 0 | 0 bytes | 0 bytes | 352.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 | |
@@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/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/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/english/errmsg.sys | 3 | 296.39 KiB | 98.80 KiB | 0 | 0 bytes | 0 bytes | 296.39 KiB | 0.00 | |
@@datadir/sampah/tabel_pengguna.ibd | 0 | 0 bytes | 0 bytes | 10 | 256.00 KiB | 25.60 KiB | 256.00 KiB | 100.00 | |
@@datadir/sakila/customer.ibd | 9 | 192.00 KiB | 21.33 KiB | 0 | 0 bytes | 0 bytes | 192.00 KiB | 0.00 | |
@@datadir/sakila/address.ibd | 8 | 176.00 KiB | 22.00 KiB | 0 | 0 bytes | 0 bytes | 176.00 KiB | 0.00 | |
@@datadir/sakila/film_category.ibd | 8 | 176.00 KiB | 22.00 KiB | 0 | 0 bytes | 0 bytes | 176.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 |
|