[TYPO3] innoDB-tables in typo3

Ignatius Reilly ignatius.reilly at free.fr
Tue Sep 18 12:23:11 CEST 2007


Thanks Dmitry. Excellent tip, as always.

Just to mention that as of MySQL 5.0 the default storage engine remains 
MyISAM.

Dmitry Dulepov [typo3] thus spake on 2007-09-18 12:08:
> Hi!
> 
> Ignatius Reilly wrote:
>> Is it proof-tested to have _all_ tables of InnoDB type (core + ext)?
> 
> I use InnoDb for all tables. Generally InnoDb is slower if you need only to read, so it is worth to have pages and tt_content as MyISAM. But if tt_content or pages is really big, it is better to have them as InnoDb because InnoDb is more stable than MyISAM.
> 
>> I suppose that would be the effect of a new install with MySQL directive
>> [mysqld]
>> default-storage-engine=innodb
> 
> As far as I know InnoDb is default table type since mysql 4.0.
> 


More information about the TYPO3-english mailing list