Library.db size more than doubled in latest version

After investigating the issue further I actually don’t think the automatic pruning will help here.

The best solution for now is to manually delete the rows in the statistics_bandwidth table.

I’m working on looking at adding a database migration to do this on a PMS update, but if you feel comfortable doing it yourself then you can just run this command from the SQLite command line (see here on how to access this: https://support.plex.tv/articles/repair-a-corrupted-database/)

Always ensure PMS is not running when doing this.

delete from statistics_bandwidth where account_id is NULL;

then run:

VACUUM;

This may take a while, just be patient.

8 Likes