Iminyaka eyi-10 emva kokusekwa kwesebe le-10.x, i-MariaDB 11.0.0 yakhululwa, eyanikezela ngophuculo olubalulekileyo kunye notshintsho olwaphula ukuhambelana. Isebe okwangoku likumgangatho wokukhutshwa kwe-alpha kwaye iya kuba ilungele ukusetyenziswa kwemveliso emva kokuzinziswa. Isebe elikhulu elilandelayo le-MariaDB 12, eliqulethe utshintsho oluhambelana nokuphulwa, kulindeleke ukuba akukho ngaphambili kwiminyaka eyi-10 ukususela ngoku (kwi-2032).
Iprojekthi ye-MariaDB iphuhlisa ifolokhwe esuka kwi-MySQL, igcina ukuhambelana ngasemva xa kunokwenzeka kwaye iquka ukuhlanganiswa kweenjini zokugcina ezongezelelweyo kunye nobuchule obuphambili. Uphuhliso lwe-MariaDB lujongwa yi-MariaDB Foundation ezimeleyo, ilandela inkqubo yophuhliso evulekileyo necacileyo ezimeleyo kubathengisi ngabanye. I-MariaDB DBMS inikezelwa endaweni ye-MySQL kwiindawo ezininzi ze-Linux (RHEL, SUSE, Fedora, openSUSE, Slackware, OpenMandriva, ROSA, Arch Linux, Debian) kwaye iphunyezwe kwiiprojekthi ezinkulu ezifana ne-Wikipedia, i-Google Cloud SQL kunye ne-Nimbuzz.
Uphuculo oluphambili kwisebe le-MariaDB 11 yinguqu ye-optimizer yombuzo kwimodeli entsha yobunzima (imodeli yeendleko), ebonelela ngokuqikelelwa ngokuchanekileyo kobunzima besicwangciso sombuzo ngamnye. Ngelixa imodeli entsha inokunciphisa ukusilela kokusebenza, isenokungabi yeyona nto ilungileyo kuzo zonke iimeko kwaye inokucothisa eminye imibuzo, ngoko ke abasebenzisi bayakhuthazwa ukuba bathathe inxaxheba ekuvavanyeni nasekuxeleleni abaphuhlisi ukuba kuvela iingxaki.
Imodeli yangaphambili ibilungile ekufumaneni isalathiso esisiso, kodwa ibinengxaki ngokusetyenziswa kokuskena kwetafile, iskena sesalathisi, okanye imisebenzi yokulanda uluhlu. Kwimodeli entsha, le ngqungquthela ikhutshwe ngokuguqula ubunzima besiseko sokusebenza kunye nenjini yokugcina. Xa kuhlolwa ukusebenza kwedisk exhomekeke kwisantya, njengokuskena okulandelelanayo kokubhala, ngoku sicinga ukuba idatha igcinwe kwi-SSD ebonelela ngesantya sokufunda se-400MB ngomzuzwana. Ukongezelela, ezinye iiparitha zobunzima be-optimizer zilungiswe, oko, ngokomzekelo, kwenza ukuba kube lula ukuphumeza amandla okusebenzisa izalathisi zemisebenzi ye- "ORDER BY / GROUP BY" kwii-subqueries kunye nokukhawulezisa umsebenzi kunye neetafile ezincinci kakhulu.
Kuqatshelwe ukuba imodeli entsha yobunzima iya kukuvumela ukuba ukhethe isicwangciso sokwenza imibuzo engaphezulu kwezi meko zilandelayo:
- Xa usebenzisa imibuzo engaphezu kweetafile ezi-2.
- Xa unezalathisi eziqulethe inani elikhulu lamaxabiso afanayo.
- Xa usebenzisa uluhlu olugubungela ngaphezu kwe-10% yetheyibhile.
- Xa unemibuzo entsonkothileyo apho ingezizo zonke iikholamu ezisetyenzisiweyo ezinezalathiso.
- Xa kusetyenziswa imibuzo ebandakanya iinjini zokugcina ezahlukeneyo (umzekelo, xa umbuzo omnye ufikelela kwiitafile kwi-InnoDB kunye neenjini zeMemori).
- Xa usebenzisa i-FORCE INDEX ukuphucula isicwangciso sombuzo.
- Xa isicwangciso sombuzo siwohloka xa usebenzisa "ANALYZE TABLE".
- Xa umbuzo uthatha inani elikhulu leetafile ezifunyenweyo (inani elikhulu le-ENTED KHETHA).
- Xa usebenzisa u-ORDER BY okanye GROUP BY amabinzana awela phantsi kwezalathisi.
Imiba ephambili yokuhambelana kwisebe le-MariaDB 11:
- Amalungelo aphezulu akasakuvumeli ukuba wenze izenzo apho amalungelo abekwe ngokwahlukeneyo akhoyo. Umzekelo, ukutshintsha ifomathi yelogi yokubini, uya kufuna BINLOG ADMIN amalungelo.
- Isuse ukuphunyezwa kwebuffer yotshintsho kwi-InnoDB.
- I-Innodb_flush_method kunye ne-innodb_file_per_table ziyekisiwe.
- Igama elithi Mysql* lirhoxisiwe.
- Ukuseta explicit_defaults_for_timestamp ukuya ku-0 kuyekisiwe.
- Iikhonkco zeSimboli zibandakanyiwe kwiphakheji eyahlukileyo yokuhambelana ne-MySQL.
- Ixabiso elimiselweyo le-innodb_undo_tablespaces parameter litshintshiwe laya ku-3.
umthombo: opennet.ru