layered_filter_block table taking up 1 GB space

[joaoafpedro]

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

**EDIT:** POSTED IN ANOTHER SECTION. Please delete

Edited August 13, 2020 by joaoafpedro (see edit history)

[hitmsbkk]

Hi, I got 4.4gb for layered_filter_block too. You may try to go module manager>faceted search and clear cache if can solve your problem.

 

Best regards.