Changes for page Database Administration

Last modified by Vincent Massol on 2024/03/28

<
From version < 37.6 >
edited by Vincent Massol
on 2017/09/06
To version < 38.1 >
edited by Vincent Massol
on 2018/09/18
>
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -15,9 +15,18 @@
15 15  {{/info}}
16 16  
17 17  {{code}}
18 +// Required
18 18  create index xwl_value on xwikilargestrings (xwl_value(50));
19 19  create index xwd_parent on xwikidoc (xwd_parent(50));
20 20  create index xwd_class_xml on xwikidoc (xwd_class_xml(20));
22 +create index ase_page_date on activitystream_events (ase_page, ase_date);
23 +create index xda_docid1 on xwikiattrecyclebin (xda_docid);
24 +create index ase_param1 on activitystream_events (ase_param1(200));
25 +create index ase_param2 on activitystream_events (ase_param2(200));
26 +create index ase_param3 on activitystream_events (ase_param3(200));
27 +create index ase_param4 on activitystream_events (ase_param4(200));
28 +create index ase_param5 on activitystream_events (ase_param5(200));
29 +// Only required if you use stats (feature is off by default)
21 21  create index xws_number on xwikistatsdoc (XWS_NUMBER);
22 22  create index xws_classname on xwikistatsdoc (XWS_CLASSNAME);
23 23  create index xwr_number on xwikistatsreferer (XWR_NUMBER);
... ... @@ -27,13 +27,6 @@
27 27  create index xwv_cookie on xwikistatsvisit (XWV_COOKIE(255));
28 28  create index xwv_classname on xwikistatsvisit (XWV_CLASSNAME);
29 29  create index xwv_number on xwikistatsvisit (XWV_NUMBER);
30 -create index ase_page_date on activitystream_events (ase_page, ase_date);
31 -create index xda_docid1 on xwikiattrecyclebin (xda_docid);
32 -create index ase_param1 on activitystream_events (ase_param1(200));
33 -create index ase_param2 on activitystream_events (ase_param2(200));
34 -create index ase_param3 on activitystream_events (ase_param3(200));
35 -create index ase_param4 on activitystream_events (ase_param4(200));
36 -create index ase_param5 on activitystream_events (ase_param5(200));
37 37  {{/code}}
38 38  
39 39  {{info}}

Get Connected