search

eigenein / my-iot-rs

Yet another home automation (alpha)
https://eigenein.github.io/my-iot-rs/html
MIT License
32 stars 5 forks source link

WAL autocheckpointing doesn't seem to work #175

Closed eigenein closed 3 years ago

eigenein commented 3 years ago

Try setting to 1000: https://www.sqlite.org/pragma.html#pragma_wal_autocheckpoint

.rw-r--r-- 118k pi 30 Sep 16:00 my-iot.sqlite3
.rw-r--r--  12M pi 13 Oct 14:14 my-iot.sqlite3-shm
.rw-r--r-- 7.0G pi 13 Oct 14:08 my-iot.sqlite3-wal
eigenein commented 3 years ago

This actually may be okay, since all automatic checkpoints are PASSIVE which means the journal file doesn't get truncated.