Shekaru 10 bayan kafa reshe na 10.x, MariaDB 11.0.0 an sake shi, wanda ya ba da ci gaba mai yawa da canje-canje da suka karya daidaituwa. A halin yanzu reshe yana cikin ingancin sakin alpha kuma zai kasance a shirye don amfanin samarwa bayan daidaitawa. Babban reshe na gaba na MariaDB 12, wanda ya ƙunshi canje-canjen da ke karya daidaituwa, ana tsammanin ba a baya fiye da shekaru 10 daga yanzu (a cikin 2032).
Aikin MariaDB yana haɓaka cokali mai yatsa daga MySQL, yana riƙe da daidaituwa na baya a duk lokacin da zai yiwu kuma yana nuna haɗin ƙarin injunan ajiya da ƙarfin ci gaba. Gidauniyar MariaDB mai zaman kanta ce ke kula da ci gaban MariaDB, bin tsarin ci gaba da buɗe ido wanda ke zaman kansa na kowane dillalai. Ana ba da MariaDB DBMS maimakon MySQL a yawancin rarrabawar 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.
Babban mahimmin ci gaba a cikin reshen MariaDB 11 shine sauyin mai inganta tambaya zuwa sabon samfurin nauyi (samfurin farashi), wanda ke ba da ƙarin hasashen ma'aunin kowane shirin tambaya. Duk da yake sabon ƙirar na iya rage wasu ƙullun ayyukan aiki, ƙila ba zai zama mafi kyau a cikin kowane yanayi ba kuma yana iya rage wasu tambayoyi, don haka ana ƙarfafa masu amfani su shiga gwaji da sanar da masu haɓakawa idan matsaloli suka taso.
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 ayyuka tare da injin ajiya. Lokacin da ake kimanta aiki don ayyukan dogaro da saurin faifai, kamar jerin sikanin rubutu, yanzu muna ɗauka cewa an adana bayanan akan SSD wanda ke ba da saurin karantawa na 400MB a sakan daya. Bugu da ƙari, an daidaita 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 lura cewa sabon samfurin nauyi zai ba ku damar zaɓar mafi kyawun tsarin aiwatar da tambaya a cikin yanayi masu zuwa:
- Lokacin amfani da tambayoyin da suka wuce teburi sama da 2.
- Lokacin da kake da fihirisa masu ƙunshe da adadi mai yawa na ƙima iri ɗaya.
- Lokacin amfani da jeri wanda ke rufe fiye da 10% na tebur.
- Lokacin da kuke da hadaddun tambayoyin waɗanda ba duk ginshiƙan da aka yi amfani da su ba ne aka lissafta su.
- Lokacin da aka yi amfani da tambayoyin da suka haɗa da injunan ajiya daban-daban (misali, lokacin da tambaya ɗaya ta shiga tebur a cikin InnoDB da injunan ƙwaƙwalwa).
- Lokacin amfani da FORCE INDEX don inganta shirin tambaya.
- Lokacin da shirin tambaya ya lalace lokacin amfani da "ANALYZE TABLE".
- Lokacin da tambayar ta wuce adadi mai yawa na tebur da aka samo (yawan adadin Zaɓuɓɓukan gida).
- Lokacin amfani da ORDER BY ko GROUP BY maganganun da suka faɗo ƙarƙashin maƙasudai.
Manyan batutuwan dacewa a cikin MariaDB 11 reshe:
- Haƙƙin SUPER baya ƙyale ka ka aiwatar da ayyuka waɗanda ke akwai keɓaɓɓun gata. Misali, don canza tsarin binary logs, kuna buƙatar haƙƙin BINLOG ADMIN.
- An cire aiwatar da buffer canji a cikin InnoDB.
- Innodb_flush_hanyoyin da innodb_file_per_table an soke su.
- An soke tallafin sunan Mysql*.
- An soke saita fayyace_defaults_for_timestamp zuwa 0.
- Alamun haɗin gwiwa an haɗa su a cikin wani fakiti daban don dacewa da MySQL.
- An canza tsohuwar ƙimar sigar innodb_undo_tablespaces zuwa 3.
source: budenet.ru