Wordpress mulitsite post table large

Hi

I do this to check the sizes of the tables in my wordpress mulitsite install

SELECT TABLE_NAME AS "Table Name",
table_rows AS "Quant of Rows", ROUND( (
data_length + index_length
) /1024, 2 ) AS "Total Size Kb"
FROM information_schema.TABLES
WHERE information_schema.TABLES.table_schema = 'database_name'

I did this to check why my database backup is getting larger quickly.

I get that wp_41_posts is 23396 Kb as you can see in the attached image and this is on only 383 rows.
I cant see any extreamly large texts in these rows

There is some images but the images is not stored in the database is it?

Any ideas why this table is so large in Kb?

Kind regards Hubbe

  • Predrag Dubajic
    • Support

    Hey Hubbe,

    Hope you're doing well today :slight_smile:

    Images are not stored in wp_posts table so there's something else taking up your space here.

    Do you have any theme or plugin options that are adding lot of custom meta to your posts or pages that could be causing this?

    Best regards,
    Predrag

  • Hubbe
    • The Incredible Code Injector

    Hi

    I did a loop of the database content in php and there was nothing large, finaly I did a check and repair of the table and then i went down to under 1 Mb. solved.

    another thing is wpmudev:s panino upfront theme that is filling upp the wp_posts as you can see in the attached image

    There are only two posts in the admin area of the site but if I look in the phpmyadmin of the table it is a lot of stuff there

    Is this normal?

    Kind regards Hubbe

Thank NAME, for their help.

Let NAME know exactly why they deserved these points.

Gift a custom amount of points.