Rob Blake wrote: > It isn't really Magnolia's problem per-se, more of an issue with Jackrabbit's > implementation of PersistenceManager. When this executes the scripts to > create the tables it requires, it does not specify an engine to use, > therefore relying on the default engine set in your MySQL configuration. It > most cases the default is to use the MyISAM engine. > > Unfortunately I don't believe there is currently a configuration option for > the Jackrabbit PersistenceManager to instruct it to use the INNODB engine. > There is a JIRA issue open against Jackrabbit to support this functionality > (https://issues.apache.org/jira/browse/JCR-1435). So you have a couple of > options to get INNODB tables: > > • When you create the database for Magnolia, specify the INNODB engine > • Switch your MySQL configuration to use the INNODB engine by default.
It's also possible to change the storage engine used for a table using an ALTER TABLE statement. With MySQL 5.5 the default storage engine has been changed from MyISAM to InnoDB. Nils. ------------------------------------------------------------------------ VPRO www.vpro.nl ------------------------------------------------------------------------ ---------------------------------------------------------------- For list details, see http://www.magnolia-cms.com/community/mailing-lists.html Alternatively, use our forums: http://forum.magnolia-cms.com/ To unsubscribe, E-mail to: <[email protected]> ----------------------------------------------------------------
