Re: I need to set a cache table limit

--- on Monday 26 July 2004 18:17, Michael Lessard wrote --
> Hello,
>
> My cache table can climb up to over 20 Mo (and does down to about 4
> Mo when I optimize my tables) and so my host makes me pay a fee for
> going above my allowed limit.
>
> Is there a trick to automatically limit the cache table ?
Automaticcaly I would not know, for I am no DB guru. There might be some mysql 
specific way to limit the use of  a table, but i would suggest that the nbest 
place for finding out about this is on a mysql list.

However, If you are not afraid of some coding, you could try to make a small 
module with a small cron hook that will check the size of the cache table and 
if that exceeds a certain limit, flush the cache.

More info about the cron hook 
here:http://drupal.org/doxygen/drupal/group__hooks.html#ga9
More info about flushing drupals cache here: 
http://drupal.org/doxygen/drupal/bootstrap_8inc.html#a9

-- 
Regards,
Bèr Kessels
--
[ Drupal support list | http://list.drupal.org/ ]