Hi Michael, When we had oversized cache problems we found it was the 'cal' calendar extension - search engine spiders were crawling every single date filling up the table.
HTH, Ben ------------------------ Benjamin Todd Web Developer [EMAIL PROTECTED] EMNET, PO Box 559, Nottingham, NG1 3LB Tel: +44 (0)115 956 8260 Fax: +44 (0)115 956 8264 www.emnet.co.uk Company Registration No. 3144383 - VAT No. 694 620 609 - Registered Office: Church House, 13-15 Regent Street, Nottingham NG1 5BS www.emnetsolutions.co.uk Company Registration No. 05384178 - VAT No. 856 671 781 - Registered office: Church House, 13-15 Regent Street, Nottingham, NG1 5BS -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Michael Stucki Sent: 01 April 2008 02:52 PM To: typo3-english@lists.netfielders.de Subject: Re: [TYPO3] oversized cache tables 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/ _______________________________________________ TYPO3-english mailing list TYPO3-english@lists.netfielders.de http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english Scanned for viruses by MailDefender _______________________________________________ TYPO3-english mailing list TYPO3-english@lists.netfielders.de http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english
