28 Sep
2016
28 Sep
'16
4:33 p.m.
Hi Vincent,
Regarding DB indexing I would like to tell you that I already created below indexes as per
the page http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Database+Administration to
deal with performance but could not get any benefit. Sice we are having 4.2 version at
production, we created below mentioned indexes in our MySQL DB.
Indexes for XWiki Enterprise versions after 3.2
create index xwl_value on xwikilargestrings (xwl_value(50));
create index xwd_parent on xwikidoc (xwd_parent(50));
create index xwd_class_xml on xwikidoc (xwd_class_xml(20));
create index xws_number on xwikistatsdoc (XWS_NUMBER);
create index xws_classname on xwikistatsdoc (XWS_CLASSNAME);
create index xwr_number on xwikistatsreferer (XWR_NUMBER);
create index xwr_classname on xwikistatsreferer (XWR_CLASSNAME);
create index xwr_referer on xwikistatsreferer (XWR_REFERER(50));
create index xwv_user_agent on xwikistatsvisit (XWV_USER_AGENT(255));
create index xwv_cookie on xwikistatsvisit (XWV_COOKIE(255));
create index xwv_classname on xwikistatsvisit (XWV_CLASSNAME);
create index xwv_number on xwikistatsvisit (XWV_NUMBER);
create index ase_requestid on activitystream_events (ase_requestid(200));
create index ase_page_date on activitystream_events (ase_page, ase_date);
create index xda_docid1 on xwikiattrecyclebin (xda_docid);
create index ase_param1 on activitystream_events (ase_param1(200));
create index ase_param2 on activitystream_events (ase_param2(200));
create index ase_param3 on activitystream_events (ase_param3(200));
create index ase_param4 on activitystream_events (ase_param4(200));
create index ase_param5 on activitystream_events (ase_param5(200));
Thanks & Regards,
Piyush
-----Original Message-----
From: users [mailto:users-bounces@xwiki.org] On Behalf Of Vincent Massol
Sent: Friday, September 23, 2016 6:33 PM
To: XWiki Users
Subject: Re: [xwiki-users] I would like to migrate my xwiki application from 4.2 to
8.2.1
On 23 Sep 2016, at 14:49, Kumar, Piyush
<piyush.kumar(a)atos.net> wrote:
Hi All,
I am currently using XWiki 4.2 war deployed on apache-tomcat and also using MySQL DB. I
am using XWiki clustered 2 based on network events distribution. I am also using A
multi-tenant setup ( "virtual mode", "multi-wiki" or "farm
mode") which allows us to have several wikis running on the same XWiki instance (i.e.
in the same JVM). I also configured Scheduled jobs to empty trash and getting it triggered
via cron expression.
I am facing serious performance issue as Xwiki application has become very slow and
frequently results in timeout.
To resolve the performance issue I would like to migrate my XWiki application from
version 4.2 to 8.2.1.
Is it a good decision?
It is. Actually what you’ve done (stay very long on a very old version is not such a good
idea ;) (will make the upgrade a lot more complex).
Since you’re using a very old version you may want to export your data, install XWiki
8.2.1 and import your data. However see the limitations at
http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Backup#HUsingtheXWikiEx…
If now which version can be relatively cater more
performance? Also if anyone can share the high level steps which must be followed while
migration, would be great help.
Re performance you can get good perf in 4.2 too. If I had to guess I’d say you’re missing
indexes in the DB, see http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Performances
Thanks
-Vincent
PS: Since this is a complex operation, I’d highly suggest that you hire some xwiki
experts. There are companies offering such expertise and that are sponsoring the
development of the xwiki project. See
http://www.xwiki.org/xwiki/bin/view/Main/Support#HProfessionalSupport
Thanks & Regards,
Piyush
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users