I-MariaDB 11 sele ikhutshiwe kwaye ezi ziindaba zayo

iminyaka eli-10 emva kokusekwa kwesebe le-10.x, ekugqibeleni inguqulelo entsha kunye nesebe le-MariaDB 11.0.0 lakhululwa, que izisa uphuculo oluninzi olubalulekileyo kwaye iphula utshintsho lokuhambelana.

I-MariaDB 11 sele ikhutshwe kwaye ezi ziindaba zayo kwaye iya kuba ilungele ukusetyenziswa kwemveliso emva kokuzinziswa. Isebe elilandelayo elibalulekileyo le-MariaDB 12, eliqulethe utshintsho oluhambelana nekhefu, kulindeleke ukuba lube ngaphaya kweminyaka eyi-10 (kwi-2032).

Kwabo bangayazi iprojekthi yeMariaDB, kuya kufuneka uyazi loo nto iphuhlisa ifolokhwe ye-MySQL egcina ukuhambelana komvas naphi na apho kunokwenzeka kwaye yahlulwe ngokudityaniswa kweenjini zokugcina ezongezelelweyo kunye neempawu eziphambili.

Ukuphuhliswa kweMariaDB yonganyelwe yi-MariaDB isiseko esizimeleyo, kulandela inkqubo yophuhliso evulelekileyo necacileyo ezimeleyo kubathengisi ngabanye. Iinqanawa zikaMariaDB endaweni yeMySQL kunikezelo oluninzi lweLinux.

Iimpawu ezintsha eziphambili zikaMariaDB 11

Kolu kukhutshwa lutsha lwe-MariaDB 11 enye yezinto eziphambili zophuculo kwisebe yi umbuzo optimizer translation kwimodeli entsha yokulinganisa (imodeli yeendleko), leyo inikeza uqikelelo oluchaneke ngakumbi lobunzima besicwangciso sokwenziwa kombuzo ngamnye. Ngelixa imodeli entsha isusa imiqobo yokusebenza, isenokungabi yelungileyo kuzo zonke iimeko kwaye eminye imibuzo inokucotha, ngoko ke abasebenzisi bayakhuthazwa ukuba bathathe inxaxheba kuvavanyo kwaye bazise abaphuhlisi xa kukho nayiphi na imiba.

Le modeli ingentla isebenze kakuhle ukufumana isalathiso esisiso, kodwa yayinemiba ngokusetyenziswa kovavanyo lwetafile, iskena sesalathisi, okanye uluhlu lokujonga. Kwimodeli entsha, oku kungalunganga kupheliswe ngokutshintsha ubunzima besiseko sokusebenza kunye nenjini yokugcina.

uvandlakanyo lwentsebenzo kwimisebenzi enzulu yediski efana nokubhala ngokulandelelanayo ukuskena, ngoku bacinga ukuba idatha igcinwe kwi-SSD kunye nomthamo wokufunda we-400 MB ngomzuzwana. Ukongezelela, ezinye iiparitha zobunzima be-optimizer zaphuculwa, oko, ngokomzekelo, kwenza kube lula ukuphumeza ukusetyenziswa kwezalathisi ze-"ORDER BY / GROUP BY" kwi-subqueries kunye nokukhawulezisa umsebenzi kunye neetafile ezincinci kakhulu.

Enye into entsha ebalaseleyo kukuba imodeli entsha yokulinganisa iya kuvumela ukukhetha isicwangciso sokwenza imibuzo engaphezulu kwezi meko zilandelayo:

• Xa usebenzisa imibuzo engaphezu kweetafile ezi-2.
• Xa kukho ii-indices eziqulethe inani elikhulu lamaxabiso afanayo.
• Xa usebenzisa uluhlu olugubungela ngaphezulu kwe-10% yetheyibhile.
• Xa unemibuzo entsonkothileyo apho ingeyiyo yonke imihlathi esetyenzisiweyo enezalathiso.
• Xa usebenzisa imibuzo ebandakanya iinjini zokugcina ezahlukeneyo (umzekelo, xa umbuzo uqulethe ukufikelela kwiitafile kwi-InnoDB kunye neenjini zeMemori).
• Ngokusebenzisa i-FORCE INDEX ukuphucula isicwangciso sombuzo.
• Xa isicwangciso sombuzo sithotywa kwimeko yokusetyenziswa kwe-"ANALYZE TABLE".
• Xa umbuzo uthatha inani elikhulu leemboniselo (inani elikhulu lokukhetha okusedlelweni).
• Xa usebenzisa i-ORDER BY okanye GROUP BY amagatya ahambelana nezalathisi.

Kwicala le ikhefu lokuhambelana Kolu guqulelo lutsha lwe-MariaDB 11, ezi khefu zilandelayo esiya kuzifumana kweli sebe litsha zikhankanyiwe:

• Amalungelo aphezulu akasakuvumeli ukuba wenze izenzo apho amalungelo abekwe ngokwahlukeneyo akhoyo. Umzekelo, ukutshintsha ifomathi yeelog zokubini kuya kufuna amalungelo OLAWULO WE-BINLOG.
• Isuse ukuphunyezwa kwebuffer yotshintsho kwi-InnoDB.
• Ihoxisiwe innodb_flush_method kunye ne-innodb_file_per_table.
• Inkxaso yamagama e-mysql* iye yarhoxiswa.
• Iyalahlwa isethingi explicit_defaults_for_timestamp ukuya ku-0.
• Amakhonkco ophawu asiwe kwiphakheji eyahlukileyo ukuze ahambelane ne-MySQL.
• Ixabiso le-innodb_undo_tablespaces iparamitha itshintshiwe ukusuka kwesisiseko ukuya kwisi-3.

Gqibela ukuba unomdla wokwazi okungakumbi ngayo malunga nokukhutshwa okutsha, ungajonga iinkcukacha kwi ukulandela ikhonkco.