Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

WAL journal file size keeps on growing #133

Open
georgeslabreche opened this issue Feb 21, 2023 · 0 comments
Open

WAL journal file size keeps on growing #133

georgeslabreche opened this issue Feb 21, 2023 · 0 comments
Labels
bug Something isn't working

Comments

@georgeslabreche
Copy link
Collaborator

georgeslabreche commented Feb 21, 2023

Some context with the following similar issue:
https://sqlite.org/forum/info/54e791a519a225de

This issue results in a ~80 MB WAL database file for ~15,000 records. Tarring results in a 99% compression ratio so it's not bad for downlinking but bad for onboard disk usage. Consider that using the default journal mode results in ~630 KB database file for the same amount of data.

The current workaround is to not use WAL and revert to the default journal mode all while making the journal mode configurable via the application's config file: #130

We eventually want to use WAL because in the default mode a single write to the database locks the database for a short time, nothing, even reading, can access the database file at all. We need to use the WAL option so that reading and writing can proceed concurrently.

For the time being, it's OK to use the default journal mode instead of WAL because of the following mutex constraint: #132

@georgeslabreche georgeslabreche added the bug Something isn't working label Feb 21, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

1 participant