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"
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