[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