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?
Miuku
January 11, 2021, 6:30am
2
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.
tsu2
January 11, 2021, 7:29am
3
Miuku:
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
Miuku
January 11, 2021, 8:17am
5
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.
Miuku:
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.
Thank you for the info, that worked! MySql (mariadb) is working fast now as it should.
tsu2
January 12, 2021, 10:57pm
7
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