Welcome to our forums! Please take a few moments to read through our Community Guidelines (also conveniently linked in the header at the top of each page). There, you'll find guidelines on conduct, tips on getting the help you may be searching for, and more!

How to clean the Database ??

vincenvincen Posts: 748Members, Plex Pass, Plex Pro Installer Plex Pass

Hi

After some investigations with Plex guy it looks like I have some issues in my database (request that takes too long without reasons, and some errors). He suggested me to do the dump but it didn't change much of the problem. I'm checking db and I noticed that there is some important qtities of records that look incomplete or rest of stuffs that don't exist anymore ! Normally the optimisation of db in Plex is supposed to clean all these remaining craps no ?
What can I do to clean it more deeply and get it working correctly ? I didn't find anything on the net for more deeply cleaning and optimisation as I don't want to rebuild the whole library (too many medias with manual detection and too many users plus lost status of read, forget it !). Or isn't there a way to export it by an SQL request that would in same time clean all partial stuffs incomplete or bad records ?

Thanks for help,

Vincèn

NAS Ubuntu 16.04.1 LTS (full ZFS) + Latest Plex Pass PMS - Samsung SmartHub TV + PMP on Intel NUC + Android clients + Chromecast Audio PlexPro Installer
Sign In or Register to comment.