[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