Tune database settings
Currently the database SQLITE3 settings are setup for speed. And therefore it cannot handle power outages well. If you need for what ever reason a different SQLITE3 setup, you can create a file called data/.database-env with the following contents:
1
[pragma setting name]=[value]
All SQLITE3 pragmas should be supported. Make sure you use the correct pragma name and value. Only the entered values will be overwritten from the default.
For example the current defaults are:
1
2
3
4
5
auto_vacuum=NONE
cache_size=-10000
journal_mode=WAL
synchronous=OFF
temp_store=MEMORY
If you need more stability you can use the following settings:
1
synchronous=FULL
This post is licensed under CC BY 4.0 by the author.