Summary

• Page properties (2 modified, 0 added, 0 removed)

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 ==