14 Jan
2010
14 Jan
'10
1:29 p.m.
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.
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(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
--
Thomas Mortagne