We have a database of about 100GB. However, most of this 100GB is "archived" data that we rarely access -- about 25GB is active data. We have
innodb_buffer_pool_size set to 48G, which is typically plenty. However, everyday cPanel runs a backup that includes
mysqldump of all our data -- and this fills up the buffer pool with data that is wasting RAM that could be used for something else.
I've read about using
innodb_old_blocks_time at https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-midpoint_insertion.html to help address this problem. My questions are:
innodb_old_blocks_time settings are recommended to deal with this?
(b) Any other strategies to address this problem?