A
A
Alexey Romanov2017-09-11 03:28:52
MySQL
Alexey Romanov, 2017-09-11 03:28:52

Why might the wp_posts table size be large?

Greetings.
Connoisseurs, please tell me why the wp_posts table can take 19 gigs?
Revisions and everything else is disabled and cleaned up.
Is there any way to find out what exactly takes up so much space.
The site is not big, 1200 comments, and only 277 posts. outputs 946790 entries.
SELECT COUNT(1) FROM `wp_posts`

Answer the question

In order to leave comments, you need to log in

1 answer(s)
E
Exploding, 2017-09-11
@romalex

I don’t know for sure, because I’ve never dealt with WP, but I think that base64 images were stuffed into the database.
Try it like this:
SELECT * FROM `wp_posts` WHERE LENGTH(`field_with_content`) > 50000 e.g.
It turns out that each post has an average of ~ 20k characters ... Too much ...

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question