Detected 137k Orphaned post meta, but didn’t clear them?

  • Resolved oxfordebooks

    (@oxfordebooks)


    3 years, 8 months ago

    This looks like it could be a really handy plugin for us.
    I tried it on a known problematic site which has a bloated WP DB of about 198mb.

    the plugin detected 137,000 or so orphaned product meta entries, so I ran the cleanup and it says it removed ZERO. But now the orphan count is zero and no improvement in the DB size.

    What’s happened here? Did it find the parent records, or am I now stuck with a bloated database. the wp_postmeta is about 169MiB, so worth clearing.

    btw: It’s a WP sit with WooCommerce and about 5000 products, but I stil think 194mb is large even for that.

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

  • @oxfordebooks Can you please to check all the optimizations and then click Run all selected optimizations form WP-Optimize > Database > Optimizations and check if it clears the orphaned product entries?

    Thread Starter oxfordebooks

    (@oxfordebooks)

    Thanks for the suggestion Harshad. I ran all the optimisations but no difference.
    When I ran it the firt time, as mentioned above, it had 137k orphans, after running the number was zero but it didn’t remove any and the DB size was the same.

    Was it supposed to remove the orphans or attempt to re-link them? In the latter case, I appreciate that the DB size won’t have changed.

    I’m worried that there’s potentilly no way to remove the “hidden orphans” now :/

    @oxfordebooks Sorry for the delay!

    I’ve ran some tests on my side and it looks like at the moment it doesn’t remove hidden orphan records.

    I’ll share this with our development team, so that it can be fixed in future release.

    Thread Starter oxfordebooks

    (@oxfordebooks)

    Harshad,
    Thanks, that’s awesome. The DB on that site is pretty bloated! Looking forward to seeing the update.

    Cheers,

    Andy

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Detected 137k Orphaned post meta, but didn’t clear them?’ is closed to new replies.