<
From version < 54.1 >
edited by Thomas Mortagne
on 2020/03/11
To version < 56.1 >
edited by Guillaume Delhumeau
on 2020/04/16
>
Change comment: There is no comment for this version

Summary

Details

Page properties
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.ThomasMortagne
1 +XWiki.gdelhumeau
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 ==
... ... @@ -90,6 +90,8 @@
90 90  $mysql_cmd -e "USE $db;SELECT TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, COLLATION_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA=DATABASE();"
91 91  {{/code}}
92 92  
135 +You can also look at a[[snippet to perform this conversion inside XWiki>>snippets:Extension.Migrate MySQL databases to utf8mb4]].
136 +
93 93  == Convert from MyISAM to InnoDB ==
94 94  
95 95  {{code}}

Get Connected