With the inclusion of the server setting Database Cache Size (MB) will plex be supplying a support doc on how best to tune this for admins and their specific system ? I have my own opinions for my system however, I’d like to see what plex recommends for any given system and its resources. BTW… tha…

I get your point. For now, I’m keeping an eye on the .exe to see where it ends up. Does the fact that it keeps increasing mean that the larger cache is actually being used? And if so, what would trigger such an increase in memory usage? You can tell I’m a noob when it comes to databases :wink:

@VBB When I offered to help with the script for Windows, Would it help if I write out the command sequence ? Is that easy to put into Windows and have it error check results ?

I appreciate it, but I don’t think I need it at this time. Sounded like the other guy really wanted it, though :slight_smile:

@ChuckPa I did the update, increased cache to 900mb, I have a large 800mb db and a fast system with lots of ram. I’ve been chasing this issue for a log time. Does your tool work on Hotio plex docker? I used this tool last week but I’m still having issues. [image] GitHub - bullmoose20/Pl…

[image] Sittingmongoose: Does your tool work on Hotio plex docker? Yes, it should work inside any docker container. I know I have expressly given instructions how to stop Plex for Official Plex and Linuxserver.io Plex. As long as Plex is stopped and you’re in there as “root” ( uid=0 ), i…

[image] Volts: I’m also pretty sure that if you set the value larger than the database size, it won’t use more memory. Exactly my thinking also. If your DB is 500mb then why increase this cache to 1GB ? This is a db cache (at least by its name) and not a server process or some other backgrou…

[image] anon5074910: I wonder why plex would add this setting Because it can help some users with particularly big media collections. Who had to resort to binary patching until now. Suggested SQLite3 DB Optimizations

Sure and I’m aware of that thread but was more pointing the question to @Volts and his comments :slight_smile: Anyhow, round the houses we have gone so I’ll head back to my OP and look for a recommendation from plex on when to change this and what we change it to ? Everyone has a perspective on wh…

Any way to run this on windows?

It’s doing precisely the same as the “low level database recovery” in this article: https://support.plex.tv/articles/repair-a-corrupted-database/

Support Doc for Database Cache Size (MB)?

General Discussions

Topic		Replies	Views
Suggested SQLite3 DB Optimizations Plex Media Server server-linux	141	4896	March 13, 2023
Library.db size more than doubled in latest version Plex Media Server server-windows , server-linux	429	17002	December 6, 2025
DBRepair development Apps & Creations	1291	28495	October 17, 2026
Sqlite3: Sleeping for 200ms to retry busy DB Plex Media Server server-linux	58	556	March 3, 2023
Would it be possible to get some help with -[Req#a34/Database optimization/com.plexapp.plugins.libra Remote Access server-synology , media-optimizer	47	551	July 12, 2023

Support Doc for Database Cache Size (MB)?

Related topics