checkpoint buffers buffers

The option buffers indicates how many buffers must be written to the temporary log file before performing a checkpoint that commits ongoing transactions to disk. If this limit is reached while transactions are in process, the checkpoint will happen only after all transactions have finished to guarantee atomic transactions.

The smaller the number of buffers, less efficient will be the overall performance of the system, but the databases involved will be more often updated.

If the number of buffers is big, ZIM Backup Server, if running, will take more time to perform the backup process.

Regardless of the number of buffers, in case of a disk crash, ZIM server will automatically recover all consistent transactions present in the temporary transaction file.

A checkpoint is triggered whenever the number of checkpoint transactions or the number of checkpoint buffers happens first.

The number of buffers should always be less than the half of the number of Maximum Data Blocks; if this happens, the number of buffers is adjusted accordingly.

Valid Settings

Range between 1 and 1000000.