Over this week I was using the Plex Media Server like normal and also searching and found this posting:
That led me to think about the harddrive in the mac mini and I realized that there were a few other programs that would be using the disk that the Plex databases reside on. I turned them off and used the Plex Media Server like normal and the logs showed fewer Errors and Warnings though still produced the slow query warnings, but fewer of them.
I tested with a couple people around the country that I share my Plex Media Server with and they had good performance with loading of pages and images as well as with streaming content.
So I think the databases are fine and it’s a matter of the disk usage. I specifically think it’s the blobs.db that is slow because posters are large(?).
I still wonder if a huge content move I did over a year ago while Plex was running may have complicated the databases or broken some indexing, plus I upgraded the OS on the mac mini a month and a half ago, and I migrated the Plex Media Server install from a laptop I had been running it on 7 years ago instead of starting with a fresh install.
That all makes me wonder if doing a backup of viewed state:
https://support.plex.tv/articles/201154527-move-viewstate-ratings-from-one-install-to-another/
Setting aside the current db and blobs.db.
Then a complete uninstall:
https://support.plex.tv/articles/201941078-uninstall-plex-media-server/
Then reinstalling Plex Media Server and letting it build a database from scratch might yield improvements. I’d check the file sizes of the new db and blobs.db files and watch the logs while I search through the web interface. I could load the previous watched states.
I think this is what I’m going to do because if it didn’t work out I could just drop the previous db’s in and restart Plex Media Server.
