WordPress Database and cleaning out old data

Robert Granlund
Robert Granlund used Ask the Experts™
WordPress / WooCommerce Database is huge.  I'm helping with a store that over the years the database tables have become huge.  Literally millions of table entries.  Is there any way to get rid of data that is no longer needed in the postmeta table?  Is there old information that no longer needs to be stored?

I was told I can use the following in MyPHPadmin:
SELECT * FROM wp_postmeta pm LEFT JOIN wp_posts wp ON wp.ID = pm.post_id WHERE wp.ID IS NULL;
DELETE pm FROM wp_postmeta pm LEFT JOIN wp_posts wp ON wp.ID = pm.post_id WHERE wp.ID IS NULL;

Open in new window

But if I do that, will I loos anything from my WooCommerce Store?
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2016

Is your site broken? If not why are you trying to fix something that is not broken. Unless you are absolutely 100% sure then don't change things just because you think something is wrong.
I wouldn't worry about the woocommerce database but for the Wordpress database there are several optimizations https://www.shoutmeloud.com/reduce-wordpress-database-size.html
Fractional CTO
Distinguished Expert 2018
As David suggested, if it ain't broke, don't fix it.

Woo tends to only generate data Woo requires.

Before you delete any data, best only do it through Woo, rather than raw database commands or run your approach by Woo support via a support ticket.

In general, if you muck about with Woo data (which is complex), you can end up with all manner of orphan data in your database.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial