Zaka 10 pambuyo pa kukhazikitsidwa kwa nthambi ya 10.x, MariaDB 11.0.0 inatulutsidwa, yomwe inapereka kusintha kwakukulu ndi kusintha komwe kunasokoneza kugwirizanitsa. Nthambiyi pakadali pano ili mumtundu wa alpha ndipo ikhala yokonzeka kugwiritsidwa ntchito pambuyo pokhazikika. Nthambi yayikulu yotsatira ya MariaDB 12, yomwe ili ndi zosintha zomwe zimagwirizana, sizikuyembekezeka kale kuposa zaka 10 kuchokera pano (mu 2032).
Pulojekiti ya MariaDB ikupanga foloko kuchokera ku MySQL, kusunga kuyanjana kumbuyo ngati kuli kotheka ndikukhala ndi kuphatikiza kwa injini zosungirako zowonjezera ndi luso lapamwamba. Kukula kwa MariaDB kumayang'aniridwa ndi MariaDB Foundation yodziyimira payokha, kutsatira njira yotseguka komanso yowonekera yomwe ili yodziyimira pawokha kwa ogulitsa. MariaDB DBMS imaperekedwa m'malo mwa MySQL m'magawo ambiri a Linux (RHEL, SUSE, Fedora, openSUSE, Slackware, OpenMandriva, ROSA, Arch Linux, Debian) ndipo yakhazikitsidwa m'mapulojekiti akuluakulu monga Wikipedia, Google Cloud SQL ndi Nimbuzz.
Kusintha kwakukulu munthambi ya MariaDB 11 ndikusintha kwa chowonjezera cha mafunso kupita ku mtundu watsopano wolemera (mtengo wamtengo), womwe umapereka kulosera kolondola kwambiri kwa zolemera za dongosolo lililonse lafunso. Ngakhale kuti chitsanzo chatsopanochi chikhoza kuchepetsa zovuta zina, sizingakhale bwino muzochitika zonse ndipo zingachepetse mafunso ena, kotero ogwiritsa ntchito akulimbikitsidwa kutenga nawo mbali poyesa ndikudziwitsa okonza ngati mavuto abuka.
Chitsanzo cham'mbuyocho chinali chabwino popeza ndondomeko yabwino, koma chinali ndi vuto ndi kugwiritsa ntchito matebulo, masikanidwe a index, kapena ntchito zotengera mitundu. Muchitsanzo chatsopano, drawback iyi imachotsedwa mwa kusintha kulemera kwa ntchito ndi injini yosungirako. Tikawunika momwe magwiridwe antchito amadalira liwiro la disk, monga zowerengera motsatizana, tsopano tikuganiza kuti deta imasungidwa pa SSD yomwe imapereka kuthamanga kwa 400MB pamphindikati. Kuphatikiza apo, magawo ena olemera a optimizer adasinthidwa, zomwe, mwachitsanzo, zidapangitsa kuti zitheke kugwiritsa ntchito ma index a "ORDER BY/GROUP BY" m'ma subqueries ndikufulumizitsa ntchito ndi matebulo ang'onoang'ono.
Zadziwika kuti mtundu watsopano wolemetsa umakupatsani mwayi wosankha njira yabwino kwambiri yochitira mafunso muzochitika izi:
- Mukamagwiritsa ntchito mafunso opitilira ma tebulo a 2.
- Pamene muli ndi ma index omwe ali ndi chiwerengero chachikulu cha zinthu zofanana.
- Mukamagwiritsa ntchito magawo omwe amaphimba 10% ya tebulo.
- Mukakhala ndi mafunso ovuta omwe simagawo onse omwe amagwiritsidwa ntchito ndi indexed.
- Mafunso akagwiritsidwa ntchito omwe amaphatikiza mainjini osungira osiyanasiyana (mwachitsanzo, funso limodzi likapeza matebulo mu injini za InnoDB ndi Memory).
- Mukamagwiritsa ntchito FORCE INDEX kukonza dongosolo lamafunso.
- Pamene dongosolo lafunso likuwonongeka mukamagwiritsa ntchito "ANALYZE TABLE".
- Pamene funso spans ambiri anachokera matebulo (chiwerengero cha zisa ZOSAKHA).
- Mukamagwiritsa ntchito ORDER BY kapena GROUP BY mawu omwe ali pansi pa indexes.
Nkhani zazikulu zofananira mu nthambi ya MariaDB 11:
- Ufulu wa SUPER sukulolaninso kuchita zinthu zomwe mwayi wapadera ulipo. Mwachitsanzo, kuti musinthe mawonekedwe a zipika zamabina, mudzafunika ufulu wa BINLOG ADMIN.
- Yachotsa kusintha kwa buffer ku InnoDB.
- Innodb_flush_method ndi innodb_file_per_table zachotsedwa ntchito.
- Thandizo la dzina la Mysql* lachotsedwa.
- Kukhazikitsa explicit_defaults_for_timestamp kukhala 0 kwachotsedwa.
- Maulalo ophiphiritsa akuphatikizidwa mu phukusi lapadera kuti agwirizane ndi MySQL.
- Mtengo wokhazikika wa parameter ya innodb_undo_tablespaces wasinthidwa kukhala 3.
Source: opennet.ru