[TYPO3] oversized cache tables

[Benjamin Todd]

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
 
b.todd at emnet.co.uk
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: typo3-english-bounces at lists.netfielders.de
[mailto:typo3-english-bounces at lists.netfielders.de] On Behalf Of Michael
Stucki
Sent: 01 April 2008 02:52 PM
To: typo3-english at 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 at lists.netfielders.de
http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english

Scanned for viruses by MailDefender