[TYPO3-dev] TYPO3 4.1 INNODB

Dmitry Dulepov 9f4eetb02 at sneakemail.com
Fri Mar 2 10:05:09 CET 2007


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!

-- 
Dmitry Dulepov

Web: http://typo3bloke.net/
Skype: callto:liels_bugs

"It is our choices, that show what we truly are,
far more than our abilities." (A.P.W.B.D.)




More information about the TYPO3-dev mailing list