[TYPO3] oversized cache tables

[Dmitry Dulepov [typo3]]

Hi!

Frank Sonck wrote:
> You are right Dmitry, large is a relative concept. But still, fact is 
> that we have been experiencing performance problems (apache server load) 
> lately with 'only' some 3.000 news articles, 1500 pages and some 5 to 
> 6.000 visitors per day.
> So if there are basic things one can do to optimize TYPO3 setup 
> (database, server,...) then I would guess this is always interesting. The 
> information for this topic seems rather scattered.
> I read for example a thread in (English?) newsgroup about nightly 
> emptying of cache tables with cron but not really confirmation about it.

Try earching for my presentations about TYPO3 performance from t3dd07. It has useful tips. One thing you can do immediately, is to check whether cache tables use InnoDb. If they are MyISAM, they will be slower. Also analyze/optimize table may help.

You need also to disable sys_stat if you need good performance.

-- 
Dmitry Dulepov
TYPO3 core team
Web: http://typo3bloke.net/
Skype: callto:liels_bugs
"Nothing is impossible. There are only limits to our knowledge"