Turn off/on transaction’s data flushing to disk before commit. By default, each transaction has flush log set to ON. The command will affect only current connection’s transaction. 

Syntax  

SET FLUSH LOG {ON|OFF}

Description 

To speed up single update/insert/delete transaction, you may turn off log flushing per each transaction on commit. Instead, it will be flushed on checkpoint, or, if any other ACID transaction commits. NOTE: after crash or unexpected DB termination, the data modification after the last checkpoint (default, every 5 minutes) may be lost. Hence, turning off immediate logging will not corrupt database.