[kdepim-users] Offline Email

Pablo Sanchez pablo at blueoakdb.com
Tue Jun 21 18:26:48 BST 2016


[ Comments below, in-line ]


On Tue, 21 Jun 2016 13:17:37 -0400, Michael Mol wrote:

> innodb_flush_log_at_trx_commit = 2

I would suggest leaving the above value at '1'  '1' provides ACID 
compliance - no possible loss of data due to a system interruption.

'2' OTOH *may* result in data loss up to the last sync to disk.  Sync's 
are scheduled once a second however they are not guaranteed to be 
processed.

It'd be a bit of a bummer to have your database get corrupted while 
you're offline with little access to the Internet (e.g. a plane)

Cheers,

--
Pablo Sanchez - Blueoak Database Engineering, Inc
Ph:    819.459.1926        iNum:  883.5100.0990.1054




More information about the kdepim-users mailing list