[TYPO3] oversized cache tables

Michael Stucki michael at typo3.org
Tue Apr 1 15:51:56 CEST 2008


Hi Frank,

> I have some tables in my database that are growing too much, specifically
> cache tables. What is the best practice for this? Can I just empty them
> every now and then?
> 
> cache_extensions      11.878          MyISAM          4,7 MB
> cache_hash            1.188           MyISAM          26,2 MB
> cache_imagesizes      30.426          MyISAM          5,3 MB
> cache_md5params       3.019.606       MyISAM          423,8 MB
> cache_pages           1.317           MyISAM          36,4 MB
> cache_pagesection     205             MyISAM          1,1 MB
> cache_sys_dmail_stat  46.640          MyISAM          4,8 MB
> cache_typo3temp_log   0

The table cache_md5params which seems to be the reason for your question is
only used to store redirect URLs (&RDCT=...).

So maybe you are using a newsletter with a huge number of different
(personalized?) URLs inside?

You can decide for yourself if you want to drop using this feature, as it
can be configured. Of course long URLs look ugly sometimes, but there is
also RealUrl to work around this...

- michael
-- 
Use a newsreader! Check out
http://typo3.org/community/mailing-lists/use-a-news-reader/


More information about the TYPO3-english mailing list