What settings to use for fastest reloading of a MySQL backup?
- by Alex R
I have a MySQL database which dumps to a 3.5 GB backup (mysqldump) in about 10 minutes.
But reloading this backup on a standby / test server takes upwards of 12 hours.
What are some settings that would maximize reloading performance?
The most promising appear to be innodb_buffer_pool_size, innodb_additional_mem_pool_size, and innodb_log_buffer_size... but I'm reaching the limits of my trial-and-error approach. Which of these settings "should" be the most important?
Through trial-and-error I was not able to get more than 70% CPU utilization and 63% memory utilization. I'd like both at 100% during a reload.
All tables are InnoDB.