Database overhead.

Hello @sean-h,

I can assure you that PHP my admin would not provide false information and in case it shows no data in a certain table, most likely, this table is indeed empty.

Is there any chance that ManageWP is showing cached information?

You can consider posting a ticket from your SiteGround Client Area so we can check the case in detail. Please, make sure to include the report from ManageWP about the overhead MySQL data so we can review it as well.

Best regards,
Daniela Ivanova

Hi @daniellaivanova,

I’m quite sure phpMyAdmin is correct. It’s not the actual table that’s empty, but the last column on the far right for overhead, for all tables. And at the bottom, a big fat zero for total overhead. The entire database in question is only 108MB, so nothing to worry about when it comes to total size. But 500MB+ overhead on one table and I actually might want to look into things a bit deeper.

If ManageWP is showing cached info I have no idea where such a cache is or how to clear it. I have also opened a ticket with them but they haven’t given me anything to go on, yet. Like me, I think they are also scratching their heads right now. They did suggest a caching plugin could be doing this only I have no idea how, or why it would do this, so I thought I’d take a chance and open this ticket.

But I don’t think I’ll be opening an official SG support ticket as it would seem this problem is not with the SG Optimiser plugin nor anything else at Siteground. The thing is, if I do open an official SG support ticket, the only ‘report’ from ManageWP is a number in a box on the main dashboard. I may well end up ignoring this as I have been because it now looks like it is in fact a non issue. I also only use ManageWP to tell me things, and for the free monthly backups, but I will ultimately go in to each of my 7 sites and do it myself, such as updates and spam comment removal, and the confirmation of any reported database overhead.

Thank you for your feedback and detailed information. We will keep an eye out for similar reports in the future.

I hope the issue will be resolved soon. Still, we remain available in the WordPress forum and our ticketing system for future inquiries.

Best regards,
Daniela Ivanova

It’s back, only 0.1 MB this time, but it’s getting a bit annoying now. Also, I finally put 2 and 2 together: SG Optimizer only performs database optimisations on MyISAM, but all my sites are using InnoDB. My question is if ManageWP can detect and optimise overhead in an InnoDB database, can SG Optimizer also do something about InnoDB overhead?

Hello @sean-h,

By default our plugin only optimizes MyISAM database tables, as the optimization for InnoDB storage engine are done automatically by the engine itself.

More details regarding the optimization options of our plugin can be found here:
https://www.ads-software.com/plugins/sg-cachepress/

Please refer to the “SiteGround Optimizer Environment Page” section.

At this point, there are no plans to include InnoDB optimization option, as the InnoDB engine is generally better optimized for performance and table corruptions is something that is not to be expected, but we appropriate your feedback.

Best regards,
Tsvetan Mitev

Hi @tsvetanm,

Thank you. I am now going to put this to bed, once and for all.

Sorry, one last thing, then you won’t hear from me again, in this thread.

I know I asked for this a while ago, but do you think you can offer individual options for scheduled database maintenance, and/or manual on-demand options? The reason being is I actually like to keep post revisions for more than a week, as we might be working on multiple posts at the same time, and right about the time we really need a post revision, the plugin has gone and done its job and deleted them all. Same goes for trash. I might have put something in there, and when I realise I shouldn’t have, again, the plugin goes and deletes it. But expired transients and spam can go weekly on auto pilot.

Thank you for the update, @sean-h.

This feature is already in development, but I cannot provide you with an ETA when we will release it.

As soon as we make it available to the public, we will include information in the changelog:
https://www.ads-software.com/plugins/sg-cachepress/#developers

Best regards,
Tsvetan Mitev