{"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\/news\/stabilnyj-vypusk-subd-mariadb-12-2","title":{"rendered":"L\u00ebshimi i q\u00ebndruesh\u00ebm i DBMS MariaDB 12.2","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"
\u00cbsht\u00eb publikuar versioni 12.2.2 i DBMS-s\u00eb MariaDB, i cili \u00ebsht\u00eb sh\u00ebnuar si publikimi i par\u00eb stabil i deg\u00ebs 12.2. Dega MariaDB 12.2 \u00ebsht\u00eb klasifikuar si nj\u00eb version nd\u00ebrmjet\u00ebs (rolling), duke vazhduar 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 edicioni 12.3.1 i MariaDB me nj\u00eb implementim t\u00eb ri t\u00eb binlog, i cili ka statusin e kandidatit p\u00ebr versionet e ardhshme t\u00eb deg\u00ebs 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\u00ebzim t\u00eb MySQL, q\u00eb ruan p\u00ebrputhshm\u00ebrin\u00eb prapavepruese dhe dallohet p\u00ebr integrimin e engine-ve shtes\u00eb t\u00eb ruajtjes dhe funksionaliteteve t\u00eb avancuara. Zhvillimi i MariaDB mbik\u00ebqyret nga organizata e pavarur MariaDB Foundation, n\u00eb p\u00ebrputhje me nj\u00eb proces zhvillimi t\u00eb hapur dhe transparent, t\u00eb pavarur nga prodhues t\u00eb ve\u00e7ant\u00eb. MariaDB shp\u00ebrndahet si z\u00ebvend\u00ebsim p\u00ebr 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 modalitetin e pajtueshm\u00ebris\u00eb me DBMS-n\u00eb Oracle jan\u00eb implementuar funksionet TO_NUMBER (transformimi i nj\u00eb stringu n\u00eb num\u00ebr) dhe TRUNC (prerja e dat\u00ebs, p\u00ebr shembull, deri n\u00eb or\u00eb, dit\u00eb, muaj, vit).\n
N\u00eb p\u00ebrmbushjen e operacioneve t\u00eb bashkimit t\u00eb tabelave (JOIN) \u00ebsht\u00eb realizuar optimizimi q\u00eb merr parasysh unikates\u00ebn e rreshtave n\u00eb n\u00ebnk\u00ebrkesat me shprehjen \"GROUP BY\" p\u00ebr parashikimin m\u00eb t\u00eb sakt\u00eb t\u00eb numrit t\u00eb rreshtave t\u00eb rezultatit (out_rows) dhe aplikimin e sakt\u00eb t\u00eb indekseve.\n
Jan\u00eb shtuar mund\u00ebsi t\u00eb reja p\u00ebr menaxhimin e optimizuesit ROWID_FILTER\/NO_ROWID_FILTER dhe INDEX_MERGE\/NO_INDEX_MERGE, si dhe mund\u00ebsia e caktimit t\u00eb emrave t\u00eb blloqeve n\u00eb k\u00ebrkesa (mund t\u00eb aplikoni n\u00eb m\u00ebnyr\u00eb t\u00eb pik\u00ebsuar opsionet e optimizimit p\u00ebr pjes\u00ebt e k\u00ebrkesave duke iu referuar emrave \"select#N\", ku N \u00ebsht\u00eb numri rendor i bllokut). P\u00ebr shembull: \"select \/*+ JOIN_ORDER(@select#2\" twenty,ten) *\/ ...\".\n
Jan\u00eb hequr kufizimet mbi nivelin e thell\u00ebsis\u00eb s\u00eb strukturave n\u00eb funksionet p\u00ebr pun\u00ebn me JSON (kufiri JSON_DEPTH_LIMIT, i cili m\u00eb par\u00eb merrte vler\u00ebn 32, \u00ebsht\u00eb hequr).\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 realizuar mb\u00ebshtetje eksperimentale p\u00ebr shprehjen \"CREATE GLOBAL TEMPORARY TABLE\" p\u00ebr krijimin e tabelave globale 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 nj\u00eb m\u00ebnyr\u00eb testuese, \u00ebsht\u00eb ofruar mb\u00ebshtetje e p\u00ebrmir\u00ebsuar p\u00ebr replikimin mes tabelave q\u00eb kan\u00eb struktura t\u00eb ndryshme. <\/ul>\n