0

One of my database is realy heavy (+100Mo) for a site with not so many content (like 40 pages & 10 posts)). I found in phpmyadmin that my table "postmeta" is 95Mo. So i wonder to know what are the data that takes so many place... !

i run a DB optimizer plugin (Advanced Database Cleaner) that help me go down to 92Mo, for only 2261 rows in table. ( Before, whas much more but i don't remember the number of lines ).

usualy my WP postmeta table is 2 to 5 mo for 4k rows...

I thinks this is linked to my theme, but i have no idea how to know wich data is so heavy. So how can i know wich are the heavy lines in my database ?

in text export, the more biggest rows is like this : (maybe it can help ?) https://pastebin.com/DMRQw3mD

Improve this question
5
  • You're going to have to look inside that table and figure out what the biggest post meta key/value pairs are. That would be a MySQL dev ops question. It may be that it's just how your site works with the various plugins it has. Eitherway there's very little that people can advise without direct access to the table, or, information about its contents beyond the size of the table as a whole
    – Tom J Nowell ♦
    Commented Oct 17, 2019 at 22:43
  • 1
    Also, can you clarify what you mean by 4k lines? I assume by Mo you mean Mb? How many rows are in the table? What's the most common meta keys?
    – Tom J Nowell ♦
    Commented Oct 17, 2019 at 22:45
  • 4k lines is 4k rows. Sorry for m'y english !
    – Gregory
    Commented Oct 18, 2019 at 7:24
  • Would you like an export of the table ?
    – Gregory
    Commented Oct 18, 2019 at 7:25
  • That might be a data breach if you shared that publicly
    – Tom J Nowell ♦
    Commented Oct 18, 2019 at 11:46

1 Answer 1

Reset to default
1

Many of the Page builder plugins records page/post specific data in the meta data of the Post/Page which is saved in wp_postmeta table. Similarly, you are using Elementor Pro plugin which is saving post configuration data there.

IMO, You should not be worried about this data otherwise you can contact plugin author to optimize it.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.