<
From version < 53.1 >
edited by Thomas Mortagne
on 2020/02/11
To version < 55.1 >
edited by Vincent Massol
on 2020/04/05
>
Change comment: There is no comment for this version

Summary

Details

Page properties
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.ThomasMortagne
1 +XWiki.VincentMassol
Content
... ... @@ -4,10 +4,6 @@
4 4  
5 5  = Compatibility Considerations =
6 6  
7 -{{error}}
8 -Currently we seem to have some [[problem with MySQL server 8.x or MySQL connector 8.x>>https://jira.xwiki.org/browse/XWIKI-15215]]. It is recommended to use MySQL server 5.7.x or earlier (and connector 5.1.x) if you're using XWiki 10.x (the issue is fixed if you're on XWiki 11.3+).
9 -{{/error}}
10 -
11 11  See [[Database support strategy>>dev:Community.DatabaseSupportStrategy]] for the supported versions.
12 12  
13 13  == MyISAM storage engine ==
... ... @@ -68,6 +68,48 @@
68 68  {{/info}}
69 69  )))
70 70  
67 += Indexes =
68 +
69 +See [[Database Administration>>Documentation.AdminGuide.Performances.Database Administration.WebHome]].
70 +
71 +{{code}}
72 +// Required
73 +create index xwl_value on xwikilargestrings (xwl_value(50));
74 +create index xwd_parent on xwikidoc (xwd_parent(50));
75 +create index xwd_class_xml on xwikidoc (xwd_class_xml(20));
76 +create index ase_page_date on activitystream_events (ase_page, ase_date);
77 +create index xda_docid1 on xwikiattrecyclebin (xda_docid);
78 +create index ase_param1 on activitystream_events (ase_param1(200));
79 +create index ase_param2 on activitystream_events (ase_param2(200));
80 +create index ase_param3 on activitystream_events (ase_param3(200));
81 +create index ase_param4 on activitystream_events (ase_param4(200));
82 +create index ase_param5 on activitystream_events (ase_param5(200));
83 +// Only required if you use stats (feature is off by default)
84 +create index xws_number on xwikistatsdoc (XWS_NUMBER);
85 +create index xws_classname on xwikistatsdoc (XWS_CLASSNAME);
86 +create index xwr_number on xwikistatsreferer (XWR_NUMBER);
87 +create index xwr_classname on xwikistatsreferer (XWR_CLASSNAME);
88 +create index xwr_referer on xwikistatsreferer (XWR_REFERER(50));
89 +create index xwv_user_agent on xwikistatsvisit (XWV_USER_AGENT(255));
90 +create index xwv_cookie on xwikistatsvisit (XWV_COOKIE(255));
91 +create index xwv_classname on xwikistatsvisit (XWV_CLASSNAME);
92 +create index xwv_number on xwikistatsvisit (XWV_NUMBER);
93 +{{/code}}
94 +
95 +{{info}}
96 +Note to XWiki developers: The following indexes could be created automatically though since they're less than 255 characters and thus should be added in a future version of XWiki so that they don't need to be created manually:
97 +
98 +{{code}}
99 +create index xws_number on xwikistatsdoc (XWS_NUMBER);
100 +create index xws_classname on xwikistatsdoc (XWS_CLASSNAME);
101 +create index xwr_number on xwikistatsreferer (XWR_NUMBER);
102 +create index xwr_classname on xwikistatsreferer (XWR_CLASSNAME);
103 +create index xwv_classname on xwikistatsvisit (XWV_CLASSNAME);
104 +create index xwv_number on xwikistatsvisit (XWV_NUMBER);
105 +create index xda_docid1 on xwikiattrecyclebin (xda_docid);
106 +{{/code}}
107 +{{/info}}
108 +
71 71  = Tips =
72 72  
73 73  == Convert a database from latin1 (or collation utf8_ci) to utf8mb4/utf8mb4_bin ==

Get Connected