'Database Cache Size (MB)' Optimal Setting for Large Library

Hi, what is the optimal number to input in the ‘Database Cache Size (MB)’ for a large library? Mu library’s cache folder is 5.98GB and my metadata folder is 12.4GB. The default setting is 40MB. Do I need to raise this? Please explain the ‘why?’ and what the ideal value should be for me?

Server Version#: 1.32.5.7349
Player Version#:
<If providing server logs please do NOT turn on verbose logging, only debug logging should be enabled>

You might want to have a look at this thread.

1 Like

I read that thread but still did not find any specific answers.

The gist of the thread is:
There’s no „one-size-fits-all ideal configuration“. If you run into very specific issues you can start testing to increase the cache size in small increments.

There’s no need to increase the value just for the sake of increasing it.

Your right, no one wants to answer the specific question on the cache size outside of 1) leave it alone and leave it at the default and 2) run chucks tool → GitHub - ChuckPa/PlexDBRepair: Database repair utility for Plex Media Server databases which itself will have a significant performance gain if its never been run before on your db.

1 Like

Ok got it, I experience no issues at home but during remote play I notice Plex transcoding and downgrading video quality even though quality is set to directplay/directstream and maximum quality output on both sides. I was curious if increasing the number would impact this and/or have other performance benefits.

I have definitely never done anything like this. I use Windows 11 for my server and I do not use RAID. It is just standard playback from my internal hard drives. Will the GitHub utility still work for me?

Yes, I believe it has a windows batch script. I’m a linux guy so windows is not my thing.

But reach out on that other thread and the community folks should help with any questions.

I read through the github link. I’m not comfortable running the .bat script without seeing exact steps laid out. I am sure there are some file locations that need to be updated within the script. I have ran .bat scripts before, but this one is more complex and I’m nervous about how it might affect my PMS if I do something wrong.

If you read through the thread Support Doc for Database Cache Size (MB)? that will give you all the information you need. The github link is the tool itself.

Reach out to ChuckPa within that thread, he is always willing to help and is the owner of the tool.

if everything works fine locally, then it is most likely not a database problem.

likewise, if the same file plays locally, but not remotely, then its not a file problem.

that primarily leaves either a transcoding resource issue, or a network issue, or an unnoticed misconfiguration that causes a transcoding/network issue.

or it could just be the network between your server and your client.

is it just one remote client? then look at client config/network.
is it all remote clients/all files? then look at server config/network

probably best for you to start a new thread with all of the specific details of your network/server/client and go from there, as this thread here isn’t about troubleshooting connection/transcoding/quality problems.

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