Ukukhishwa okuzinzile kwe-MariaDB 10.6

Ngemva konyaka wentuthuko kanye nokukhishwa kokuqala okuthathu, ukukhululwa kokuqala okuzinzile kwegatsha elisha le-MariaDB 10.6 DBMS kushicilelwe, lapho igatsha le-MySQL lithuthukiswa eligcina ukuhambisana emuva futhi lihlukaniswa nokuhlanganiswa kwezinjini zokulondoloza ezengeziwe. kanye namakhono athuthukile. Ukusekelwa kwegatsha elisha kuzonikezwa iminyaka emi-5, kuze kube uJulayi 2026.

Ukuthuthukiswa kweMariaDB kulawulwa yiMariaDB Foundation ezimele, kulandela inqubo yokuthuthukiswa evulekile ngokuphelele futhi esobala ngaphandle kwabathengisi ngabanye. IMariaDB ithunyelwa njengesithasiselo se-MySQL ekusatshalalisweni okuningi. Linux (RHEL, SUSE, Fedora, openSUSE, Slackware, OpenMandriva, ROSA, Arch Linux, Debian) futhi isetshenziswe kumaphrojekthi amakhulu njenge-Wikipedia, i-Google Cloud SQL kanye ne-Nimbuzz.

Ukuthuthukiswa Okubalulekile ku-MariaDB 10.6:

• Ukwenziwa kwezitatimende ezithi "CREATE TABLE|VIEW|SEQUENCE|TRIGGER", "ALTER TABLE|SEQUENCE", "RENAME TABLE|TABLES", "DROP TABLE|VIEW|VIEW|TRIGGER|DATABASE" kuqinisekiswa ukuthi ziyi-athomu (noma ngabe isitatimende siqediwe ngokugcwele, noma konke kubuyiselwa esimweni saso sokuqala). Endabeni yemisebenzi ethi "DROP TABLE" esusa amatafula amaningi ngesikhathi esisodwa, i-atomicity iqinisekiswa ezingeni lethebula ngalinye ngalinye. Inhloso yoshintsho ukuqinisekisa ukuvumelana uma kwenzeka ukuphahlazeka. iseva Ngesikhathi sokusebenza. Ngaphambilini, amatafula namafayela esikhashana ayengasala ngemva kokuphahlazeka, ukuvumelanisa ithebula ezinjinini zokugcina kanye namafayela e-FRM kungaphazanyiswa, futhi amatafula ngamanye ayengasala engaqanjwanga kabusha lapho kubhalwa kabusha amatafula amaningi ngesikhathi esisodwa. Ubuqotho buqinisekiswa ngokugcina ilogi yokutakula, indlela engachazwa ngayo kusetshenziswa inketho entsha ethi "--log-ddl-recovery=file" (ddl-recovery.log ngokuzenzakalelayo).
• Ukwakhiwa kwe-“KHETHA ... OFFSET ... FETCH” okuchazwe ezingeni le-SQL 2008 sekuqalisiwe, okukuvumela ukuthi ubonise inombolo ethile yemigqa eqala ku-offset ethile, enekhono lokusebenzisa ipharamitha ethi “NGOKUTHATHA” ukuze namathisela elinye inani elilandelayo. Isibonelo, isisho esithi "KHETHA i KUSUKA t1 I-ORDER BY i-ASC OFFSET 1 IMILA LANDA IMIQA ENGU-3 YOKUQALA ENOTHATHA" yehluka ekwakhiweni kokuthi "KHETHA i KUSUKA KU-t1 ORDER BY i ASC LIMIT 3 OFFSET 1" ngokukhipha enye into emsileni. (esikhundleni semigqa engu-3 4 izophuma).
• Enjinini ye-InnoDB, i-syntax ethi “KHETHA ... YEQA KAYIHLILE” isetshenzisiwe, ekuvumela ukuthi ungafaki imigqa lapho ukukhiya okungenakusethwa khona (“KHIPHA NGEMODI YOKWABELANA” noma “NGOKUBUYEKEZWA”).
• Ikhono lokuziba izinkomba seliqalisiwe (ku-MySQL 8, lokhu kusebenza kubizwa ngokuthi “izinkomba ezingabonakali”). Ukumaka inkomba okufanele uzibe kwenziwa kusetshenziswa ifulegi elithi IGNORED kusitatimende esithi ALTER TABLE, ngemva kwalokho inkomba ihlala ibonakala futhi ibuyekezwa, kodwa ayisetshenziswa isilungiseleli.
• Kwengezwe umsebenzi we-JSON_TABLE() ukuze kuguqulwe idatha ye-JSON ibe ifomu lokusebenzelana. Isibonelo, idokhumenti ye-JSON ingashintshwa ukuze isetshenziswe kumongo wethebula, elingacaciswa ngaphakathi kwebhulokhi ethi FROM esitatimendeni esithi KHETHA.
• Ukusebenzisana okuthuthukisiwe ne-Oracle DBMS: Usekelo olungeziwe lwemibuzo engaphansi engaziwa ngaphakathi kwebhulokhi ethi FROM. Ukwakhiwa kwe-MINUS sekuqalisiwe (okulingana nokuthi NGAPHANDLE). Kwengezwe imisebenzi engu-ADD_MONTHS(), TO_CHAR(), SYS_GUID() kanye ne-ROWNUM() imisebenzi.
• Enjinini ye-InnoDB, ukufakwa kumatafula angenalutho kusheshisiwe. Ifomethi yeyunithi yezinhlamvu COMPRESSED isethwe kumodi yokufunda kuphela ngokuzenzakalelayo. Uhlelo lwe-SYS_TABLESPACES luthathe indawo ye-SYS_DATAFILES futhi lubonisa ngokuqondile isimo ohlelweni lwefayela. Ukusekelwa kokubhala okuvilaphayo kunikezwa isikhala setafula lesikhashana. Ukusekelwa kwe-algorithm ye-checksum endala, eyagcinwa ukuze ihambisane ne-MariaDB 5.5, inqanyuliwe.
• Kuhlelo lokuphindaphinda, usayizi wevelu yepharamitha ye-master_host unyusiwe ukusuka kuzinhlamvu ezingu-60 kuya kwezingu-255, futhi master_user ukuya ku-128. Okuguquguqukayo kwe-binlog_expire_logs_seconds kungeziwe ukuze kulungiselelwe isikhathi sokuphelelwa yisikhathi kwelogi kanambambili ngemizuzwana (ngaphambilini, isikhathi sokusetha kabusha besi kunqunywa kuphela ngezinsuku ngokusebenzisa okuguquguqukayo_kwezinsuku_zokuphelelwa yisikhathi).
• I-Galera synchronous multi-master replication mechanism isebenzisa okuguquguqukayo kwe-wsrep_mode ukuze ilungiselele amapharamitha we-API we-WSREP (Write Set REPlication). Kuvunyelwe ukuguqulwa kwe-Galera kusukela kwezokuxhumana okungabethelwe kuya ku-TLS ngaphandle kokumisa iqoqo.
• I-schema ye-sys-schema isiqalisiwe, equkethe iqoqo lemibono, imisebenzi kanye nezinqubo zokuhlaziya ukusebenza kwedathabheyisi.
• Kungezwe amathebula esevisi okuhlaziya ukusebenza kokuphindaphinda.
• Ukubuka kwe-INFORMATION_SCHEMA.KEYWORDS kanye ne-INFORMATION_SCHEMA.SQL_FUNCTIONS kwengezwe kusethi yamathebula olwazi, okubonisa uhlu lwamagama angukhiye atholakalayo nemisebenzi.
• Izinqolobane ze-TokuDB ne-CassandraSE zisusiwe.
• Umbhalo wekhodi we-utf8 ususiwe ekumeleleni amabhayithi amane utf8mb4 (U+0000..U+10FFFF) kwayiswa ku-utf8mb3 yamabhayithi amathathu (ihlanganisa ububanzi be-Unicode U+0000..U+FFFF).
• Kungezwe ukusekelwa kokuvula isokhethi ku-systemd.
• I-plugin ye-GSSAPI yengeze usekelo lwamagama weqembu le-Active Directory nama-SID.
• Kwengezwe isheke lokuba khona kwefayela lokucushwa elingu-$MARIADB_HOME/my.cnf ngaphezu kwe-$MYSQL_HOME/my.cnf.
• Izinguquko zesistimu entsha binlog_expire_logs_seconds, innodb_deadlock_report, innodb_read_only_compressed, wsrep_mode kanye ne-Innodb_buffer_pool_pages_lru_freed zisetshenzisiwe.

Source: opennet.ru