4.6.9 core_output_cache too big

[BenHur]

Hello team,

The table become too big (>7 G with 535 000 rows).
My provider have a limit for the SQL (8 Go) so is it a setting in order to limit the cache to the last 5000 posts for example ?

Thanks again,

Benjamin

Mysql : v5.7.36-log

 

[Marc]

output cache will indeed cache the site as a whole. This said however, background tasks arent running on your site, as stated by the banner there. You need to address that, as it may be that items are not being correctly cleared. You may need to switch to cron to run these, which would be our recommendation

Having a limitation on mysql is very much only done on cheap hosting though. To be honest, you should find hosting where mysql is not limited in that manner. 8gb is not a large size for databases on sites these days. Have you considered a cloud hosted environment, then you dont need to think about your hosting at all?

[BenHur]

Thanks Mark for your answer. I will look to the cron.

We have 1,1 million messages so if the top 10% could be cached it could be better maybe 😉

 

I upgraded to 16 Gb so we will see.

With 1,1 messages, is it possible to have a idea of the size of the db should be ?

[Jim M]

7 minutes ago, BenHur said:

With 1,1 messages, is it possible to have a idea of the size of the db should be ?

I'm afraid, there is no estimate we can provide as every community is different.