Ka mor'a selemo sa nts'etsopele le litokollo tse tharo tsa pele, tokollo ea pele e tsitsitseng ea lekala le lecha la MariaDB 10.6 DBMS e hatisitsoe, moo lekala la MySQL le ntseng le ntlafatsoa le bolokang ho lumellana ka morao 'me le khetholloa ka ho kopanngoa ha lienjineri tse eketsehileng tsa polokelo. le bokgoni bo tsoetseng pele. Ho tla fanoa ka tšehetso bakeng sa lekala le lecha ka lilemo tse 5, ho fihlela ka July 2026.
Nts'etsopele ea MariaDB e okametsoe ke Mokhatlo o ikemetseng oa MariaDB, ho latela ts'ebetso ea ntlafatso e bulehileng ka ho felletseng e ikemetseng ho barekisi ka bomong. MariaDB e fanoa e le sebaka sa MySQL libakeng tse ngata tsa Linux (RHEL, SUSE, Fedora, openSUSE, Slackware, OpenMandriva, ROSA, Arch Linux, Debian) 'me e kentsoe tšebetsong mererong e meholo joalo ka Wikipedia, Google Cloud SQL le Nimbuzz.
Lintlafatso tsa bohlokoa ho MariaDB 10.6:
- Tiisetso ya atomic ya dipolelwana “CREATE TABLE|VIEW|SEQUENCE|TRIGGER”, “ALTER TABLE|SEQUENCE”, “RENAME TABLE|TABLES”, “DROP TABLE|VIEW|VIEW|TRIGGER|DATABASE” e netefaditswe (mohlomong polelo ke ho phetheloa ka botlalo kapa ntho e ngoe le e ngoe e khutlisetsoa boemong ba eona ba pele). Tabeng ea ts'ebetso ea "DROP TABLE" e hlakolang litafole tse 'maloa ka nako e le' ngoe, atomicity e netefatsoa boemong ba tafole ka 'ngoe. Sepheo sa phetoho ke ho netefatsa botšepehi ha seva se senyeha nakong ea ts'ebetso. Nakong e fetileng, ka mor'a ho senyeha, litafole le lifaele tsa nakoana li ne li ka sala, ho lumellana ha litafole ka lienjineng tsa polokelo le lifaele tsa frm ho ne ho ka senyeha, 'me litafole ka bomong li ne li ka lula li sa boleloa ka mabitso ha litafole tse' maloa li rehoa ka nako e le 'ngoe. Botšepehi bo tiisetsoa ka ho boloka tlaleho ea boemo ba ho hlaphoheloa, tsela e ka khethoang ka khetho e ncha "-log-ddl-recovery=file" (ddl-recovery.log by default).
- Kaho ea "KHETHA ... OFFSET ... FETCH" e hlalositsoeng ho SQL 2008 standard e kentsoe ts'ebetsong, e leng se u lumellang hore u bontše palo e itseng ea mela e qalang ho tloha ho offset e boletsoeng, ka bokhoni ba ho sebelisa parameter ea "KA TIES" hokela boleng bo bong bo latelang. Mohlala, poleloana e reng "KHETHA i HO t1 ORDER BY i ASC OFFSET 1 ROWS FUTA MELA E 3 EA PELE KA MATHAI" e fapana le kaho "KHETHA i HO TSA t1 ORDER BY i ASC LIMIT 3 OFFSET 1" ka ho ntša ntho e 'ngoe hape mohatleng. (ho e-na le mela e 3 4 e tla hlahisoa).
- Bakeng sa enjene ea InnoDB, syntax ea "KHETHA ... SKIP LOCKED" e kentsoe ts'ebetsong, e leng se u lumellang hore u se kenyeletse mela eo senotlolo se ke keng sa behoa bakeng sa eona ("LOCK IN SHARE MODE" kapa "FOR UPDATE").
- Bokhoni ba ho hlokomoloha li-index bo kentsoe ts'ebetsong (ho MySQL 8, ts'ebetso ena e bitsoa "invisible indexes"). Ho tšoaea index ho hlokomolohuoa ho etsoa ho sebelisoa folakha e IGNORED polelong ea ALTER TABLE, ka mor'a moo index e lula e bonahala le ho nchafatsoa, empa ha e sebelisoe ke optimizer.
- E kentse tšebetso ea JSON_TABLE() ho fetolela data ea JSON hore e be sebopeho sa kamano. Ka mohlala, tokomane ea JSON e ka fetoloa hore e sebelisoe moelelong oa tafole, e ka hlalosoang ka hare ho FROM block ka polelo ea KHETHA.
- Tšebelisano e ntlafetseng le Oracle DBMS: Tšehetso e ekelitsoeng bakeng sa lipotso tse sa tsejoeng ka hare ho FROM block. Mohaho oa MINUS o kentsoe tšebetsong (e lekanang le EXCEPT). E kentse ADD_MONTHS(), TO_CHAR(), SYS_GUID() le ROWNUM() mesebetsi.
- Ka enjene ea InnoDB, ho kenya litafole tse se nang letho ho potlakisitsoe. Mofuta oa khoele oa COMPRESSED o behiloe ho mokhoa oa ho bala feela ka ho sa feleng. Sekema sa SYS_TABLESPACES se nkile sebaka sa SYS_DATAFILES mme se bonahatsa ka kotloloho boemo ba sistimi ea lifaele. Tšehetso ea ho ngola ea botsoa e fanoa bakeng sa sebaka sa nakoana sa tafole. Tšehetso bakeng sa algorithm ea khale ea checksum, e neng e bolokiloe bakeng sa ho lumellana le MariaDB 5.5, e khaotsoe.
- Ka mokhoa oa ho pheta-pheta, boholo ba boleng ba paramethara ea master_host bo eketsehile ho tloha ho litlhaku tse 60 ho isa ho tse 255, 'me master_user ho ea ho 128. binlog_expire_logs_seconds variable e kentsoe ho lokisa nako ea ho felloa ke nako ea "binary log" ka metsotsoana (pele, nako ea ho tsosolosa e ne e le teng. e khethoa feela ka matsatsi ho ea ka expire_logs_days variables).
- The Galera synchronous multi-master replication mechanism e sebelisa wsrep_mode e feto-fetohang ho lokisa liparamente tsa API tsa WSREP (Ngola Set REPlication). E lumelletsoe phetoho ea Galera ho tloha likhokahanong tse sa ngolisoang ho ea ho TLS ntle le ho emisa sehlopha.
- Sekema sa sys-schema se kentsoe tšebetsong, se nang le pokello ea maikutlo, mesebetsi le mekhoa ea ho sekaseka ts'ebetso ea database.
- Litafole tsa lits'ebeletso tse kentsoeng bakeng sa ho sekaseka ts'ebetso ea phetisetso.
- Maikutlo a INFORMATION_SCHEMA.KEYWORDS le INFORMATION_SCHEMA.SQL_FUNCTIONS a kentsoe lethathamong la litafole tsa tlhahisoleseling, ho bonts'a lethathamo la mantsoe a bohlokoa a fumanehang le mesebetsi.
- Lipolokelo tsa TokuDB le CassandraSE li tlositsoe.
- Khouto ea utf8 e tlositsoe ho boemeli ba li-byte tse 'ne utf8mb4 (U+0000..U+10FFFF) ho ea ho utf8mb3 ea li-byte tse tharo (e akaretsa mefuta ea Unicode U+0000..U+FFFF).
- Ts'ehetso e ekelitsoeng bakeng sa ts'ebetso ea socket ho systemd.
- Plugin ea GSSAPI e kentse tšehetso bakeng sa mabitso a lihlopha tsa Active Directory le li-SID.
- E kentse tlhahlobo ea boteng ba faele ea tlhophiso $MARIADB_HOME/my.cnf ho kenyelletsa $MYSQL_HOME/my.cnf.
- Liphetoho tsa sistimi e ncha binlog_expire_logs_seconds, innodb_deadlock_report, innodb_read_only_compressed, wsrep_mode le Innodb_buffer_pool_pages_lru_freed li kentsoe tšebetsong.
Source: opennet.ru