Since many of you like to vacuum your databases, there is now a hidden config switch in the server configuration xml file.
For those not familiar, vacuuming your Sqlite database db files every once in a while can help compact them to a smaller size, and for some this may help improve performance. The server does not do this automatically because it can take a long time and no other database activity is possible while it is occurring.
How to Vacuum
Locate the system.xml file and set VacuumDatabaseOnStartup to true. On your next server startup, databases will be vacuumed, and this config switch will be automatically set back to false.
- This can take a long time depending your server machine performance and the size of your database files. For some it could take a few seconds, others several minutes or more.
- There is no way to monitor progress
- The best way to monitor for completion would be to wait until you see this in the server log:
Info App: Core startup complete
- In the server's data folder, I would suggest backing up all the *.db files first.
- Don't force kill the server process just because it's taking too long, you might be left with corrupted databases if you do.