7 Dec
2010
7 Dec
'10
9:53 a.m.
On 6 December 2010 20:02, Ricardo Rodriguez [eBioTIC.] <
ricardo.rodriguez(a)ebiotic.net> wrote:
Does
this add a reason to always use innodb as engine when running XWiki
with MySQL as database? Thanks!
In general, myisam should not be used in cases where the integrity of the data is
important. This is
Hi
I've used mysql for a while now, and my apps always specify the type of
table at the point of creation.
I just installed xwiki for the first time on a linux server with mysql, and
noticed that all the tables are MyISAM. If I didn't read this email
thread, I wouldn't have thought to check that, as I would have assumed xwiki
would've asked for innodb tables when it initialised the database.
So questions are:
* why doesn't xwiki automatically ask for innodb ?
* how am I supposed to convert the existing database to innodb ?
* how should new databases be created so that innodb tables are used ?
thanks
Paul
Caleb James DeLisle wrote:
snip
On 11/30/2010 05:46 PM, Ricardo Rodriguez
[eBioTIC.] wrote:
> Piotr Dziubecki wrote:
>
because myisam makes no effort to repair the
database if saving content
fails in the middle of the
operation.
Caleb
Thanks, Caleb.
I was not aware of this and always used MyISAM table that seem to be the
default take. Don't you think that at least a warning to new users to
consider if they prefer MyISAM or InnoDB databases? Perhaps here...
http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationMySQL
I understand that RDBMS details are not a XWiki matter, but it could be
it if the decision obviously affects XWiki security and performance.
WDYT?