mariadb bug - how to upgrade to newer version

openSUSE Leap 15.2 has a version of mariadb v10.4 with a terrible bug, it updates foreign keys hundred times slower:
https://bugzilla.opensuse.org/show_bug.cgi?id=1174506

It should have been fixed in v10.5. But there’s no update for it in YAST.

Is there any way to update it (mariadb only) to the newest version without distro version change?

https://download.opensuse.org/repositories/server:/database/openSUSE_Leap_15.2/

Leap does not update versions from 10.4 to 10.5, you will have to use the OBS/Factory repo.

I use the Server: version in heavy duty production with no issues.

?
Mariadb 10.5.8 is in that repo since Dec 22.

A “One Click Install” is available at
https://software.opensuse.org/package/mariadb
Be sure to install from the server:database repo (which was also specified by @Miuko)

TSU

interestingly many software from the main oss repo has some severe bugs and/or is quite out of date - working or more recent versions often provided in additional repos
as for mariadb I prefer to use mariadb.org repo instead of opensuse repo

I meant Leap does not update the MariaDB version in the Update: repo for all users but you have to use the Factory/OBS one which I pointed out.

Thank you for the info, that worked! MySql (mariadb) is working fast now as it should.

Sounds like a bug.
Should only require adding the repo, zypper should then discover the most recent version in all configured repos and automatically update.
Someone should submit a bug to get this fixed?

TSU