I recently learned that innodb_autoextend_increment should be set at around 1% to 5% of the entire file system. Right now we’re using a very small autoextend-size and I’m therefore planning on increasing it.
However, I’m concerned that our ibdata now is pretty fragmented all over the disk because of this low autoextend-size. Should I be concerned about this?
I’m considering rebuilding the table by mysqldumping the entire thing and importing it with new settings. Would this work as intended?
All advice are very welcome. Thank you!