As introduced in a separate thread , I believe the database could be improved as follows: PRAGMA synchronous from FULL to NORMAL. Note: The DB is already in WAL mode. PRAGMA temp_store from 0 to 2. Cache size (not default_cache_size) enlarged. Page_size enlarged from 1024 (which is the old def…

[image] exuberantShadow: https://emby.media/community/index.php?/topic/96065-performance-improvements-for-large-databases/ Link requires user sign-in. [image] exuberantShadow: Increasing cache_size to 512M or even 1024M , on the other hand, should give a significant improvement. As a …

Not sure if this is a “if you don’t know, don’t do it” type of thing, but I’ve managed to change my page size, just unsure of where the cache_size portion needs to be executed from? /usr/lib/plexmediaserver/ ? Thank you in advance, this thread has been a great read!

[image] jasonsansone: decides to try this It won’t be possible to try this right now with binary editing since the number of characters need to be same while replacing so the most you can try is 9999 (positive value means pages) or -999 (negative meaning kibibytes).

The above mentioned command should work when executed from /usr/lib/plexmediaserver/: [image] Volts: sed -i.orig \ -e 's/cache_size=2000/cache_size=9999/' \ 'Plex Media Server' If executed from elsewhere, you need to specify the complete path of the executable like /usr/lib/plexmediaserver/…

[image] Volts: -e 's/cache_size = 4096/cache_size = 9999/' As mentioned by @gbooker02 , that value is for iTunes and doesn’t really need to be changed. [image] gbooker02: The other page size mentioned found in the code is for connecting to the iTunes database so not really applicable to t…

It is also worth mentioning the obvious: Any binary changes won’t survive Plex updates unless you script for sed to run after each update.

So far it looks like the changes have been surviving updates. I run a pragma check after every update and the page size has stayed at 65536 each time. I’ve only ever had to run the tweaks once when I first did it. Overall client performance has been great, items on pages load almost instantly!

Following this with great interest, anything that boosts performance is great in my book… At least my 64 GB will get some usage out of them! Although, I jumped in rather too quick, and found out I can’t edit the settings from the .db in windows, and this sed tool isn’t exactly self explanatory, is …

Low effort bash script I threw together for the binary modifications: #!/bin/bash # Parameters are for linuxserver/plex containers # Adjust for other container distributions # https://forums.plex.tv/t/suggested-sqlite3-db-optimizations/794749/2 CONTAINER="plex" SHELL="/bin/bash" PLEX_DATA="/confi…

Suggested SQLite3 DB Optimizations

Plex Media Server

jasonsansone June 1, 2022, 1:35pm 32

As mentioned by @gbooker02, that value is for iTunes and doesn’t really need to be changed.

Topic		Replies	Views
Support Doc for Database Cache Size (MB)? General Discussions server-linux	220	12817	December 29, 2023
Database Cache Size Behavior Question Plex Media Server server-freebsd	9	2295	January 12, 2023
Sqlite3: Sleeping for 200ms to retry busy DB Plex Media Server server-linux	58	458	March 3, 2023
Calling all users with MASSIVE libraries Plex Media Server server-linux	23	525	February 11, 2022
[REQUEST] Move from SQLite to MySQL or Postgres Feature Suggestions	92	9542	June 11, 2022

Suggested SQLite3 DB Optimizations

Related topics