Hi folks. I have been seeing issues in Plex for about a week and a half. Issue: Spinning activity monitor in Plex Web + unable to scan my libraries and usually is so slow it doesn’t allow users to play media (internally or externally). Repeating issues in the Plex Media Scanner.log file: Aug 03, …

To update anyone else having a slow DB issue and/or a large DB filesize, the search + fix was a combination of two items. Most of the info below is above, but this hopefully summarizes it: Identifying an item in the DB that had over 2 million associated files Editing the DB to remove all those…

Thanks for the detail @Volts ! [root@plex testing-new]# sqlite3 -header com.plexapp.plugins.library.db “select id,library_section_id,guid,title from metadata_items where id = 519628” id|library_section_id|guid|title 519628|3|plex://movie/5d7770dd7a53e9001e7aceaa|Coyote Lake [root@plex testing-ne…

It’s very interesting that you don’t see it in the Library. It seems like it makes sense to remove it and scan/empty/clean bundles/optimize DB. But it might take a long time to remove 2 million extras. Make sure you have Debug logging enabled before you do it, and maybe do it before you go to bed …

I’m living on the edge and doing it now :slight_smile: Deleted the file and it’s still scanning the movies for “subs” Scanning movies: subs Once done I’ll do the other steps and report back.

Whoa, cancel that! Viewing the Plex Media Server.log while it was scanning the movies, it was removing entries related to “Coyote Lake” about one every 3 seconds, so this would take weeks, if not months to remove all 2 million. Is there instead a way to edit the DB and just delete anything that mat…

Hey @Volts or anyone - any thoughts to my question above about if we can just edit the DB directly and search/and/delete anything that matches “Coyote Lake”? If I just let it do it via the plexmediaserver process, it will take months (literally) to delete all of the 2 million entries. :frowning: . …

Read this thread and post. I can review more later, but It may give what you need. [image] Slow library performance due to increasingly growing database Plex Media Server Might not be the best SQL queries but for reference I used these, with regards to: Delete all entr…

Thanks @Volts for the info! It appears to have cleared out the 2 million+ extras and I can now scan the libraries again w/o it hanging up the system. The DB is still large at 6.4GB (down from 6.6GB) and optimizing it still takes roughly 30 minutes (and hangs the system during this time). I’ll have…

Sweet, I’m glad that worked for you! Thanks for sharing back to the thread. Credit to @shayanzadeh too, I stole the majority of their pretty SQL. The change I sent you (and you included above) is a bigger shotgun, removing any non-referenced extras. @OttoKerner you mentioned in the other thread th…

[image] Volts: pinging you here in case this is worth attaching to the same issue. Done. Thank you!

[image] jakehoms: t appears to have cleared out the 2 million+ extras and I can now scan the libraries again w/o it hanging up the system. Hi I am starting an investigation into these issues and I will need to establish if this was the impact of an old bug or whether it is still happening an…

Slow Query time - unable to scan or play media

Plex Media Server

Volts September 10, 2021, 12:37am 35

Read this thread and post. I can review more later, but It may give what you need.

He gave the SQL commands he used. They may be appropriate for you as well.

Topic		Replies	Views
Slow library performance due to increasingly growing database Plex Media Server server-linux	77	3005	May 23, 2022
DB locks and wait times Plex Media Server server-linux , server-docker	56	1010	March 13, 2022
Calling all users with MASSIVE libraries Plex Media Server server-linux	24	476	May 12, 2022
SLOW QUERY errors Plex Media Server server-docker , server-unraid	65	3173	December 21, 2021
I think something may be wrong with my Plex database, how can I be sure? Metadata & Adding Files server-mac	10	1333	November 14, 2020

Slow Query time - unable to scan or play media

Related topics