###

Berkeley DB Reference Guide:
  Transaction Subsystem

# Configuring transactions

There is only a single parameter used in configuring transactions; the DB_TXN_NOSYNC flag. Setting the DB_TXN_NOSYNC flag to DB_ENV->set_flags when opening a transaction region changes the behavior of transactions to not synchronously flush the log during transaction commit.

This change will significantly increase application transactional throughput. However, it means that although transactions will continue to exhibit the ACI (atomicity, consistency, and isolation) properties, they will not have D (durability). Database integrity will be maintained, but it is possible that some number of the most recently committed transactions may be undone during recovery instead of being redone.

The application may also change the number of simultaneous outstanding transactions supported by the Berkeley DB environment by calling the DB_ENV->set_tx_max function. When this number is reached, additional calls to txn_begin will fail until some active transactions complete.

Copyright Sleepycat Software