Bug #40236 Cluster backup default parameters should be adjusted
Submitted: 22 Oct 2008 10:14 Modified: 23 Oct 2008 10:01
Reporter: Oli Sennhauser Email Updates:
Status: Verified Impact on me:
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S5 (Performance)
Version:mysql-5.1-telco-6.3 OS:Any
Assigned to: CPU Architecture:Any
Tags: 6.3. ff

[22 Oct 2008 10:14] Oli Sennhauser
The following backup default parameters are too low.

According to Jonas good values would be:

BackupMaxWriteSize   =  1M
BackupDataBufferSize = 16M
BackupLogBufferSize  =  4M
BackupMemory         = 20M

The speed up in a test I did was about 5 times for the LCP during startup phase.

Because it does not take too much memory (compared to other settings) I suggest to change the default settings.

How to repeat:
do a simple cluster start and measure for example with iostat/sar

Suggested fix:
change the default settings of these parameters to as described above.
[12 Mar 2009 17:43] Jonas Oreland
changed in 6.4
already documented i think
setting to documenting to be sure