Huge postmeta table

  • viche

    (@viche)


    8 years, 7 months ago

    Hi!

    Any Idea why postmeta table is huge (and what to do about it)? It is over 100mb.

    Except some static pages the only content is the products.

    Please advice.

    Thanks in advance.

    Best regards, Niclas

    The page I need help with: [log in to see the link]

Viewing 3 replies - 1 through 3 (of 3 total)
  • Peter Lawrenson

    (@lorro)

    8 years, 7 months ago

    Did you try:
    Dashboard > WooCommerce > Status > Tools tab, then click the two delete transients buttons and the delete orphaned variations button.

    Also, try this database utility: (always been good for me but back-up before using)
    https://wordpress.org/plugins/wp-optimize/

    Thread Starter viche

    (@viche)

    8 years, 7 months ago

    Thanks @lorro

    Your first idea only removed a couple of thousand. Still 1 338 055 records (116,7 MB) according to wp optimize after I run it..

    Do I have to do some extra settings/choices?

    Thanks!

    //niclas

    Optimization Notes
    Optimize database tables Tables using the InnoDB engine (46) will not be optimized. Other tables will be optimized (0). Run optimization
    Clean all post revisions No post revisions found Run optimization
    Clean all auto-drafts and trashed posts No auto draft posts found
    No trashed posts found Run optimization
    Remove spam and trashed comments No spam comments found
    No trashed comments found Run optimization
    Remove unapproved comments No unapproved comments found Run optimization
    Remove expired transient options 4 expired transient in your database Run optimization
    Remove pingbacks No pingbacks found Run optimization
    Remove trackbacks No trackbacks found Run optimization
    Clean post meta data 98 orphaned postmeta in your database Run optimization
    Clean comment meta data No orphaned comment meta data in your database Run optimization
    Clean orphaned relationship data No orphaned relationship data in your database

    Thread Starter viche

    (@viche)

    8 years, 7 months ago

    I’m using Advanced woo search for search and after I reindexed the record is now 1 624 382.

    Is it safe to drop the table? 🙂

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Huge postmeta table’ is closed to new replies.