+1 for this! I would love to move plex into my postgres server.
1 Like
Adding my two cents in support. Iād love to see Plex support databases other than SQLite3, preferably MariaDB/MySQL or PostgreSQL. Even just turning the database link into a POSIX socket with a default SQLite3 backend would allow users to put their libraries in a variety of faster, multi-threaded databases. SQLite just isnāt made for real workloads. Help us love Plex even more!
4 Likes
ummmm. Bump! This need priority
2 Likes
Donāt !
This is voting based!
1 Like
Another enthusiastic yes, please! SQLite3 is designed for small, temporary databases, not a library youāre using every day. Please, please, please allow us to use other backends (e.g., MariaDB/MySQL, Postgres) for the Plex library database.
3 Likes
+1 to supporting other databases at a high priority.
Iām tired of the famous db is busy waiting 200 seconds issue.
Iāve upgraded to SSD and it only cut down on this issue while Iām only at 70TB of media and itās only Myself, wife, and children that watch this.
I have mysql servers that get hit harder than this on lesser hardware without issues. It seems like an oversight in programming that this was set up in such a manner. Not to mention the fact that this sqllite db has wound up getting corrupted 3 times in the last 3-4 years. I have a mysql instance I use for numerous applications and Iāve never once dealt with a corruption issue.
I donāt even see myself as a power user, yes thereās quite a bit of content downloaded, but with a max of 4 people watching as mentioned previously, when no new content is coming in and yet these issues being present, it seems like you put a bottleneck in to your own application due to oversight in designā¦
Please take this seriously, make your application better, that would only make people happier.
7 Likes
Please, with the increase on number of tv show itās becoming a requirement!
Give us options or better database!
2 Likes
I would encourage anybody who is having performance issues and is wondering about SQL problems to open a new topic for discussion and troubleshooting.
I am aware of several instances where databases became unnecessarily large, which slowed things down. This wasnāt a SQLite issue, but fixing the data problems made a big difference.
I wish Plex allocated more cache to SQLite, but you can hack a quick 5x increase.
How big are peopleās .db files?
com.plexapp.plugins.library.db = 283 MB
com.plexapp.plugins.library.blobs.db = 1.2GB
Iāve optimized my DB for a 16K ZFS recordsize. Itās on six drive SSD raidz2. Even running from a ram drive does not seem to add any performance increase as Iām still seeing alerts in my logs about slow performance. ChuckPA came to the conclusion that Iām most likely CPU bound as Iām only running a 8 core 16 thread E5-2650 v2.
SQLite is a very bad option for a massive mediavault. Please implement MariaDB integration asap. Thank you.
1 Like
I want to vote to for a external database asap. Would be very very beneficial
Thank you
2 Likes
SQLite is a very bad option for a massive mediavault. Please implement MariaDB integration asap. Thank you. +1
3 Likes
+1 to supporting this as well
2 Likes
+10000 to supporting this.
Perhaps the devs could use SQLAlchemy in PMS so those of us who want to use a different database can use one. I do this now with HomeAssistant. It has SQLite as the default database but I use MS SQL Server for similar performance reasons listed above. It works very well.
https://www.sqlalchemy.org/features.html
SQLAlchemy includes dialects for SQLite, Postgresql, MySQL, Oracle, MS-SQL, Firebird, Sybase and others, most of which support multiple DBAPIs.
1 Like
Big plus one for this. Postgres makes the most sense because itās licence allows for redistribution as part of the package. This is the most obvious and most effective performance upgrade Plex could have
3 Likes
This is needed, I had to split my server out into three different instances as having a large music library absolutely crippled my servers performance
3 Likes
how big is it? i have many and my server performs well
1 Like
Just over 200k tracks after ripping my parents collection but I started seeing performance issues when I jumped from ~50k to 120k
1 Like
i have over 600k. 95% audiobooks.
it is working well for me, bit iām sure a plex database has itās limits
as i want to add lotās of media in the future, and will buy expensive hardware, itās important to have the best possible database system. but i canāt say what that would be
1 Like
+1
please give us external database to improve performance
1 Like
