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 | 160 | 2.50 MiB | 16.00 KiB | 8.61 MiB | 29.04 | |
@@datadir/undo_002 | 382 | 6.02 MiB | 16.13 KiB | 126 | 1.97 MiB | 16.00 KiB | 7.98 MiB | 24.66 | |
@@datadir/ibdata1 | 20 | 2.33 MiB | 119.20 KiB | 30 | 5.20 MiB | 177.60 KiB | 7.53 MiB | 69.09 | |
@@datadir/mysql.ibd | 347 | 5.47 MiB | 16.14 KiB | 21 | 336.00 KiB | 16.00 KiB | 5.80 MiB | 5.66 | |
@@datadir/#innodb_temp/temp_10.ibt | 0 | 0 bytes | 0 bytes | 19 | 1008.00 KiB | 53.05 KiB | 1008.00 KiB | 100.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/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/slovak/errmsg.sys | 3 | 296.91 KiB | 98.97 KiB | 0 | 0 bytes | 0 bytes | 296.91 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 | 168 | 164.00 KiB | 1000 bytes | 228.50 KiB | 71.77 | |
@@datadir/#innodb_temp/temp_9.ibt | 0 | 0 bytes | 0 bytes | 5 | 208.00 KiB | 41.60 KiB | 208.00 KiB | 100.00 | |
@@datadir/sakila/city.ibd | 7 | 160.00 KiB | 22.86 KiB | 0 | 0 bytes | 0 bytes | 160.00 KiB | 0.00 | |
@@datadir/sakila/film.ibd | 6 | 144.00 KiB | 24.00 KiB | 0 | 0 bytes | 0 bytes | 144.00 KiB | 0.00 | |
@@datadir/test19/voiture.ibd | 5 | 128.00 KiB | 25.60 KiB | 0 | 0 bytes | 0 bytes | 128.00 KiB | 0.00 | |
@@datadir/Table_insertion/ecurie.ibd | 4 | 112.00 KiB | 28.00 KiB | 0 | 0 bytes | 0 bytes | 112.00 KiB | 0.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/sakila/country.ibd | 4 | 112.00 KiB | 28.00 KiB | 0 | 0 bytes | 0 bytes | 112.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_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 |
|