You are here
Some more details about DiskSyncSize
DiskSyncSize is a MySQL Cluster parameter and was added in MySQL 5.1.23.
After the amount of stored bytes of data per file, the data node will
fsync (flush) the LCP file to disk, even if a
fsync is not needed for consistency.
This is done because the OS will otherwise buffer all the writes, and when a
fsync is really needed, it can take a lot of time...
Originally this parameter was hard coded. Now it defaults to 4 Mbyte.
DiskSyncSize is related to the parameters
NoOfDiskPagesToDiskAfterRestartACC which are deprecated right now. It does NOT replace the parameter
This parameter should not be changed on any OS (with reasonable settings). With
ODIRECT it is not used at all.
Thanks to Jonas for the help.