SELECT * FROM `x$io_global_by_file_by_bytes`
|
file | count_read | total_read | avg_read | count_write | total_written | avg_write | total | write_pct | |
---|---|---|---|---|---|---|---|---|---|
/var/lib/mysql/ibtmp1 | 0 | 0 | 0.0000 | 143 | 14729216 | 103001.5105 | 14729216 | 100.00 | |
/var/lib/mysql/undo_001 | 387 | 6389760 | 16511.0078 | 12 | 196608 | 16384.0000 | 6586368 | 2.99 | |
/var/lib/mysql/undo_002 | 382 | 6307840 | 16512.6702 | 11 | 180224 | 16384.0000 | 6488064 | 2.78 | |
/var/lib/mysql/mysql.ibd | 315 | 5210112 | 16540.0381 | 8 | 131072 | 16384.0000 | 5341184 | 2.45 | |
/var/lib/mysql/ibdata1 | 20 | 2441216 | 122060.8000 | 4 | 573440 | 143360.0000 | 3014656 | 19.02 | |
/usr/share/mysql-8.0/spanish/errmsg.sys | 3 | 305161 | 101720.3333 | 0 | 0 | 0.0000 | 305161 | 0.00 | |
/usr/share/mysql-8.0/french/errmsg.sys | 3 | 304914 | 101638.0000 | 0 | 0 | 0.0000 | 304914 | 0.00 | |
/usr/share/mysql-8.0/english/errmsg.sys | 3 | 303507 | 101169.0000 | 0 | 0 | 0.0000 | 303507 | 0.00 | |
/var/lib/mysql/ib_logfile1 | 2 | 66048 | 33024.0000 | 33 | 60416 | 1830.7879 | 126464 | 47.77 | |
/var/lib/mysql/StdMdDB/user.ibd | 4 | 114688 | 28672.0000 | 0 | 0 | 0.0000 | 114688 | 0.00 | |
/var/lib/mysql/#innodb_temp/temp_10.ibt | 0 | 0 | 0.0000 | 3 | 114688 | 38229.3333 | 114688 | 100.00 | |
/var/lib/mysql/#innodb_temp/temp_9.ibt | 0 | 0 | 0.0000 | 3 | 114688 | 38229.3333 | 114688 | 100.00 | |
/var/lib/mysql/#innodb_temp/temp_8.ibt | 0 | 0 | 0.0000 | 3 | 114688 | 38229.3333 | 114688 | 100.00 | |
/var/lib/mysql/#innodb_temp/temp_7.ibt | 0 | 0 | 0.0000 | 3 | 114688 | 38229.3333 | 114688 | 100.00 | |
/var/lib/mysql/#innodb_temp/temp_6.ibt | 0 | 0 | 0.0000 | 3 | 114688 | 38229.3333 | 114688 | 100.00 | |
/var/lib/mysql/#innodb_temp/temp_5.ibt | 0 | 0 | 0.0000 | 3 | 114688 | 38229.3333 | 114688 | 100.00 | |
/var/lib/mysql/#innodb_temp/temp_4.ibt | 0 | 0 | 0.0000 | 3 | 114688 | 38229.3333 | 114688 | 100.00 | |
/var/lib/mysql/#innodb_temp/temp_3.ibt | 0 | 0 | 0.0000 | 3 | 114688 | 38229.3333 | 114688 | 100.00 | |
/var/lib/mysql/#innodb_temp/temp_2.ibt | 0 | 0 | 0.0000 | 3 | 114688 | 38229.3333 | 114688 | 100.00 | |
/var/lib/mysql/#innodb_temp/temp_1.ibt | 0 | 0 | 0.0000 | 3 | 114688 | 38229.3333 | 114688 | 100.00 | |
/var/lib/mysql/sys/sys_config.ibd | 1 | 65536 | 65536.0000 | 0 | 0 | 0.0000 | 65536 | 0.00 | |
/var/lib/mysql/sakila/actor.ibd | 1 | 65536 | 65536.0000 | 0 | 0 | 0.0000 | 65536 | 0.00 | |
/var/lib/mysql/sakila/address.ibd | 1 | 65536 | 65536.0000 | 0 | 0 | 0.0000 | 65536 | 0.00 | |
/var/lib/mysql/sakila/city.ibd | 1 | 65536 | 65536.0000 | 0 | 0 | 0.0000 | 65536 | 0.00 | |
/var/lib/mysql/sakila/country.ibd | 1 | 65536 | 65536.0000 | 0 | 0 | 0.0000 | 65536 | 0.00 |
|