{"id":183402,"date":"2026-09-18T22:54:14","date_gmt":"2026-09-18T20:54:14","guid":{"rendered":"https:\/\/prohoster.info\/blog\/news\/stabilnyj-vypusk-subd-mariadb-13-0"},"modified":"2026-09-18T22:54:19","modified_gmt":"2026-09-18T20:54:19","slug":"mariadb-13-0-stable-release","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sq\/blog\/news\/mariadb-13-0-stable-release","title":{"rendered":"Versioni i q\u00ebndruesh\u00ebm i DBMS MariaDB 13.0","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"
L\u00ebshimi i versionit t\u00eb DBMS MariaDB 13.0.2, i cili \u00ebsht\u00eb shpallur si rrelease i par\u00eb stabil i deg\u00ebs 13.0. Dega MariaDB 13.0 i p\u00ebrket publikimeve t\u00eb p\u00ebrkohshme (rolling), t\u00eb cilat vazhdojn\u00eb zhvillimin e vazhduesh\u00ebm t\u00eb funksionaliteteve dhe q\u00eb do t\u00eb mbahen deri n\u00eb l\u00ebshimin stabil t\u00eb deg\u00ebs s\u00eb ardhshme. N\u00eb t\u00eb nj\u00ebjt\u00ebn koh\u00eb \u00ebsht\u00eb i disponuesh\u00ebm versioni MariaDB 13.1.1, i cili ka statusin e kandidat p\u00ebr l\u00ebshime. <\/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
Shtuar shprehja \u00abTYPE .. IS REF CURSOR\u00bb p\u00ebr t\u00eb shpallur nj\u00eb tip referenc\u00eb t\u00eb dh\u00ebnash p\u00ebr kursorin, i cili mund t\u00eb p\u00ebrdoret p\u00ebr t\u00eb kthyer rezultatin e nj\u00eb pyetje SQL ose nj\u00eb grup rreshtash nga procedurat e ruajtura dhe funksionet.\n
Ofruar mund\u00ebsia e p\u00ebrdorimit t\u00eb tipit RECORD n\u00eb parametrat e procedurave dhe n\u00eb vlerat q\u00eb kthehen nga funksionet.\n
Shtuar hintin e optimizuesit QB_NAME(), i cili lejon caktimin e nj\u00eb emri bllokut t\u00eb pyetjes p\u00ebr aplikimin e m\u00ebvonsh\u00ebm t\u00eb rregullave p\u00ebr optimizimin e k\u00ebtij blloku.\n
Shtuar mb\u00ebshtetje p\u00ebr komente ekzekutive \u00ab\/*!! ... *\/\u00bb, t\u00eb cilat zbulohen vet\u00ebm n\u00eb versionet m\u00eb t\u00eb vjetra se ato t\u00eb caktuara. P\u00ebr shembull, n\u00ebse n\u00eb versionin MariaDB 10.0 duhet t\u00eb ekzekutohet konstrukti \u00abCREATE OR REPLACE TABLE\u00bb, dhe n\u00eb versionet m\u00eb t\u00eb vjetra \u2014 \u00abCREATE TABLE IF NOT EXISTS\u00bb: CREATE \/*!100000 OR REPLACE *\/ TABLE \/*!!100000 IF NOT EXISTS *\/ t1 ...\n
N\u00eb tabel\u00ebn INFORMATION_SCHEMA.SYSTEM_VARIABLES \u00ebsht\u00eb shtuar kolona IS_DEPRECATED p\u00ebr t\u00eb sh\u00ebnuar variablat e vjetra, dhe n\u00eb tabelat INFORMATION_SCHEMA.STATISTICS dhe INFORMATION_SCHEMA.COLUMNS ka nj\u00eb kolona CREATE_OPTIONS me t\u00eb dh\u00ebna p\u00ebr mund\u00ebsit\u00eb specifike t\u00eb motor\u00ebve t\u00eb shprehjes \u00abCREATE TABLE\u00bb.\n
Ofruar mund\u00ebsia p\u00ebr t\u00eb konfiguruar formatin e koh\u00ebs, t\u00eb sh\u00ebnuar n\u00eb loget e plugin-it p\u00ebr auditim.\n
Siguruar ekzekutimin atomik t\u00eb operacionit \u00abCREATE OR REPLACE TABLE\u00bb.\n
Implementuar konstrukti \u00abUPDATE ... RETURNING\u00bb, i cili lejon p\u00ebrdit\u00ebsimin e rreshtave dhe menj\u00ebher\u00eb kthimin e vlerave t\u00eb tyre t\u00eb ndryshuara.\n
Shtuar variablin innodb_log_archive p\u00ebr t\u00eb aktivizuar modin e ruajtjes s\u00eb skedar\u00ebve me WAL-log (n\u00eb vend t\u00eb rikthimit ciklik t\u00eb logut n\u00eb nj\u00eb skedar, pas mbushjes, shkrimi kalon n\u00eb nj\u00eb skedar t\u00eb ri).\n
N\u00eb motorin MEMORY \u00ebsht\u00eb p\u00ebrshpejtuar funksionimi i indekseve (UNIQUE INDEX) p\u00ebr kolonat e tipit CHAR. <\/ul>\n