On 11/10/2016 06:25 AM, Andrii Motsok wrote:
Hi,
I have sqlite database on top of ext3 (on ssd).
Does
1) ext3 parameters (data=writeback|ordered,barrier=0|1, etc)
2) drive write-caching setting (hdparm -W) value
3) ???
There's a thread here:
https://www.redhat.com/archives/ext3-users/2010-July/msg00000.html
It seems to be that if your drive has write-caching enabled, you need
barrier=1 to avoid risking corruption. Or you can get away with
barrier=0 if write-caching is disabled.
Also:
http://www.sqlite.org/draft/lockingv3.html#ext3-barrier-problem
Dan.
have impact on the possibility of losing data due to power loss? If yes which
parameters should be used to achieve maximum safety against loosing of the data
due to power loss during writing to WAL database?
3) Are there any other settings (system, sqlite, etc) which could increase
protection against data corruption after power lost or system crash?
Regards,
Andrii
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
