Pambuyo pa miyezi ya 6 yachitukuko, kumasulidwa kokhazikika kwa nthambi yatsopano ya DBMS MariaDB 10.7 (10.7.2) kwasindikizidwa, momwe nthambi ya MySQL ikupangidwira yomwe imasunga kuyanjana kwambuyo ndipo imasiyanitsidwa ndi kuphatikiza kosungirako kowonjezera. injini ndi luso lapamwamba. Kukula kwa MariaDB kumayang'aniridwa ndi MariaDB Foundation yodziyimira payokha, kutsatira njira yotseguka komanso yowonekera bwino yomwe ili yodziyimira pawokha kwa ogulitsa. MariaDB imaperekedwa ngati m'malo mwa MySQL pamagawidwe ambiri a Linux (RHEL, SUSE, Fedora, openSUSE, Slackware, OpenMandriva, ROSA, Arch Linux, Debian) ndipo yakhazikitsidwa m'ma projekiti akuluakulu monga Wikipedia, Google Cloud SQL ndi Nimbuzz.
Panthawi imodzimodziyo, kuyesa koyamba kumasulidwa kwa nthambi yaikulu yotsatira ya MariaDB 10.8.1 ndi zosintha zosintha 10.6.6, 10.5.14, 10.4.23, 10.3.33 ndi 10.2.42 zinatulutsidwa. Kutulutsidwa kwa 10.7.2 kunali koyamba pulojekitiyo itasinthira ku mtundu watsopano womasulidwa, womwe unkatanthauza kuchepetsa nthawi yothandizira kuchokera ku zaka 5 kufika ku 1 chaka ndi kusintha kwa kupanga zotulutsa zazikulu osati kamodzi pachaka, koma kamodzi kotala. .
Zosintha zazikulu mu MariaDB 10.7:
- Yawonjezera mtundu watsopano wa data wa UUID wopangidwa kuti usunge 128-bit Unique Identifiers.
- Ntchito zatsopano zakonzedwa kuti zisanthulidwe mumtundu wa JSON: JSON_EQUALS() poyerekeza zolemba ziwiri za JSON ndi JSON_NORMALIZE() pobweretsa zinthu za JSON kukhala mawonekedwe oyenera kufananiza (makiyi osankhidwa ndi kuchotsa mipata).
- Anawonjezera NATURAL_SORT_KEY() ntchito yosankha zingwe poganizira za digito (mwachitsanzo, chingwe "v10" mutasanja chidzachitika pambuyo pa chingwe "v9").
- Onjezani ntchito ya SFORMAT () pakusanjikiza kosasinthasintha kwa zingwe - cholowetsacho ndi chingwe chokhala ndi malamulo osinthira ndi mndandanda wazinthu zosinthira (mwachitsanzo, 'SFORMAT("Yankho ndi {}.", 42)').
- Malipoti olakwika owongolera mu mafunso a INSERT omwe amawonjezera data pamizere ingapo (lamulo la GET DIAGNOSTICS tsopano likuwonetsa ROW_NUMBER kusonyeza nambala ya mzere ndi cholakwika).
- Pulagi yatsopano yowunika mawu achinsinsi, password_reuse_check, ikuphatikizidwa, yomwe imakulolani kuti muchepetse kugwiritsa ntchito mawu achinsinsi ndi wogwiritsa ntchito m'modzi (kuyang'ana kuti mawu achinsinsi sakugwirizana ndi mawu achinsinsi omwe amagwiritsidwa ntchito panthawi yomwe yatchulidwa password_reuse_check_interval parameter).
- Thandizo lowonjezera la mawu oti "ALTER TABLE ... GAWO WOSINTHA .. KUTI TABLE" ndi "ALTER TABLE ... TABLE WOSINTHA ... KUGAWA" posintha magawo kukhala tebulo mosemphanitsa.
- Njira ya "--as-of" yawonjezedwa ku mariadb-damp utility kuti mutayire zinyalala zogwirizana ndi malo enaake a tebulo losinthidwa.
- Kwa Cluster ya MariaDB Galera, mayiko atsopano "akudikirira kuchita yekha", "kudikirira TOI DDL", "kudikirira kuwongolera" ndi "kudikirira chiphaso" akugwiritsidwa ntchito mu PROCESSLIST.
- Parameter yatsopano "kukonzanso" yawonjezedwa ku optimizer. Pazingwe zokhala ndi ma bayte angapo, magwiridwe antchito amafananiza odziwa tanthauzo muzochita zamitundu ya ASCII awongoleredwa.
- Kusungirako kwa InnoDB kwasintha magwiridwe antchito a batch, presorting, ndi index building.
- Zowonongeka 5 zakhazikitsidwa, zomwe sizinafotokozedwebe: CVE-2022-24052, CVE-2022-24051, CVE-2022-24050, CVE-2022-24048, CVE-2021-46659.
- Zina mwa zosintha pakutulutsidwa kwa mayeso a MariaDB 10.8.1, titha kuzindikira kukhazikitsidwa kwa ma index omwe amasanjidwa motsika, zomwe zitha kupititsa patsogolo magwiridwe antchito a ORDER BY potenga motsatana. Zowonjezera za IN, OUT, INOUT ndi IN OUT pazosungidwa. Mu InnoDB, kuchuluka kwa ntchito zolembera pamene ntchito yodula mitengo yobwereranso (kuyambiranso) yachepetsedwa.
Source: opennet.ru