[TYPO3-dev] TYPO3 4.1 INNODB

[Martin Kutschker]

Dmitry Dulepov schrieb:
> Hi!
> 
> R. van Twisk wrote:
> 
>> I would also opt for myisam for indexed search and
>> using full-text index for mysql databases.
> 
> Basically it will decrease performance because those tables have 
> simultaneous writes/reads. When I looked into process list with myisam 
> indexed_search tables, there were many SELECTs in locked state waiting 
> for a number of UPDATEs. Remember: myisam locks the whole table even for 
> read when you write to it!

I think you can use Myisam and full text indices when you block the writes 
to the index tables. This means no live update after page changes, but 
updates by a scheduler (eg the crawler extensions) to reindex pages regularily.

Masi