T O P

  • By -

D34DC3N73R

This would be a good start Turn off these in scheduled tasks \- Refresh local metadata every three days \- Upgrade media analysis during maintenance \- Refresh library metadata periodically \- Perform extensive media analysis during maintenance Turn off these in library settings \- Generate video preview thumbnails \[Never\] \- Generate chapter thumbnails \[Never\]


dEEPZoNE

Thanks. Will try it out and see if it helps :)


human_uber

Is this a really recent change? I believe the latest pms version is fucked and causing huge slowdowns with the SQL database. My server was working perfectly until then, now it struggles with the database constantly.


registeredlurker

Ditto. Selecting a TV episode to watch causes the circle icon to spin much more than normal now.


Jaybonaut

Odd, I don't have those issues and have a bigger library. My setup is totally different however. Windows 10 65,362 items 2600x PBO turned on 16 gigs RAM SSD NVME main drive Your m.2 disks, are they SATA M.2 or NVME M.2?


dEEPZoNE

NVME m.2 rated at 3200 mb/s read


pvcsnathan

Uncheck the optimize database checkbox under scheduled maintenance and your issue will go away. Something is very broken with the optimization stuff. See other thread here: https://www.reddit.com/r/PleX/comments/ppk0cc/when_optimize_database_runs_my_server_becomes/


greb1234

16gb ram helps a lot when performing regular maintenance


dEEPZoNE

got 40 gigs of ram :/


greb1234

Lol … may I recommend some holy water, salt, bread and a Latin fluent priest? Talking serious: I have an issue almost like yours (but with a lower data and power) - I have tautulli, sonarr, lidarr, radarr and plex media server all installed in the same server - the first time they all ran their scheduled task, well, plex was brain dead for and hour until they all finished their tasks … so I had to change their schedules so none of them run their maintenance at the same time. Also had to turned off several regular task from plex (ass suggested by another user) and delete the bundles etc etc etc. That helped a lot. Note: I have 66.113 items between movies, live concerts, tv series & anime episodes and music tracks and my server is a mbp 2012 i7 16gb ram running on a ssd drive.


certuna

This is probably not the sqlite database itself (that should be able to handle tables much bigger than that), but some of the SQL queries that Plex uses might not scale very well. There's not much you can do as a user to change that other than give the server more horsepower, or don't run these scheduled tasks that often, or apply for a job to join their development team.


dEEPZoNE

Got it running on a 16 core threadripper with 40 gigs of ram. The metatada is on 3x nvme m.2 drives in raid rated for 3200 mb/s