[TYPO3-english] tx_comments and caching of tt_news

Dmitry Martynenko dima at realt.by
Tue Jan 20 11:18:21 CET 2009


Hi Dmitry,

>> Comments extension clear cache for one page with all single news,
>> which contains many news cached. And this operation
>> takes very long time - delete many records from table of 1.5 Gb size.
>> While MySQL does this very slow operation - it is going to be slow for
>> other requests. They have accumulated and quickly eat away all possible MySQL
>> connections. Site stops respoding at all.

DD> I think you use MyISAM for cache tables. Tables will be locked in
DD> this case and you will see site lock up.

Yes. We haven't upgraded to TYPO3 4.2 yet.

But on russian TYPO3 forum some users write they have troubles with
innodb for cache tables. It is dangerous to do such upgrades on
production server when site must work 24 hours per day.

-- 
Dmitry Martynenko
Developer

Web: http://realt.by



More information about the TYPO3-english mailing list