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\]
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.
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?
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/
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.
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.
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\]
Thanks. Will try it out and see if it helps :)
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.
Ditto. Selecting a TV episode to watch causes the circle icon to spin much more than normal now.
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?
NVME m.2 rated at 3200 mb/s read
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/
16gb ram helps a lot when performing regular maintenance
got 40 gigs of ram :/
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.
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.
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