MariaDB 10.5

[sobrenome]

Is IPS 4.4 compatible with MariaDB 10.5?

[Makoto]

Yes, it works absolutely fine with 10.5

[ASTRAPI]

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]

Thanks @ASTRAPI! Considering your shared knowledge on MariaDB 10.5, I will wait a little longer to upgrade.

[Makoto]

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]

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?

[ASTRAPI]

Not yet as no needed 🙂

[sobrenome]

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.