[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