Jump to content

layered_filter_block table taking up 1 GB space


joaoafpedro
 Share

Recommended Posts

 Good afternoon,

Today I noticed that my website has became pretty much irresponsive. I'm unable to make any changes or install new blocks as my host pretty much denies any new MySQL queries due to the fact that the store database as exceed the allowed sizer of 1024MB (1 GB). I thought it was weird as I had recently used a module to clean the database unused data and so I decided to run the follow sql query to try to understand which tables were taking up most of the space:

SELECT TABLE_NAME AS `Table`, ROUND((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024) AS `Size (MB)` FROM information_schema.TABLES WHERE TABLE_SCHEMA = "MyDatabaseName" ORDER BY (DATA_LENGTH + INDEX_LENGTH) DESC;

After running this query I noticed something off. The table named after layered_filter_block seems to be taking up 1025 MB of space, filling up all the allowed space by my host.

Therefore, I'd like to know what this table is used for and if it's safe for me to truncate its values.

 

Thank you in advance and best regards

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More