[TYPO3-english] tx_comments and caching of tt_news

[Dmitry Dulepov]

Hi!

Dmitry Martynenko wrote:
> 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.

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

-- 
Dmitry Dulepov
TYPO3 core team
"Sometimes they go bad. No one knows why" (Cameron, TSCC, "Dungeons&Dragons")