BenHur Posted January 23, 2022 Share Posted January 23, 2022 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  Link to comment Share on other sites More sharing options...
Marc Stridgen Posted January 24, 2022 Share Posted January 24, 2022 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? SeNioR- 1 Link to comment Share on other sites More sharing options...
BenHur Posted January 28, 2022 Author Share Posted January 28, 2022 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 ? Link to comment Share on other sites More sharing options...
Jim M Posted January 28, 2022 Share Posted January 28, 2022 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. Link to comment Share on other sites More sharing options...
Recommended Posts