- Click “Clear all statistics” and wait until kuma.db-wal stops growing.
- Click “Shrink database”
Run these commands to trim kuma.db-wal and reindex the sqlite database.
sqlite3 ./data/kuma.db "PRAGMA wal_checkpoint=TRUNCATE"
sqlite3 ./data/kuma.db "REINDEX"
THE CONTENT OF THIS POST IS PROVIDED “AS IS”, WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE CONTENT OR THE USE OR OTHER DEALINGS IN THE CONTENT.