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…

@ChuckPa Did you get a chance to look at those logs Chuck? thanks in advance.

Get ready for a huge performance hit as you load more songs and your DB grows. I know I’m having a rant but mine now times out in plexamp loading tracks - elan has advised the app is timing out which is true and OK you can drop $$$$ on a server but I still think sql-lite isn’t great for large data…

[image] mr_plex_au: Get ready for a huge performance hit as you load more songs and your DB grows. I’m curious but what amount of content do you have ? I’ve … Movies → 3,770 TV Show → 816 with 34,006 episodes Music → 727 artist with 6178 albums and 88,458 tracks … and my music grows by a…

[image] mr_plex_au: I know I’m having a rant but mine now times out in plexamp loading tracks - elan has advised the app is timing out which is true and OK you can drop $$$$ on a server but I still think sql-lite isn’t great for large databases by design. Really? RAID 0 NVMe ? Minimally…

[image] triks_melb: Its currently re-indexing but I’d guess there are around 2m tracks. Is that 2 million?

[image] triks_melb: To get a better understanding of what to expect and what investments to make for your Plex server, it would be really helpful to hear from someone with proper server hardware and at least a 5m track catalogue to share their experience 5 million? I don’t think you’ll find …

[image] Tony_T: 5 million? Yeah that does seem insane - what are they running an alternative to spotify off their plex :wink: I think spotify has something like 100 million… I just looked, and I thought I had pretty big music library and at 21k something tracks… heheh

Hi! Fore some reason, when I apply a collection tag to my video files, the request takes forever to complete and I have alerts about that in logs. SQLite file is under 25MB, CPU load is normal, HDD load is normal too. Any other type of metadata editing works instantly, do you think your tool woul…

Please take all NON-DB FILE-SPECIFIC issues to their own threads. This thread is not for discussing Music or Collections It’s solely about the physical DB and its operation. Please ping from those new threads as needed. Thanks

On Windows 10 here: If the mentioned script basically defragments the files in the database, I wonder if simply restoring an image backup of its partition wouldn’t work just as well? Is there something more it does (other than the “Optimize” button in PMS? Maybe all I need it the Vacuuming command? …

Support Doc for Database Cache Size (MB)?

General Discussions

Tony_T December 19, 2023, 11:15am 230

Will the new Plex Server (in beta) effect DBRepair.sh

Topic		Replies	Views
Suggested SQLite3 DB Optimizations Plex Media Server server-linux	141	4360	March 13, 2023
Library.db size more than doubled in latest version Plex Media Server server-windows , server-linux	429	15922	December 6, 2025
DBRepair development Apps & Creations	940	18021	July 11, 2026
Sqlite3: Sleeping for 200ms to retry busy DB Plex Media Server server-linux	58	435	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	429	July 12, 2023

Support Doc for Database Cache Size (MB)?

Related topics