Server Version#: 1.23.3.4707 Player Version#: 1.33.0.2444-a220eae4 I’m seeing a whole load of SLOW QUERY errors in the PMS logs. Media is on unRAID array, Plex Metadata/DB/Config is on a dedicated SATA SSD, not unRAID cache drive. Using official Plex container. Jun 28, 2021 14:36:12.934 [0x15513…

Overseer running in Docker but that has always been installed. I run 2 servers (one on NAS (Synology) and other on Shield) I just find PMS on NAS extremely sluggish mostly shows up as Unavailable. Only indexed large Music folder (approx. 30k albums). What gets me is PlexMediaServer process is always…

about. 6 hours ago I downgraded to image: plexinc/pms-docker:1.23.6.4881-e2e58f321 And I see a lot fewer slow query messages (which is not a very good indicator, there might just be less debug info in the codebase calling that). But more importantly I see less occurrences of the scanning stalling. …

Aug 31, 2021 08:09:45.921 [0x7fdaa4987b38] Error — Error issuing curl_easy_perform(handle): 28 Aug 31, 2021 08:18:16.266 [0x7fdaa49e2b38] Error — Resources:CPUUtilization: Unexpected result when reading /proc/5733/stat Aug 31, 2021 08:24:40.179 [0x7fdaa47c9b38] Error — Resources:CPUUtilization: Unex…

I’ve came across this issue it seems that when you have large collection of movies/ tv shows the sqlite database can’t handle the amount of transactions with default cache size. I was able to fix it by increasing the “PRAGMA default_cache_size” on the plex db. depending on your setup, if you’re on…

It’s a very large Music only library on a Synology NAS (Linux) so I’ll give that a go…

Is the cache size dependant on RAM (my NAS is 4GB) or how do I determine the right cache size? PMS on the Synology DSM 7 is located at “/var/packages/PlexMediaServer/home/Plex Media Server/Plug-in Support/Databases/com.plexapp.plugins.library.db” sqlite3 is at usr/bin

Yeah the cache size is depending on how much ram you have :slight_smile: I have 16GB in my server and I only gave mine 600 MB it made a huge difference.

Do you believe Plex uses default_cache_size? I don’t think it does, and I don’t believe setting default_cache_size in the .db file is effective. I’ve observed that Plex Media Server explicitly sets cache_size when opening database files, overriding and ignoring any default_cache_size set in the .db…

you mind showing me a screenshot or a stacktrace of this explicitly being set by Plex? because when I check the schemas it’s set to the value that I applied?

SLOW QUERY errors

Plex Media Server

Sky952 August 31, 2021, 12:39am 44

oh also one more thing might help is in increase your folder watch size

Linux Tips

This might help out as well, since the collection is music

Topic		Replies	Views
I think something may be wrong with my Plex database, how can I be sure? Metadata & Adding Files server-mac	9	1339	August 16, 2020
Slow Query time - unable to scan or play media Plex Media Server server-linux	64	1787	November 24, 2021
Slow or unresponsive Plex Debian Server Plex Media Server server-linux , server-docker	37	1127	January 21, 2022
General slowness of my server on Plex Web General Discussions server-linux , plex-web	45	549	January 14, 2025
Library Slow Query - 'Recommended' Tab Plex Media Server server-linux	14	281	August 17, 2025

SLOW QUERY errors

Related topics