sobrenome Posted September 28, 2020 Share Posted September 28, 2020 Is IPS 4.4 compatible with MariaDB 10.5? Link to comment Share on other sites More sharing options...
Makoto Posted September 28, 2020 Share Posted September 28, 2020 Yes, it works absolutely fine with 10.5 sobrenome 1 Link to comment Share on other sites More sharing options...
ASTRAPI Posted September 28, 2020 Share Posted September 28, 2020 (edited) Please keep in mind that MariaDB 10.4/10.5, are not drop-in backwards compatible so choosing any of these would/may be one way upgrade/switches. Also many users report performance issues (most querying big tables) for the 10.4 that i didn't test yet at 10.5 as it is a bit early for me to do that jump.... A temporary solution for that is to use this parameter at your my.cnf file: optimizer_use_condition_selectivity=1 Enjoy ! 🙂 Edited September 28, 2020 by ASTRAPI sobrenome 1 Link to comment Share on other sites More sharing options...
sobrenome Posted September 29, 2020 Author Share Posted September 29, 2020 Thanks @ASTRAPI! Considering your shared knowledge on MariaDB 10.5, I will wait a little longer to upgrade. ASTRAPI 1 Link to comment Share on other sites More sharing options...
Makoto Posted September 29, 2020 Share Posted September 29, 2020 (edited) For the record I'm hired to manage servers with up to 16 million posts on servers running MariaDB 10.5 with no performance issues, so I would take anecdotal performance concerns with a grain of salt unless there's documented issues that can be reproduced. Otherwise it's generally safe to assume the latest compatible build is the best to be using. I assume you're referring to MDEV-20519 though, which impacted all releases prior to 10.5 up to a certain maintenance build and is, again, why you should always keep updated,https://jira.mariadb.org/browse/MDEV-20519 Edited September 30, 2020 by Makoto sobrenome 1 Link to comment Share on other sites More sharing options...
sobrenome Posted September 21, 2021 Author Share Posted September 21, 2021 On 9/28/2020 at 8:08 PM, ASTRAPI said: Also many users report performance issues (most querying big tables) for the 10.4 that i didn't test yet at 10.5 as it is a bit early for me to do that jump.... Have you jumped already? Link to comment Share on other sites More sharing options...
ASTRAPI Posted September 21, 2021 Share Posted September 21, 2021 Not yet as no needed 🙂 sobrenome 1 Link to comment Share on other sites More sharing options...
sobrenome Posted September 22, 2021 Author Share Posted September 22, 2021 18 hours ago, ASTRAPI said: Not yet as no needed 🙂 Running 10.5 with no issues so far. Waiting for 10.6 support on RDS. ASTRAPI 1 Link to comment Share on other sites More sharing options...
Recommended Posts