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 | 12 | 12.00 MiB | 1.00 MiB | 12.00 MiB | 100.00 | |
@@datadir/undo_001 | 460 | 7.28 MiB | 16.21 KiB | 0 | 0 bytes | 0 bytes | 7.28 MiB | 0.00 | |
@@datadir/undo_002 | 396 | 6.28 MiB | 16.24 KiB | 0 | 0 bytes | 0 bytes | 6.28 MiB | 0.00 | |
@@datadir/mysql.ibd | 343 | 5.41 MiB | 16.14 KiB | 0 | 0 bytes | 0 bytes | 5.41 MiB | 0.00 | |
@@datadir/ibdata1 | 22 | 2.36 MiB | 109.82 KiB | 0 | 0 bytes | 0 bytes | 2.36 MiB | 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/english/errmsg.sys | 3 | 296.39 KiB | 98.80 KiB | 0 | 0 bytes | 0 bytes | 296.39 KiB | 0.00 | |
@@datadir/binlog.000010 | 29 | 206.01 KiB | 7.10 KiB | 1 | 1 bytes | 1 bytes | 206.01 KiB | 0.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_10.ibt | 0 | 0 bytes | 0 bytes | 3 | 112.00 KiB | 37.33 KiB | 112.00 KiB | 100.00 | |
@@datadir/#innodb_temp/temp_9.ibt | 0 | 0 bytes | 0 bytes | 3 | 112.00 KiB | 37.33 KiB | 112.00 KiB | 100.00 | |
@@datadir/#innodb_temp/temp_8.ibt | 0 | 0 bytes | 0 bytes | 3 | 112.00 KiB | 37.33 KiB | 112.00 KiB | 100.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_4.ibt | 0 | 0 bytes | 0 bytes | 3 | 112.00 KiB | 37.33 KiB | 112.00 KiB | 100.00 | |
@@datadir/#innodb_temp/temp_3.ibt | 0 | 0 bytes | 0 bytes | 3 | 112.00 KiB | 37.33 KiB | 112.00 KiB | 100.00 | |
@@datadir/#innodb_temp/temp_2.ibt | 0 | 0 bytes | 0 bytes | 3 | 112.00 KiB | 37.33 KiB | 112.00 KiB | 100.00 | |
@@datadir/#innodb_temp/temp_1.ibt | 0 | 0 bytes | 0 bytes | 3 | 112.00 KiB | 37.33 KiB | 112.00 KiB | 100.00 | |
@@datadir/ib_logfile1 | 2 | 64.50 KiB | 32.25 KiB | 13 | 47.50 KiB | 3.65 KiB | 112.00 KiB | 42.41 | |
@@datadir/sys/sys_config.ibd | 1 | 64.00 KiB | 64.00 KiB | 0 | 0 bytes | 0 bytes | 64.00 KiB | 0.00 | |
@@datadir/sakila/actor.ibd | 1 | 64.00 KiB | 64.00 KiB | 0 | 0 bytes | 0 bytes | 64.00 KiB | 0.00 | |
@@datadir/sakila/address.ibd | 1 | 64.00 KiB | 64.00 KiB | 0 | 0 bytes | 0 bytes | 64.00 KiB | 0.00 | |
@@datadir/sakila/category.ibd | 1 | 64.00 KiB | 64.00 KiB | 0 | 0 bytes | 0 bytes | 64.00 KiB | 0.00 | |
@@datadir/sakila/city.ibd | 1 | 64.00 KiB | 64.00 KiB | 0 | 0 bytes | 0 bytes | 64.00 KiB | 0.00 | |
@@datadir/sakila/country.ibd | 1 | 64.00 KiB | 64.00 KiB | 0 | 0 bytes | 0 bytes | 64.00 KiB | 0.00 |
|