{"id":161781,"date":"2026-02-19T11:11:59","date_gmt":"2026-02-19T09:11:59","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/stabilnyj-vypusk-subd-mariadb-12-2"},"modified":"2026-02-19T11:11:59","modified_gmt":"2026-02-19T09:11:59","slug":"stabilnyj-vypusk-subd-mariadb-12-2","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sq\/blog\/novosti-interneta\/stabilnyj-vypusk-subd-mariadb-12-2","title":{"rendered":"L\u00ebshimi i q\u00ebndruesh\u00ebm i SGBD MariaDB 12.2","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"
\u00cbsht\u00eb publikuar versioni 12.2.2 i DBMS-s\u00eb MariaDB, q\u00eb sh\u00ebnohet si l\u00ebshohet i par\u00eb stabil i deg\u00ebs 12.2. Dega MariaDB 12.2 \u00ebsht\u00eb klasifikuar si nj\u00eb version nd\u00ebrmjet\u00ebs (rolling), vazhdon zhvillimin gradual t\u00eb funksionalitetit dhe z\u00ebvend\u00ebson deg\u00ebn MariaDB 12.1. N\u00eb t\u00eb nj\u00ebjt\u00ebn koh\u00eb \u00ebsht\u00eb publikuar versioni MariaDB 12.3.1 me nj\u00eb realizim t\u00eb ri t\u00eb binlog, q\u00eb ka statusin e kandidatit p\u00ebr l\u00ebshimet e ardhshme LTS. Dega MariaDB 12.2 do t\u00eb mb\u00ebshtetet deri n\u00eb formimin e versionit 12.3.2. <\/p>\n
Projekti MariaDB zhvillon nj\u00eb deg\u00eb nga MySQL, duke ruajtur p\u00ebrputhshm\u00ebrin\u00eb prapa dhe duke u dalluar nga integrimi i motor\u00ebve t\u00eb ruajtjes shtes\u00eb dhe mund\u00ebsive t\u00eb zgjeruara. Zhvillimi i MariaDB mb supervisohet nga organizata e pavarur MariaDB Foundation n\u00eb p\u00ebrputhje me nj\u00eb proces t\u00eb hapur dhe transparent zhvillimi, pa u mb\u00ebshtetur n\u00eb prodhues t\u00eb ve\u00e7ant\u00eb. MariaDB ofrohet n\u00eb vend t\u00eb MySQL n\u00eb shum\u00eb shp\u00ebrndarje t\u00eb 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 modalitetin e p\u00ebrputhshm\u00ebris\u00eb me DBMS-n\u00eb Oracle jan\u00eb realizuar funksionet TO_NUMBER (konvertimi i vargut n\u00eb num\u00ebr) dhe TRUNC (prerja e dat\u00ebs, p\u00ebr shembull, deri n\u00eb or\u00eb, dit\u00eb, muaj, vit).\n
Gjat\u00eb operacioneve t\u00eb bashkimit t\u00eb tabelave (JOIN) \u00ebsht\u00eb realizuar optimizimi q\u00eb merr parasysh unikates\u00ebn e rreshtave n\u00eb n\u00ebnpyetjet me shprehjen \u201eGROUP BY\u201c p\u00ebr nj\u00eb parashikim m\u00eb t\u00eb sakt\u00eb t\u00eb numrit t\u00eb rreshtave rezultues (out_rows) dhe p\u00ebr aplikimin korrekt t\u00eb indekseve.\n
Shtohen opsione t\u00eb reja p\u00ebr menaxhimin e optimizuesit ROWID_FILTER\/NO_ROWID_FILTER dhe INDEX_MERGE\/NO_INDEX_MERGE, si dhe mund\u00ebsia e specifikimit implicit t\u00eb emrave t\u00eb blloqeve n\u00eb pyetje (mund t\u00eb aplikohen me sakt\u00ebsi opsione optimizimi n\u00eb pjes\u00eb t\u00eb pyetjeve, duke iu referuar atyre me emrat \u201eselect#N\u201c, ku N \u2014 numri rendor i bllokut). P\u00ebr shembull: \u201eselect \/*+ JOIN_ORDER(@select#2) twenty,ten *\/ \u2026.\n
Kufizimet mbi nivelin e thell\u00ebsis\u00eb s\u00eb strukturave n\u00eb funksionet p\u00ebr pun\u00eb me JSON jan\u00eb hequr (u hoq kufiri JSON_DEPTH_LIMIT, i cili m\u00eb par\u00eb merrte vler\u00ebn 32).\n
Shtuar tabela TRIGGERED_UPDATE_COLUMNS n\u00eb skem\u00ebn INFORMATION_SCHEMA (INFORMATION_SCHEMA.TRIGGERED_UPDATE_COLUMNS), e cila tregon kolonat q\u00eb ndryshojn\u00eb kur aktivizohet nj\u00eb trigger.\n
N\u00eb tabel\u00ebn PARAMETERS n\u00eb skem\u00ebn INFORMATION_SCHEMA \u00ebsht\u00eb realizuar kolona PARAMETER_DEFAULT, e cila p\u00ebrmban vlerat e paracaktuara t\u00eb parametrave t\u00eb procedurave t\u00eb ruajtura.\n
\u00cbsht\u00eb implementuar mb\u00ebshtetje eksperimentale p\u00ebr shprehjen \u201eCREATE GLOBAL TEMPORARY TABLE\u201c p\u00ebr krijimin e tabelave globale t\u00eb p\u00ebrkohshme. T\u00eb tilla tabela p\u00ebrkohshme fshihen pas p\u00ebrfundimit t\u00eb sesionit dhe jan\u00eb t\u00eb dukshme p\u00ebr t\u00eb gjith\u00eb p\u00ebrdoruesit, por p\u00ebrmbajn\u00eb t\u00eb dh\u00ebna individuale p\u00ebr \u00e7do p\u00ebrdorues.\n
N\u00eb modin e prov\u00ebs, \u00ebsht\u00eb paraqitur mb\u00ebshtetje e p\u00ebrmir\u00ebsuar p\u00ebr replikimin midis tabelave me struktura t\u00eb ndryshme. <\/ul>\n