<
From version < 70.2 >
edited by Ricardo Rodríguez
on 2021/10/28
To version < 72.1 >
edited by Thomas Mortagne
on 2021/10/28
>
Change comment: There is no comment for this version

Summary

Details

Page properties
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.rrodriguez
1 +XWiki.ThomasMortagne
Content
... ... @@ -8,19 +8,19 @@
8 8  
9 9  == MyISAM storage engine ==
10 10  
11 -MyISAM (the default storage engine for MySQL until release 5.5.5 in 2010) does not support transactions. If there is an error while data is being saved to the database, XWiki will attempt to rollback the transaction to its previous known good state. If you use MyISAM it will do nothing, leaving the database in whatever state it was in when the error occurred.
11 +MyISAM (the default storage engine for MySQL until release 5.5.5 in 2010) does not support transactions. If there is an error while data is being saved to the database, XWiki will attempt to roll back the transaction to its previous known good state. If you use MyISAM, it will do nothing, leaving the database in whatever state it was in when the error occurred.
12 12  
13 13  {{warning}}
14 -If you use MySQL with the MyISAM engine, you will most likely corrupt your database.**We highly recommend using a storage engine such as InnoDB which supports transactions.**
14 +If you use MySQL with any engine that does not support transactions, you will most likely corrupt your database.** We highly recommend using a storage engine such as InnoDB which supports transactions.**
15 15  {{/warning}}
16 16  
17 17  == MySQL versions older than 5.0 ==
18 18  
19 -XWiki does not fully work with MySQL versions 4.x or lower, due to several limitations of the way the SQL standards are implemented in MySQL, limited support for non-latin1 encodings, the flaky integration of Hibernate and MySQL 4, and other things. Most parts of the application work fine, but there are some parts that cannot be easily fixed, so if you must use MySQL 4.x, you're doing it on your own. MySQL 4 is pretty old and buggy so we recommend upgrading.
19 +XWiki does not fully work with MySQL versions 4.x or lower, due to several limitations of the way the SQL standards are implemented in MySQL, limited support for non-latin1 encodings, the flaky integration of Hibernate and MySQL 4, and other things. Most parts of the application work fine, but there are some parts that cannot be easily fixed, so if you must use MySQL 4.x, you're doing it on your own. MySQL 4 is pretty old and buggy, so we recommend upgrading.
20 20  
21 21  == MySQL versions older than 5.7 and utf8mb4 ==
22 22  
23 -If you use utf8mb4 encoding you won't be able to use version of MySQL older than 5.7 out of the box because of a limitation in the default maximum size of the keys and the default row format.
23 +If you use utf8mb4 encoding, you won't be able to use a version of MySQL older than 5.7 out of the box because of a limitation in the default maximum size of the keys and the default row format.
24 24  
25 25  == JDBC Driver Version ==
26 26  
... ... @@ -88,13 +88,7 @@
88 88  create index xwd_parent on xwikidoc (xwd_parent(50));
89 89  create index xwd_class_xml on xwikidoc (xwd_class_xml(20));
90 90  create index xda_docid1 on xwikiattrecyclebin (xda_docid);
91 -create index ase_page_date on activitystream_events (ase_page, ase_date);
92 -create index ase_param1 on activitystream_events (ase_param1(200));
93 -create index ase_param2 on activitystream_events (ase_param2(200));
94 -create index ase_param3 on activitystream_events (ase_param3(200));
95 -create index ase_param4 on activitystream_events (ase_param4(200));
96 -create index ase_param5 on activitystream_events (ase_param5(200));
97 -create index solr_iterate_all_documents on xwikidoc (XWD_WEB, XWD_NAME, XWD_LANGUAGE, XWD_VERSION);
91 +create index solr_iterate_all_documents on xwikidoc (XWD_WEB(500), XWD_NAME(253), XWD_LANGUAGE(5), XWD_VERSION(10));
98 98  // Only required if you use stats (feature is off by default)
99 99  create index xws_number on xwikistatsdoc (XWS_NUMBER);
100 100  create index xws_classname on xwikistatsdoc (XWS_CLASSNAME);

Get Connected