On Thu, Jan 14, 2010 at 13:29, Thomas Mortagne <[email protected]> wrote:
On Thu, Jan 14, 2010 at 13:16, Mathias Herberts <[email protected]> wrote:
Hi,
I have an instance of XWiki Enterprise v2.1.1 deployed using a MySQL database. I've noticed that the engine used in MySQL is MyISAM and was wondering if there was a particular reason why InnoDB was not the engine of choice.
Ok, I checked Hibernate and found that by using dialect 'org.hibernate.dialect.MySQL5InnoDBDialect' you could switch to InnoDB tables. But now there seems to be a problem with at least one XWiki table, namely xwikicomments: create table xwikicomments (XWC_ID integer not null, XWC_AUTHOR varchar(255), XWC_HIGHLIGHT varchar(60000), XWC_COMMENT varchar(60000), XWP_REPLYTO integer, XWP_DATE datetime, primary key (XWC_ID)) ENGINE=InnoDB] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs cf http://dev.mysql.com/doc/refman/5.0/en/innodb-restrictions.html so this is not as trivial as expected :-( Mathias.