I am using LAMP Stack...And one of my db table wp_options (Rows: 10,600) is now about 194+ GB in size... Not sure why the size growing so much huge... As far as i am concern most of the records are texts.... but texts should not be that size... is there any blob file or something?? not familiar with that though... Please suggest anything to analyze what is taking up the space??

Table Rows

  • 1
    Please instead of downvoting... suggest me any solution or what is wrong with the question??? I am in trouble so please help Jan 22, 2020 at 18:05
  • possibly the solution to fix is same. wordpress.stackexchange.com/questions/346860/… Jan 23, 2020 at 7:01
  • You may want to also find out first which records take up the maximum space. Try SELECT *, LENGTH(fieldname) FROM wp_options ORDER BY LENGTH(fieldname) DESC Jan 23, 2020 at 7:02

1 Answer 1


Check the WP plugins. Some of them create thousands of "options" and fail to clean up after themselves.

Your Answer

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

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