{"id":103277,"date":"2022-02-10T09:36:47","date_gmt":"2022-02-10T07:36:47","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/stabilnyj-vypusk-subd-mariadb-10-7"},"modified":"2022-02-10T09:36:47","modified_gmt":"2022-02-10T07:36:47","slug":"stabilnyj-vypusk-subd-mariadb-10-7","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sq\/blog\/news\/stabilnyj-vypusk-subd-mariadb-10-7","title":{"rendered":"L\u00ebshimi stabil i DBMS MariaDB 10.7","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"
Pas 6 muajve zhvillimi, u publikua l\u00ebshimi i par\u00eb stabil i deg\u00ebs s\u00eb re t\u00eb DBMS MariaDB 10.7 (10.7.2), n\u00eb kuad\u00ebr t\u00eb t\u00eb cilit zhvillohet nj\u00eb deg\u00eb nga MySQL, q\u00eb ruan p\u00ebrkrahjen p\u00ebr versionet e m\u00ebparshme dhe ndodhet n\u00eb integrimin e motor\u00ebve t\u00eb ruajtjes t\u00eb shtuar dhe mund\u00ebsive t\u00eb p\u00ebrparuara. Zhvillimi i MariaDB mbik\u00ebqyret nga organizata e pavarur MariaDB Foundation n\u00eb p\u00ebrputhje me nj\u00eb proces zhvillimi t\u00ebr\u00ebsisht t\u00eb hapur dhe transparent, q\u00eb nuk varen nga prodhues t\u00eb ve\u00e7ant\u00eb. MariaDB ofrohet n\u00eb vend t\u00eb MySQL n\u00eb shum\u00eb distribucione Linux (RHEL, SUSE, Fedora, openSUSE, Slackware, OpenMandriva, ROSA, Arch Linux, Debian) dhe \u00ebsht\u00eb implementuar n\u00eb projekte t\u00eb m\u00ebdha, si Wikipedia, Google Cloud SQL dhe Nimbuzz. <\/p>\n
N\u00eb t\u00eb nj\u00ebjt\u00ebn koh\u00eb, u formua l\u00ebshimi i par\u00eb testues i deg\u00ebs s\u00eb r\u00ebnd\u00ebsishme MariaDB 10.8.1 dhe p\u00ebrdit\u00ebsimet korrigjuese 10.6.6, 10.5.14, 10.4.23, 10.3.33 dhe 10.2.42. L\u00ebshimi 10.7.2 ishte i pari pas kalimit t\u00eb projektit n\u00eb nj\u00eb model t\u00eb ri t\u00eb formimit t\u00eb l\u00ebshimeve, q\u00eb n\u00ebnkupton shkurtimin e periudh\u00ebs s\u00eb mb\u00ebshtetjes nga 5 vjet n\u00eb 1 vit dhe kalimin n\u00eb formimin e l\u00ebshimeve t\u00eb r\u00ebnd\u00ebsishme jo nj\u00eb her\u00eb n\u00eb vit, por nj\u00eb her\u00eb n\u00eb tremujor. <\/p>\n
P\u00ebrmir\u00ebsimet kryesore t\u00eb MariaDB 10.7: <\/p>\n
\n
Shtuar nj\u00eb tip t\u00eb ri t\u00eb dh\u00ebnash UUID, i destinuar p\u00ebr ruajtjen e identifikuesve unik\u00eb 128-bit\u00eb (Identifikuesit Unik\u00eb Nd\u00ebrkomb\u00ebtar\u00eb).\n
Propozuar funksione t\u00eb reja p\u00ebr p\u00ebrpunimin e t\u00eb dh\u00ebnave n\u00eb formatin JSON: JSON_EQUALS() p\u00ebr krahasimin e identitetit t\u00eb dy dokumenteve JSON dhe JSON_NORMALIZE() p\u00ebr konvertimin e objekteve JSON n\u00eb form\u00ebn e p\u00ebrshtatshme p\u00ebr operacione krahasimi (perfshin renditjen e \u00e7el\u00ebsave dhe heqjen e hap\u00ebsirave).\n
Shtesa e funksionit NATURAL_SORT_KEY() p\u00ebr renditjen e vargjeve duke marr\u00eb parasysh vlerat numerike (p\u00ebr shembull, vargu \u00abv10\u00bb pas renditjes do t\u00eb vendoset pas vargut \u00abv9\u00bb).\n
Shtesa e funksionit SFORMAT() p\u00ebr formatimin e rast\u00ebsish\u00ebm t\u00eb vargjeve \u2014 n\u00eb hyrje japet nj\u00eb varg me komanda formatimi dhe nj\u00eb list\u00eb vlerash p\u00ebr z\u00ebvend\u00ebsim (p\u00ebr shembull, \u2018SFORMAT(\u00abP\u00ebrgjigjja \u00ebsht\u00eb {}.\u00bb , 42)\u2019).\n
P\u00ebrmir\u00ebsuar informimi p\u00ebr gabimet n\u00eb k\u00ebrkesat INSERT, q\u00eb shtojn\u00eb t\u00eb dh\u00ebna n\u00eb disa rreshta (komanda GET DIAGNOSTICS tani tregon pron\u00ebn ROW_NUMBER, q\u00eb tregon numrin e rreshtit me gabim).\n
N\u00eb p\u00ebrb\u00ebrje \u00ebsht\u00eb p\u00ebrfshir\u00eb nj\u00eb plugin i ri p\u00ebr kontrollin e fjal\u00ebkalimeve password_reuse_check, q\u00eb lejon kufizimin e rip\u00ebrdorimit t\u00eb fjal\u00ebkalimeve nga nj\u00eb p\u00ebrdorues (kontrolli, q\u00eb fjal\u00ebkalimi i ri nuk p\u00ebrputhet me fjal\u00ebkalimet e p\u00ebrdorura brenda koh\u00ebs, e cila p\u00ebrcaktohet nga parametri password_reuse_check_interval).\n
Shtesa e mb\u00ebshtetjes p\u00ebr shprehjet \u00abALTER TABLE ... CONVERT PARTITION .. TO TABLE\u00bb dhe \u00abALTER TABLE ... CONVERT TABLE ... TO PARTITION\u00bb p\u00ebr t\u00eb konvertuar nj\u00eb seksion (partition) n\u00eb nj\u00eb tabel\u00eb dhe anasjelltas.\n
P\u00ebr MariaDB Galera Cluster n\u00eb PROCESSLIST jan\u00eb implementuar gjendje t\u00eb reja \u00abwaiting to execute in isolation\u00bb, \u00abwaiting for TOI DDL\u00bb, \u00abwaiting for flow control\u00bb dhe \u00abwaiting for certification\u00bb.\n
N\u00eb optimizator \u00ebsht\u00eb shtuar nj\u00eb paramet\u00ebr t\u00eb ri \u00abreorder\u00bb. P\u00ebr vargjet me shum\u00eb byte \u00ebsht\u00eb p\u00ebrmir\u00ebsuar performanca n\u00eb p\u00ebrputhshm\u00ebrin\u00eb me kuptimin e simboleve n\u00eb operacionet me intervale ASCII.\n
N\u00eb ruajtjen InnoDB \u00ebsht\u00eb p\u00ebrmir\u00ebsuar performanca e ekzekutimit t\u00eb operacioneve t\u00eb futjes s\u00eb t\u00eb dh\u00ebnave n\u00eb m\u00ebnyr\u00eb grupore, si dhe e sortimit paraprak dhe nd\u00ebrtimit t\u00eb indekseve.\n
Eliminuar 5 vulnerabilitete, detajet p\u00ebr t\u00eb cilat ende nuk jan\u00eb zbuluar: CVE-2022-24052, CVE-2022-24051, CVE-2022-24050, CVE-2022-24048, CVE-2021-46659.\n
Nga ndryshimet n\u00eb versionin testues t\u00eb MariaDB 10.8.1, mund t\u00eb p\u00ebrmenden realizimi i indekseve t\u00eb renditura n\u00eb r\u00ebnie, q\u00eb ndihmon n\u00eb p\u00ebrmir\u00ebsimin e duksh\u00ebm t\u00eb performanc\u00ebs s\u00eb operacioneve ORDER BY gjat\u00eb marrjes s\u00eb t\u00eb dh\u00ebnave n\u00eb rend t\u00eb kund\u00ebrt. P\u00ebr funksionet e ruajtura jan\u00eb shtuar specifikator\u00ebt IN, OUT, INOUT dhe IN OUT. N\u00eb InnoDB \u00ebsht\u00eb reduktuar numri i operacioneve t\u00eb shkrimit gjat\u00eb regjistrimit t\u00eb log-ut t\u00eb anullimit (redo). <\/ul>\n