7 Dec
2010
7 Dec
'10
9:55 a.m.
On 7 December 2010 16:53, Paul Harris <harris.pc(a)gmail.com> wrote:
On 6 December 2010 20:02, Ricardo Rodriguez [eBioTIC.] <
ricardo.rodriguez(a)ebiotic.net> wrote:
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 also checked a database created by trac, the issue-tracking webserver, and
it correctly created innodb tables without me doing anything at all...
Caleb James DeLisle wrote:
snip
On 11/30/2010 05:46 PM, Ricardo Rodriguez
[eBioTIC.] wrote:
> Piotr Dziubecki 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 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?
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