Frequent add/remove media operations: Advanced database maintenance needed?

Plex Media Server Desktops & Laptops
1

Server Version#: Version 1.14.1.5488
Server OS: Windows 10 Pro
Clients: AppleTV 4K, iOS
Plex DB: SSD System Drive
Plex Media: SSD Internal Drive + USB 3.0 WD Drives

I have a Plex server setup I am happy with; handling 5 users, 20 libraries and 5Tb of fairly stable media. All working nicely.

Outside of Plex I download a lot of media which I have been watching via Emby to keep the media separate from my “clean and tidy” Plex DB. Then, if I want to keep the media (films, music videos, TV programmes, Music, Photos) I move it to Plex and make sure all the meta data is exactly as I want it.

I am now considering combining everything into Plex but I am concerned that with frequent (weekly) and large (approx. 20Gb/50 files) adding and deleting that it will fragment and mess up the Plex DB.

I currently schedule cleanups and maintenace but with a lot of adding and removing am I best keeping these unwatched and unverified media separate or is Plex DB maintenance that good that it will not degrade performance over time?

2

The daily Plex database maintenance should handle this just fine.
Provided it has a chance to actually run. If the server is powered down or hibernating during the scheduled maintenance hours, the database doesn’t get optimized.

https://support.plex.tv/articles/201553286-scheduled-tasks/

1 Like
3

Is there any way (or need) to schedule maintenance to run more frequently than weekly?

Since the GUI just allows for checkboxes for the weekly tasks these are checked. Additionally I can manually run the jobs via GUI but can this be scripted to run more often?

4

General maintenance (including database optimization) is run daily.
Only some of those jobs are run less frequently (those, which won’t make much sense to run more frequently).

5

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.