SQLite and ext3 journalling mode
danielk1977 at gmail.com
Wed Dec 8 11:52:32 UTC 2010
On 12/07/2010 04:31 AM, Ted Ts'o wrote:
> On Tue, Dec 07, 2010 at 01:42:08AM +0700, Dan Kennedy wrote:
>> Are SQLite users that are worried about losing data that has been
>> committed (fsynced) better off setting data=journal than
>> data=ordered (or even data=writeback)?
> Well, they won't be better off a data integrity point of view.
> Depending on how SQLite is configured, and how many fsync's are issued
> by SQLite in response to application queries, and depending on your
> background workload by other applications, using data=journal *might*
> be a performance win.
> In general, though, if you have background workloads that are
> downloading torrents, data=journal is going to hurt a lot. So I don't
> recommend it except for fairly specialized deployments where there's
> only one primary user of the file system.
Thanks. But to be clear, is data=ordered better than data=writeback
wrt. data integrity following a power failure?
More information about the Ext3-users