An buga sakin MariaDB DBMS 11.4.2, wanda aka yiwa alama a matsayin bargawar sakin farko na reshen 11.4. An rarraba reshen MariaDB 11.4 a matsayin sakin tallafi na dogon lokaci kuma za a tallafa masa aƙalla shekaru 5. A lokaci guda, sakin MariaDB 11.5.1, wanda ke da matsayi na ɗan takarar saki, yana samuwa, kuma an kafa reshe na 11.6, wanda za a haɓaka sabon aiki.
Aikin MariaDB yana haɓaka wani yanki na MySQL wanda ke kula da daidaiton baya kuma yana nuna haɗakar ƙarin injunan ajiya da fasaloli na ci gaba. Gidauniyar MariaDB mai zaman kanta ce ke kula da ci gaban MariaDB, bayan tsarin ci gaba mai buɗewa da gaskiya ba tare da la'akari da masu siyarwa daban-daban ba. Ana aika MariaDB azaman madadin MySQL a cikin rarrabawa da yawa. Linux (RHEL, SUSE, Fedora, openSUSE, Slackware, OpenMandriva, ROSA, Arch Linux, Debian) kuma an aiwatar da shi a cikin manyan ayyuka kamar Wikipedia, Google Cloud SQL da Nimbuzz.
Daga cikin canje-canje a cikin reshen MariaDB 11.4 idan aka kwatanta da sakin LTS na baya 10.11:
- An inganta ingantaccen abin tambaya, an canza shi zuwa sabon ƙirar nauyi (samfurin farashi), wanda ke ba da ƙarin ingantaccen hasashen ma'aunin kowane shirin tambaya. Samfurin da ya gabata yana da kyau a gano mafi kyawun fihirisar, amma yana da matsaloli tare da aiwatar da sikanin tebur, sikanin fihirisa, ko ayyukan debo kewayo. A cikin sabon samfurin, an kawar da wannan koma baya ta hanyar canza nauyin tushe na ayyukan da ke hade da injin ajiya. Misali, ayyukan ajiya kamar na'urorin rikodin jeri yanzu suna ɗauka cewa an adana bayanan a kan faifan SSD mai sauri. Bugu da ƙari, an kunna wasu sigogi masu nauyi na mai ingantawa, wanda, alal misali, ya ba da damar aiwatar da ikon yin amfani da fihirisa don ayyukan "ORDER BY/GROUP BY" a cikin ƙananan hukumomi da kuma hanzarta aiki tare da ƙananan tebur.
- An inganta sarrafa abubuwan da ke cikin UPDATE da DELETE maganganun da aka iyakance ga tebur ɗaya.
- An kunna amfani da fihirisa a cikin tambayoyin da ke kwatanta ayyukan DATE da SHEKARA tare da akai-akai, misali, "Zabi * DAGA T2 SHEKARA (a) = 2024" ko "Zabi * DAGA t2 RANAR (a)
source: budenet.ru
