Ka mor'a likhoeli tsa 6 tsa nts'etsopele, tokollo ea pele e tsitsitseng ea lekala le lecha la DBMS MariaDB 10.7 (10.7.2) e hatisitsoe, moo lekala la MySQL le ntseng le ntlafatsoa le bolokang ho lumellana ka morao 'me le khetholloa ka ho kopanngoa ha polokelo e eketsehileng. dienjini le bokgoni bo tsoetseng pele. Nts'etsopele ea MariaDB e tsamaisoa ke Mokhatlo o ikemetseng oa MariaDB, ho latela ts'ebetso ea nts'etsopele e bulehileng ka ho felletseng e ikemetseng ho barekisi ka bomong. MariaDB e fanoa e le sebaka sa MySQL ho li-distributions tse ngata tsa Linux (RHEL, SUSE, Fedora, openSUSE, Slackware, OpenMandriva, ROSA, Arch Linux, Debian) 'me e sebelisitsoe mererong e meholo e kang Wikipedia, Google Cloud SQL le Nimbuzz.
Ka nako e ts'oanang, tlhahiso ea pele ea teko ea lekala le latelang le leholo la MariaDB 10.8.1 le lisebelisoa tsa ho lokisa 10.6.6, 10.5.14, 10.4.23, 10.3.33 le 10.2.42 li ile tsa lokolloa. Phatlalatso ea 10.7.2 e bile ea pele ka mor'a hore morero o fetohele mokhoa o mocha oa tlhahiso ea tokollo, o neng o fana ka maikutlo a ho fokotseha ha nako ea tšehetso ho tloha ho lilemo tsa 5 ho ea ho selemo sa 1 le phetoho ea ho thehoa ha litokollo tsa bohlokoa eseng hang ka selemo, empa hang ka kotara. .
Lintlafatso tsa bohlokoa ho MariaDB 10.7:
- E kentse mofuta o mocha oa data oa UUID o etselitsoeng ho boloka 128-bit Unique Identifiers.
- Ho 'nile ha etsoa tlhahiso ea mesebetsi e mecha bakeng sa ho sebetsana le lintlha ka mokhoa oa JSON: JSON_EQUALS() bakeng sa ho bapisa boitsebiso ba litokomane tse peli tsa JSON le JSON_NORMALIZE() bakeng sa ho tlisa lintho tsa JSON mofuteng o loketseng ho etsa ts'ebetso ea ho bapisa (ho hlopha linotlolo le ho tlosa libaka).
- E kentse tšebetso ea NATURAL_SORT_KEY() bakeng sa ho hlophisa likhoele ho latela boleng ba dijithale (mohlala, khoele "v10" kamora ho hlopha e tla etsahala kamora mohala "v9").
- E kentse ts'ebetso ea SFORMAT () bakeng sa ho fomata ka mokhoa o sa reroang ha likhoele - kenyelletso ke khoele e nang le litaelo tsa ho fometa le lethathamo la boleng bakeng sa ho kenya sebaka (mohlala, 'SFORMAT("Karabo ke {}.", 42)').
- E ntlafalitse tlaleho ea liphoso ho INSERT lipotso tse eketsang lintlha melaleng e mengata (taelo ea GET DIAGNOSTICS joale e bontša thepa ROW_NUMBER e bontšang nomoro ea mola le phoso).
- Ho kenyelelitsoe plugin e ncha ea ho hlahloba phasewete, password_reuse_check, e u lumellang ho fokotsa tšebeliso ea li-password ke mosebelisi a le mong (ho hlahloba hore phasewete e ncha ha e lumellane le password e sebelisitsoeng nakong e boletsoeng ke password_reuse_check_interval parameter).
- Tšehetso e ekelitsoeng bakeng sa lipoleloana "ALTER TAFOLE ... FETOLA KAROLO .. HO TLA TLA TLA" le "ALTER TAFOLE ... FETOLELA TAFOLE ... HO AROHANA" bakeng sa ho fetolela karohano ho ba tafole 'me ka tsela e fapaneng.
- Khetho ea "--as-of" e kenyellelitsoe ho mariadb-damp utility ho lahla thotobolo e tsamaellanang le boemo bo itseng ba tafole e fetotsoeng.
- Bakeng sa MariaDB Galera Cluster, linaha tse ncha "e emetse ho phethahatsa ka thōko", "ho letela TOI DDL", "ho letela taolo ea phallo" le "ho emela setifikeiti" li kenngoa ts'ebetsong ho PROCESSLIST.
- Paramethara e ncha "ho hlophisa bocha" e kentsoe ho optimizer. Bakeng sa likhoele tse nang le li-byte tse ngata, ts'ebetso ea ho bapisa moelelo oa moelelo ho ts'ebetso ea mefuta ea ASCII e ntlafalitsoe.
- Polokelo ea InnoDB e ntlafalitse ts'ebetso bakeng sa ts'ebetso ea ho kenya batch, presorting, le moaho oa index.
- Likotsi tse 5 li se li lokisitsoe, tseo lintlha tsa tsona li so kang li hlahisoa: CVE-2022-24052, CVE-2022-24051, CVE-2022-24050, CVE-2022-24048, CVE-2021-46659.
- Har'a liphetoho tsa tokollo ea teko ea MariaDB 10.8.1, re ka hlokomela ts'ebetsong ea li-index tse hlophisitsoeng ka tatellano e theohang, e ka ntlafatsang haholo ts'ebetso ea ORDER BY operations ha e lata ka tatellano ea morao. E kenyellelitsoe litlhaloso tsa IN, OUT, INOUT le IN OUT bakeng sa lits'ebetso tse bolokiloeng. Ho InnoDB, palo ea ts'ebetso ea ho ngola ha ts'ebetso ea ho rema lifate e fokotsehile (redo) e fokotsehile.
Source: opennet.ru