600Mo wp_postmeta table

  • Resolved maximed

    (@maximed)


    4 years, 9 months ago

    Hi,

    I have a ecommerce marketplace, with approx 10k products registered.
    My postmeta table has gone wild since few weeks, and despite many commands and plugins to delete orphans and transcients (and optimize the database in general), the _postmeta table is the only one not decreasing. It remains between 500Mo-600Mo and it causes me lots of problems…

    Do you have any recommendations?

    Best,

    Maxime

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Support con

    (@conschneider)

    Engineer

    Hi there,

    the _postmeta table is the only one not decreasing. It remains between 500Mo-600Mo and it causes me lots of problems…

    Do you have any recommendations?

    With 10k products 500MB in the post_meta could be appropriate. Is there any data in there that is out of place?

    Kind regards,

    Thread Starter maximed

    (@maximed)

    Thanks for your fast reply!

    As my wp_posts table is a bit less than 50Mo, I thought a _postmeta of this size was not so appropriate.
    It seems that unused data is not deleted / spotted by plugins.

    Plugin Support con

    (@conschneider)

    Engineer

    Howdy,

    Thanks for your fast reply!

    You got it.

    As my wp_posts table is a bit less than 50Mo, I thought a _postmeta of this size was not so appropriate.
    It seems that unused data is not deleted / spotted by plugins.

    That could very well be the case. Do you have some example of unused data maybe?
    Also I take it CRON is working ok?

    Kind regards,

    Plugin Support con

    (@conschneider)

    Engineer

    Hi there,

    We haven’t heard back from you in a while, so I’m going to mark this as resolved – if you have any further questions, you can start a new thread.

    Kind regards,

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘600Mo wp_postmeta table’ is closed to new replies.