June 2001
Intermediate to advanced
688 pages
19h 18m
English
There is only a single parameter used in configuring transactions: the DB_TXN_NOSYNC flag. Setting the DB_TXN_NOSYNC flag to DBENV→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 ...