Xtrabackup restore memory
We use Clustercontrol to take and restore backups but when the apply-logs runs innobackupex only uses default 100MB memory. The backup-my.cnf created in the backup directory doesn't have any use-memory options. In the my.cnf for the server we set :
How can we get the restore process to use more memory to speed up.
I'm going to report this case to Cluster Control development team. In fact the backup-my.cnf contains only basic parameters to start the instance, the rest of parameters are provided via a flag or should be taken from [mysqld] or [xtradbbackup] sections for the restore. However, it may be that in your case the restore process is not checking for my.cnf instead it's running only on defaults.
I've made sure that:
Is present both on the server that the backup is taken from and on the server that runs the verification. But innobackupex still only uses the defaults in DATA_DIR/backup-my.cnf.
The generated file needs to contain the option or it should be possible to pass options to the restore job from Clustercontrol.
Anyway, there was a typo suggested by Bart. It should be "[xtrabackup]" and not "[xtradbbackup]".
I just also find it strange that the setting is not taken from my.cnf [xtrabackup] group. Anyway, we are going to improve this area by introducing an option in the UI so cmon could pass the value via --use-memory parameter to innobackupex during --apply-log stage.
Please sign in to leave a comment.