Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
Good Day
I have very big table cache_similarterms (1-3GB)
Cache Options: 1h
But cache (IMHO) not cleaned
Comments
Comment #1
rmiddle CreditAttribution: rmiddle commentedI am going to assume you are using the latest version 6.x-1.18 since 6.x-1.9 didn't have the cache.
Are you running the cron process? At least every hour at a minimum. Preferable more frequently I run mine ever 5 min. The cache table should be getting cleared by the standard Drupal purge process. Based on how I understand the code it will be 1 hour Plus 1 seconds after the 1st person views the page that gets cached.
I just checked my DB. I use 1 Day caching and my DB is at 6.6 Megs. Things that will help reduce the size of the DB. 1) Increase the frequency of the cron process that will purge them faster once they expire. 2) Decrease the time the cache sits arounds. 3) Under settings there is a option that will expire the entire cache.
Thanks
Robert
Comment #2
rmiddle CreditAttribution: rmiddle commentedNo updates in over a year closing this issue.
Thanks
Robert
Comment #3
rmiddle CreditAttribution: rmiddle commentedComment #4
rmiddle CreditAttribution: rmiddle commented