I-MariaDB 11 isivele ikhishiwe futhi lezi yizindaba zayo

Eminyakeni eyi-10 ngemuva kokusungulwa kwegatsha le-10.x, ekugcineni kwakhululwa inguqulo entsha negatsha le-MariaDB 11.0.0, ukuthi iletha ukuthuthukiswa okuningana okubalulekile futhi iphula izinguquko zokuhambisana.

I-MariaDB 11 isivele ikhishiwe futhi lezi yizindaba zayo futhi izobe isilungele ukusetshenziswa ekukhiqizeni ngemva kokuzinza. Igatsha elilandelayo elibalulekile le-MariaDB 12, eliqukethe izinguquko ezihambisana nekhefu, kulindeleke ukuthi libe maduzane kuneminyaka eyi-10 (ngo-2032).

Kulabo abangazi ngephrojekthi ye-MariaDB, kufanele ukwazi lokho ithuthukisa imfoloko ye-MySQL egcina ukuhambisana emuvas noma yikuphi lapho kungenzeka khona futhi ihlukaniswa ngokuhlanganiswa kwezinjini zokulondoloza ezengeziwe nezici ezithuthukisiwe.

Ukuthuthukiswa kwe-MariaDB yenganyelwe isisekelo esizimele se-MariaDB, kulandela inqubo yentuthuko evulekile nesobala ngaphandle kwabathengisi ngabanye. I-MariaDB ithumela esikhundleni se-MySQL ekusakazweni okuningi kwe-Linux.

Izici ezintsha eziyinhloko zeMariaDB 11

Kulokhu kukhishwa okusha kwe-MariaDB 11 enye yentuthuko ebalulekile egatsheni buza ukuhumusha kwe-optimizer kumodeli yesisindo esisha (imodeli yezindleko), okuyinto inikeza ukubikezela okunembe kakhudlwana kwezisindo zohlelo lokusebenza lombuzo ngamunye. Nakuba imodeli entsha isusa amabhodlela athile okusebenza, ingase ingabi elungile kuzo zonke izimo futhi eminye imibuzo ingase yehlise ijubane, ngakho abasebenzisi bakhuthazwa ukuthi babambe iqhaza ekuhloleni futhi bazise onjiniyela uma kuba nezinkinga.

Imodeli engenhla isebenze kahle ukuthola inkomba efanele, kodwa ube nezinkinga ngokusebenza kokuskena kwethebula, ukuskena kwenkomba, noma ukubheka ububanzi. Kumodeli entsha, lokhu kungalungile kuqedwa ngokushintsha isisindo sesisekelo sokusebenza ngenjini yokugcina.

ukuhlolwa kokusebenza imisebenzi ethatha idisk ejulile njengokuskena kokubhala okulandelanayo, manje bacabanga ukuthi idatha igcinwe ku-SSD enamandla okufunda angu-400 MB ngomzuzwana. Ukwengeza, amanye amapharamitha esisindo se-optimizer acwengisiswa, okwathi, ngokwesibonelo, kwenze kwaba nokwenzeka ukusebenzisa izinkomba zemisebenzi ethi "ORDER BY/GROUP BY" kuma-subqueries kanye nokusheshisa umsebenzi ngamatafula amancane kakhulu.

Enye into entsha egqamayo ukuthi imodeli entsha yesisindo izovumela ukukhetha uhlelo olungcono kakhulu lokubuza imibuzo kulezi zimo ezilandelayo:

• Uma usebenzisa imibuzo enamathebula angaphezu kwama-2.
• Uma kunezinkomba eziqukethe inani elikhulu lamanani afanayo.
• Uma usebenzisa ububanzi obumboza ngaphezu kuka-10% wethebula.
• Uma unemibuzo eyinkimbinkimbi lapho kungewona wonke amakholomu asetshenzisiwe anezikhombo.
• Uma usebenzisa imibuzo ebandakanya izinjini zokulondoloza ezihlukene (isibonelo, uma umbuzo uqukethe ukufinyelela kumathebula ku-InnoDB kanye nezinjini zeMemori).
• Ngokusebenzisa i-FORCE INDEX ukuthuthukisa uhlelo lombuzo.
• Uma uhlelo lombuzo lwehliswa esimweni sokusebenzisa okuthi "HLAZIYA ITHEBULA".
• Uma umbuzo ufinyelela inombolo enkulu yokubuka (inani elikhulu LOKUKHETHA okufakwe esidlekeni).
• Uma usebenzisa i-ORDER BY noma GROUP BY izigaba ezifanayo nezinkomba.

Engxenyeni ye- ikhefu lokuhambisana Kule nguqulo entsha ye-MariaDB 11, amakhefu alandelayo esizowathola kuleli gatsha elisha kubaluliwe:

• Amalungelo angu-SUPER awasakuvumeli ukuthi wenze izenzo lapho amalungelo asethwe ngokwehlukana atholakalayo. Isibonelo, ukushintsha ifomethi yamalogi kanambambili kuzodinga amalungelo omlawuli we-BINLOG.
• Kukhishwe ukusetshenziswa kwebhafa yoshintsho ku-InnoDB.
• Kwehlisiwe innodb_flush_method kanye ne-innodb_file_per_table.
• Ukusekelwa kwamagama e-mysql* kuhoxisiwe.
• Kwehlisiwe ukusetha i-explicit_defaults_for_timestamp ukuya ku-0.
• Izixhumanisi eziwuphawu zihanjiswe kuphakheji ehlukile ukuze zihambisane ne-MySQL.
• Inani lepharamitha ye-innodb_undo_tablespaces lishintshiwe lisuka kokumisiwe laya kokungu-3.

Okokugcina uma unentshisekelo yokwazi kabanzi ngakho mayelana nalokhu kukhishwa okusha, ungabheka imininingwane ku isixhumanisi esilandelayo.