I am writing to a MySQL database residing on separate system. I made this change ages ago based on concerns with SQLite consistency. I do not remember the exact DB size.
My specific changes were:
- Reviewed and excluded items that had most DB entries that were not relevant as described here.
- Decreased purge_keep_days to 7
Once I made those changes, I had waited overnight for the purge to run.