Our CI framework currently tests against MySQL5.5, MariaDB10.1 and will soon also be testing against MariaDB10.3 (Once we have D10 building packages building correctly). We have chosen these DB versions as they're the ones shipped by default with D8, D9 and U18 which are our current listed supported OS's. D8 will soon be deprecated (Debian themselves are dropping support come June 2020) and we are in the process of adopting D10 support (and hence MariaDB10.3). As those are the only DBs we are currently regularly testing I would suggest those are the ones people generally use, though of course if issues are reported against other we will accept bugfixes so long as they do not break the existing support but we cannot guarantee stability around the newer DBs otherwise. It does raise other questions as I've recently hit in a few occasions where recent MariaDB and MySQL have started to diverge more and as such it's getting increasingly difficult to support both in the current manor we are. *Martin Renvoize* <https://www.ptfs-europe.com> Development Team Manager *Phone:* +44 (0) 1483 378728 *Mobile:* +44 (0) 7725 985 636 *Email:* martin.renvoize@ptfs-europe.com *Fax:* +44 (0) 800 756 6384 www.ptfs-europe.com Registered in the United Kingdom No. 06416372 VAT Reg No. 925 7211 30 The information contained in this email message may be privileged, confidential and protected from disclosure. If you are not the intended recipient, any dissemination, distribution or copying is strictly prohibited. If you think that you have received this email message in error, please email the sender at info@ptfs-europe.com On Fri, 23 Aug 2019 at 08:44, Laurent Ducos <laurent.ducos@biblibre.com> wrote:
the update has many advantages and new features.
There is a new feature with 10.4 that limits the size of temporary tables. This is useful when running poorly constructed reports (Cartesian products) that can generate gigabytes of temporary tables. For exemple:
[mysqld] innodb_temp_data_file_path = ibtmp1:12M:autoextend:max:1G did anyone ever test this feature?
Laurent Ducos Administrateur système et réseaux chez BibLibre
23 août 2019 04:24 "Tomas Cohen Arazi" <tomascohen@gmail.com <tomascohen@gmail.com?to=%22Tomas%20Cohen%20Arazi%22%20%3Ctomascohen@gmail.com%3E>> a écrit:
We've been testing MySQL 8 as well, without major issues, besides the need to solve the authentication issue (i.e. making mysql-client v5.x work). Regards El jue., 22 ago. 2019 a las 22:53, Mark Tompsett (<mtompset@hotmail.com>) escribió:
Greetings,
In order to avoid the auto-increment bug, you really want 10.3 or higher. :)
GPML, Mark Tompsett
-----Original Message----- From: Laurent Ducos Sent: Thursday, August 22, 2019 4:50 AM To: koha-devel@lists.koha-community.org Subject: [Koha-devel] mariadb versions and koha
Hello We are currently using version 10.0 of mariadb with koha. We are planning a upgrade. Have you noticed problems with versions 10.1 10.2, 10.3 or 10.4?
-- Laurent Ducos Administrateur système et réseaux chez BibLibre IT system and network administrator at BibLibre _______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
_______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
-- Tomás Cohen Arazi Theke Solutions (http://theke.io) ✆ +54 9351 3513384 GPG: B2F3C15F
_______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/