Post meta cleanup with very large database

  • Resolved gingrr

    (@gingrr)


    8 months, 3 weeks ago

    Hi, I have ~17,500 posts with a post meta table that is around 3gb, that is loaded with bloat from ACF / a data import plugin that was adding a lot (A LOT) of duplicate entries. I suspect I have millions of duplicate entries. Is this something your post meta cleaner can handle? I saw you have the create indexes button to help speed up the queries for this, but I am afraid of the scale of my issue and that this might bring my server to a crawl. I do have a very premium server via WPEngine that runs ~$2k/mo (thats about all I can say because they don’t provide specs) but I am still not sure about this.

    As an aside, I am looking into how I can export the posts without the duplicate data, and then reimport them into a clean install.

Viewing 1 replies (of 1 total)
  • Plugin Support Val Meow

    (@valwa)

    Hey @gingrr! ??

    The plugin should be able to handle a large amount of data as long as your database/server can handle numerous requests. However, considering the size of your post meta table, it’s recommended to proceed with caution. Always make a backup before starting the cleanup process. It’s also good practice to proceed in batches instead of doing everything at once. Thanks!

Viewing 1 replies (of 1 total)
  • The topic ‘Post meta cleanup with very large database’ is closed to new replies.