Purges
Purges will delete activity records from your database.
Purges can be run manually.
Note
As of this writing, scheduled purges are not functional but are coming soon.
Purges use a query you define to choose which data to delete. For performance reasons they delete a limited number of records at a time.
A purge will run in cycles - deleting X records, waiting for a short delay, and repeating. The limit and delay are both configurable.
Why Purge
Deleting older or unnecessary data from your database is important for its health and performance.
The less data prism has to search, the faster it can search it.
Purges and Databases
Databases lock affected rows when deleting or updating and this can affect other queries. Not just searches but new data waiting for insert.
For example MySQL and MariaDB have innodb_buffer_pool
which is an allocation of memory for these locks.
By default, it can sometimes be comically small. Prism prints this value to your console on startup.
You may not have administrative access to change the value but if you do, we recommend at least 1-2GB.
Regardless, in your prism.conf
you can change the number of rows deleted at once in the purges.limit
setting.
The lower the number, the fewer the rows deleted at once. This reduces how many locks are used at time.