Library.db size more than doubled in latest version

Plex Media Server
,
304

You could process the db files on a different system, then move them back to your “real” server. The OS does not have to be the same. For example, you could run PMS on Linux and use PMS on Windows to de-bloat the db file.

PMS1 = current server; PMS2 = new/different server for processing db files

  1. Install & claim PMS 1.41.8.9834 on a different system, PMS2. Do not create any libraries. In Settings → Libraries, disable Empty trash automatically after every scan.

  2. Stop PMS on both systems.

  3. On PMS2, delete the existing (empty) db files.

  4. Copy com.plexapp.plugins.library.db and com.plexapp.plugins.library.blobs.db from PMS1 to PMS2.

  5. Start PMS2.

  6. Using WebTools-NG or POST/curl listed by @drzoidberg33 (two posts above), initiate a Database Optimization on PMS2.

  7. Hum the Jeopardy theme song while you wait for the process to complete.

  8. When finished, stop PMS2 (and PMS1 if still running).

  9. On PMS1, rename com.plexapp.plugins.library.db and com.plexapp.plugins.library.blobs.db to .bak/.save (or just delete them if you’ve a copy elsewhere).
    On PMS1, delete any -shm and -wal files (they normally go away when PMS is stopped).

  10. Copy com.plexapp.plugins.library.db and com.plexapp.plugins.library.blobs.db from PMS2 to PMS1.

  11. Start PMS1.

1 Like