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. Hope that helps, Rob On Fri, Apr 27, 2012 at 10:13 AM, Daniele Benedetti (via Magnolia Forums) < [email protected]> wrote: > Reading Magnolia Documentation, i found this phrase:"If you use MySQL, > choose the InnoDB storage engine. MyISAM engine is not supported by > Magnolia." > > Why, when Magnolia starts and MySQL data store is configured, tables are > created with MyISAM engine? > Is there a way to make magnolia create tables with InnoDB option? > > tks all, > > daniele > > -- > Context is everything: > http://forum.magnolia-cms.com/forum/thread.html?threadId=b0d8e1b7-47d5-4d42-a6c8-fd3b3b29bd37 > > > ---------------------------------------------------------------- > 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]> > ---------------------------------------------------------------- > > -- Rob Blake Co-Founder *The Law Wizard Limited* *www.thelawwizard.com* <http://www.thelawwizard.com/> Twitter <http://www.twitter.com/thelawwizard> | Facebook<http://www.facebook.com/thelawwizard> | YouTube <http://www.youtube.com/thelawwizard> | LinkedIn<http://.www.linkedin.com/company/the-law-wizard-limited> | our Blog <http://www.blog.thelawwizard.com/> *The Ron Cooke Hub, York Science Park, York, YO10 5GE* Making law simple and accessible ---------------------------------------------------------------- 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]> ----------------------------------------------------------------
