Huge table oc_filecache

ℹ️ Support
1

I have a huge amount of data in my oc_filecache table. Data_length is 169541632 and data_free is 7340032.

Is it correct, that data_free is unused “fragmented” space? How to get rid of this?

Is it save to truncate this table?

Thanks in advance
Michael

2

I’m not 100% sure, but I had my database locked to readonly from my hosting since it became too large due to the filecache tabel. I truncated it, since in the end it’s just a caching table. It seems harmless, as far as I can tell, and frankly that could handled via cron in my opinion, to keep it slim!

Hope this works (or worked) for you too!
ciao!