Notifications
Clear all

Orphan Tables on the Databases

4 Posts
2 Users
0 Reactions
256 Views
RealAct
Posts: 238
Topic starter
(@realact)
Reputable Member
Joined: 7 years ago

Every once in a while, I optimize databases and take a look to see if previously installed plugins or any updated plugins have left orphan tables and other leftovers. 

Upon reviewing today, my Database optimizing plugin says it found over 74 orphan tables on our databases! And what's worse, most of those tables are set to "autoload" which can for sure cause pages to load slowly.

Before I go ahead and just delete them, I want to make sure these are really orphan and not an error or false positives by the databases' optimization plugin.

Now, most of the tables were actually created by WPDiscuz, so I'll go there and ask them about those, but wanted your feedback on the ones created by WPForo.

https://imgur.com/a/dl35lRO

https://imgur.com/mpcX6qt

Thanks in advance.

 

3 Replies
Sofy
Posts: 4872
 Sofy
Admin
(@sofy)
Support Team
Joined: 7 years ago

I'll ask the developers and get back to you soon. 

Reply
2 Replies
Sofy
 Sofy
Admin
(@sofy)
Joined: 7 years ago

Support Team
Posts: 4872

Hi,

Those aren't separate tables; they're just rows within the wp_options table. Everything is correct, so there's no need to worry.

Reply
RealAct
(@realact)
Joined: 7 years ago

Reputable Member
Posts: 238

@sofy Thank you for your answer, I understand. However, more than one Database Cleaner is telling me those raws/tables are not being used, and they are set to "autostart". I'm trying to streamline our databases and optimize them as much as possible because we had too many tables on Autostart. 

We had over 2K tables on autostart, which accounted for over 2MB of data. That was slowing us down (The max recommended size is 1MB) Ours is a very old site and over the years of testing plugins or simply removing them because they were no longer needed they left traces and leftovers on the database, sadly this happens with many WordPress plugins which do not remove all their settings when uninstalled.

Thankfully we have now brought it down to 1MB the max recommended, but we want to bring it down even further.

If those tables are needed by your software, of course, they need to stay. But I want to make sure of this. So I want to know if it would be ok to just delete them or just remove them from "Autostart".

Thank you.

Reply