[TYPO3] innoDB-tables in typo3

[Dmitry Dulepov [typo3]]

Hi!

Peter Falk wrote:
> Some of the database tables in typo3 (from v. 4.1) is created as innoDB 
> (syslog, fe_session a.m.). Is this a must or is it possible to change 
> the tables to MyISAM?

It is not a requirement but there are reasons for this:
- MyISAM locks the whole table for read and write when someone tries to write there. So if you have 100 clients and one of them writes data, other 99 wait. InnoDb allows reads while writes and returns only valid data. While it is not very important for syslog, it is very important for performance with cache_*, index_* and fe_* tables
- When there are a lot of concurent writes, MyISAM tables may crash. You will never know that until you find that site works slow. Then you will find that one of cache_* failed and nothing is cached. With InnoDb carshes usually do not appear.

So feel free to change those tables to MyISAM locally of you want. But better keep them InnoDb.

-- 
Dmitry Dulepov
TYPO3 freelancer / TYPO3 core team member
Web: http://typo3bloke.net/
Skype: callto:liels_bugs