MySQL Bugs: #40236: Cluster backup default parameters should be adjusted

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:	None
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

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
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.

changed in 6.4
already documented i think
setting to documenting to be sure