-1

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

Improve this question
3
  • 1
    Please instead of downvoting... suggest me any solution or what is wrong with the question??? I am in trouble so please help
    – Sajjad Hossain Sagor
    Jan 22, 2020 at 18:05
  • possibly the solution to fix is same. wordpress.stackexchange.com/questions/346860/…
    – Rakesh Shewale
    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
    – Rakesh Shewale
    Jan 23, 2020 at 7:02

1 Answer 1

Reset to default
0

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

Improve this answer

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.