Summary

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

Details

Page properties

Author

...	...	@@ -1,1 +1,1 @@
1		-XWiki.ThomasMortagne
	1	+XWiki.VincentMassol

Content

...	...	@@ -64,6 +64,48 @@
64	64	{{/info}}
65	65	)))
66	66
	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	+
67	67	= Tips =
68	68
69	69	== Convert a database from latin1 (or collation utf8_ci) to utf8mb4/utf8mb4_bin ==