Wp_options table and wp_options.ibd too large

Keywords: WordPress - AWS - Technical issue - Other
bnsupport ID: f98d0ebd-cc5f-3681-d783-dc7cbc9988b1
Description:
My disk is full and this table/file is taking 18 GB + of space. I am unable to figure out why this would be. I have run the bn support tool.

On running SELECT option_name, LENGTH(option_id) + LENGTH(option_name) + LENGTH(option_value) + LENGTH(autoload) AS total_length FROM wp_options ORDER BY total_length DESC LIMIT 10
this is what I get.

Hi @shekharsmn90,

Could you please take a look at this other post?

You probably have a plugin in WordPress that is saving that amount of information in the database.

Thanks

Found the problem. Too many revisions of too many pages being stored. Fixed it. Thanks.

1 Like

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.