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 | 444 | 7.03 MiB | 16.22 KiB | 21 | 336.00 KiB | 16.00 KiB | 7.36 MiB | 4.46 | |
@@datadir/undo_002 | 405 | 6.42 MiB | 16.24 KiB | 9 | 144.00 KiB | 16.00 KiB | 6.56 MiB | 2.14 | |
@@datadir/mysql.ibd | 339 | 5.34 MiB | 16.14 KiB | 22 | 352.00 KiB | 16.00 KiB | 5.69 MiB | 6.04 | |
@@datadir/ibdata1 | 18 | 2.30 MiB | 130.67 KiB | 13 | 1.00 MiB | 78.77 KiB | 3.30 MiB | 30.33 | |
@@datadir/#innodb_temp/temp_10.ibt | 0 | 0 bytes | 0 bytes | 11 | 496.00 KiB | 45.09 KiB | 496.00 KiB | 100.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/polish/errmsg.sys | 3 | 297.30 KiB | 99.10 KiB | 0 | 0 bytes | 0 bytes | 297.30 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/ib_logfile1 | 2 | 64.50 KiB | 32.25 KiB | 42 | 74.00 KiB | 1.76 KiB | 138.50 KiB | 53.43 | |
@@datadir/binlog.000008 | 26 | 119.86 KiB | 4.61 KiB | 1 | 1 bytes | 1 bytes | 119.86 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_8.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_6.ibt | 0 | 0 bytes | 0 bytes | 3 | 112.00 KiB | 37.33 KiB | 112.00 KiB | 100.00 | |
@@datadir/sys/sys_config.ibd | 4 | 112.00 KiB | 28.00 KiB | 0 | 0 bytes | 0 bytes | 112.00 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_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 |
|