14 Jan
2010
14 Jan
'10
1:50 p.m.
On Thu, Jan 14, 2010 at 13:29, Thomas Mortagne
<thomas.mortagne(a)xwiki.com> wrote:
On Thu, Jan 14, 2010 at 13:16, Mathias Herberts
<Mathias.Herberts+xwiki-users(a)gmail.com> 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.