On Thu, Jan 14, 2010 at 13:16, Mathias Herberts <mathias.herberts+xwiki-us...@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. > > Won't the use of MyISAM prove troublesome if lots of attachments are > added to the Wiki? MyISAM uses a single file for all data in a table, > and thus all attachements being stored in the same table, this MyISAM > file might grow huge, which is usually not something suitable. > > Any past experience with attachement heavy Wiki instances using MySQL > for storage? Any plan of using InnoDB in the near future?
XWiki does not choose any specific MySQL engine AFAIK. it just ask for a table to the server and the server choose he default one. Or maybe hibernate generate initialization script with MyISAM explicitly but it would be weird. Maybe you can choose the MySQL engine in the hibernate configuration file to make sure it's using InnoDB. > > Thanks, > > Mathias. > _______________________________________________ > users mailing list > users@xwiki.org > http://lists.xwiki.org/mailman/listinfo/users > -- Thomas Mortagne _______________________________________________ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
