{"id":86434,"date":"2020-06-25T01:42:11","date_gmt":"2020-06-24T23:42:11","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/stabilnyj-vypusk-subd-mariadb-10-5"},"modified":"2020-06-25T01:42:11","modified_gmt":"2020-06-24T23:42:11","slug":"stabilnyj-vypusk-subd-mariadb-10-5","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sq\/blog\/news\/stabilnyj-vypusk-subd-mariadb-10-5","title":{"rendered":"L\u00ebshimi stabil i DBMS MariaDB 10.5","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Pas nj\u00eb vit zhvillimi dhe kat\u00ebr versione paraprake <noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.org\/mariadb-10-5-4-now-available\/\">\u00ebsht\u00eb p\u00ebrgatitur<\/a><\/noindex> l\u00ebshimi i par\u00eb stabil i deg\u00ebs s\u00eb re t\u00eb DBMS <noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/mariadb-1054-release-notes\/\">MariaDB 10.4<\/a><\/noindex>, n\u00eb kuad\u00ebr t\u00eb t\u00eb cil\u00ebs zhvillohet nj\u00eb dege nga MySQL, e cila ruan nd\u00ebrkompatibilitetin dhe   <noindex><a rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=39444#note\">dallohet<\/a><\/noindex> me integrimin e motor\u00ebve t\u00eb ruajtjes shtes\u00eb dhe mund\u00ebsive t\u00eb zgjeruara. Mb\u00ebshtetje p\u00ebr k\u00ebt\u00eb deg\u00eb do t\u00eb ofrohet p\u00ebr 5 vjet, deri n\u00eb qershor 2025. <\/p>\n<p>Zhvillimi i MariaDB mbik\u00ebqyret nga nj\u00eb organizat\u00eb e pavarur, Fondacioni MariaDB, n\u00eb p\u00ebrputhje me nj\u00eb proces t\u00eb plot\u00eb t\u00eb hapur dhe transparent zhvillimi q\u00eb nuk varet nga prodhues t\u00eb ve\u00e7ant\u00eb. MariaDB ofrohet si z\u00ebvend\u00ebsim p\u00ebr MySQL n\u00eb shum\u00eb shp\u00ebrndarje Linux (RHEL, SUSE, Fedora, openSUSE, Slackware, OpenMandriva, ROSA, Arch Linux, Debian) dhe \u00ebsht\u00eb implementuar n\u00eb projekte t\u00eb m\u00ebdha si <noindex><a rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=36759\">Wikipedia<\/a><\/noindex>, <noindex><a rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=37905\">Google Cloud SQL<\/a><\/noindex> dhe <noindex><a rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=36506\">Nimbuzz<\/a><\/noindex>.<\/p>\n<p>\u00c7el\u00ebsore <noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/mdb-1054-rn\/\">p\u00ebrmir\u00ebsime<\/a><\/noindex> <noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/changes-improvements-in-mariadb-105\/\">MariaDB 10.5<\/a><\/noindex>:\n<\/p>\n<ul>\n<li class=\"l\"> Shtuar motorin e ruajtjes <noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/s3-storage-engine\/\">S3<\/a><\/noindex>, q\u00eb lejon vendosjen e tabelave MariaDB n\u00eb Amazon S3 ose ndonj\u00eb ruajt\u00ebs tjet\u00ebr publik ose privat t\u00eb cloud q\u00eb mb\u00ebshtet API S3. Mb\u00ebshtetet vendosja n\u00eb S3 e tabelave si normale, ashtu edhe t\u00eb ndara (particionuara). Kur tabela t\u00eb ndara vendosen n\u00eb cloud, ato mund t\u00eb p\u00ebrdoren drejtp\u00ebrdrejt gjithashtu nga nj\u00eb server tjet\u00ebr q\u00eb ka akses n\u00eb ruajtjen S3.\n<li class=\"l\"> Shtuar motorin e ruajtjes <noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/mariadb-columnstore\/\">ColumnStore<\/a><\/noindex>, i cili ruan t\u00eb dh\u00ebnat n\u00eb lidhje me kolonat dhe p\u00ebrdor <noindex><a rel=\"nofollow\" href=\"https:\/\/ru.wikipedia.org\/wiki\/%D0%9C%D0%B0%D1%81%D1%81%D0%BE%D0%B2%D0%BE-%D0%BF%D0%B0%D1%80%D0%B0%D0%BB%D0%BB%D0%B5%D0%BB%D1%8C%D0%BD%D0%B0%D1%8F_%D0%B0%D1%80%D1%85%D0%B8%D1%82%D0%B5%D0%BA%D1%82%D1%83%D1%80%D0%B0\">arkitektur\u00ebn e distribuar masiv-paralel.<\/a><\/noindex> Ky motor bazohet n\u00eb zhvillimet e ruajtjes MySQL <noindex><a rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=25267\">InfiniDB<\/a><\/noindex> dhe \u00ebsht\u00eb i dizenjuar p\u00ebr t\u00eb organizuar p\u00ebrpunimin dhe ekzekutimin e pyetjeve analitike mbi grupe t\u00eb m\u00ebdha t\u00eb dh\u00ebnash (Data Warehouse).<br \/>\nColumnStore ruan t\u00eb dh\u00ebnat jo rresht pas rreshti, por me ndarje sipas kolonave, duke lejuar optimizimin e ekzekutimit t\u00eb grumbullimit t\u00eb kolonave nga baza e t\u00eb dh\u00ebnave t\u00eb m\u00ebdha, duke p\u00ebrfshir\u00eb petabayte t\u00eb dh\u00ebnash. Mb\u00ebshtetet shkall\u00ebzimi linear, ruajtja e t\u00eb dh\u00ebnave n\u00eb form\u00eb t\u00eb kompresuar, ndarje vertikale dhe horizontale, ekzekutimi efikas i pyetjeve konkurruese.<\/p>\n<li class=\"l\"> T\u00eb gjitha skedar\u00ebt ekzekutiv\u00eb q\u00eb fillojn\u00eb me fjal\u00ebn &#171;mysql&#187; jan\u00eb rinomuar duke p\u00ebrdorur fjal\u00ebn &#171;mariadb&#187;. Emrat e vjet\u00ebr jan\u00eb ruajtur si lidhje simbolike.\n<li class=\"l\"> Shtuar nj\u00eb tip t\u00eb ri t\u00eb dh\u00ebnash <noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/inet6\/\">INET6<\/a><\/noindex> p\u00ebr ruajtjen e adresave IPv6.\n<li class=\"l\"> \u00cbsht\u00eb p\u00ebrfunduar puna p\u00ebr ndarjen e privilegjeve n\u00eb komponent\u00eb m\u00eb t\u00eb vegj\u00ebl. N\u00eb vend t\u00eb privilegjeve t\u00eb p\u00ebrgjithshme SUPER, \u00ebsht\u00eb propozuar nj\u00eb seri privilegjesh selektive &#171;BINLOG ADMIN&#187;.<br \/>\n    &#171;BINLOG REPLAY&#187;.<br \/>\n    &#171;CONNECTION ADMIN&#187;.<br \/>\n    &#171;FEDERATED ADMIN&#187;.<br \/>\n    &#171;READ_ONLY ADMIN&#187;.<br \/>\n    &#171;REPLICATION MASTER ADMIN&#187;.<br \/>\n    &#171;REPLICATION SLAVE ADMIN&#187; dhe<br \/>\n    &#171;SET USER&#187;. <\/p>\n<li class=\"l\"> Privilegji &#171;REPLICATION CLIENT&#187; \u00ebsht\u00eb rinovuar n\u00eb &#171;BINLOG MONITOR&#187;, nd\u00ebrsa shprehja &#171;SHOW MASTER STATUS&#187; \u00ebsht\u00eb rinovuar n\u00eb &#171;SHOW BINLOG STATUS&#187;. Rinovimi sqaron sjelljen dhe nuk \u00ebsht\u00eb i lidhur me politik\u00ebn e korrekt\u00ebsis\u00eb, projekti nuk heq dor\u00eb nga terminologjia master\/slave dhe madje ka shtuar privilegje t\u00eb reja &#171;MASTER ADMIN&#187; dhe &#171;SLAVE ADMIN&#187;. N\u00eb k\u00ebt\u00eb kontekst, n\u00eb shprehjet SQL \u00ebsht\u00eb shtuar nj\u00eb \u00e7el\u00ebs i ri &#171;REPLICA&#187;, q\u00eb \u00ebsht\u00eb sinonim me &#171;SLAVE&#187;.\n<li class=\"l\"> P\u00ebr disa shprehje jan\u00eb ndryshuar privilegjet e nevojshme p\u00ebr ekzekutimin e tyre. &#171;SHOW BINLOG EVENTS&#187; tani k\u00ebrkon privilegjin &#171;BINLOG MONITOR&#187; n\u00eb vend t\u00eb &#171;REPLICATION SLAVE&#187;, &#171;SHOW SLAVE HOSTS&#187; k\u00ebrkon privilegjin &#171;REPLICATION MASTER ADMIN&#187; n\u00eb vend t\u00eb &#171;REPLICATION SLAVE&#187;, &#171;SHOW SLAVE STATUS&#187; k\u00ebrkon privilegjet &#171;REPLICATION SLAVE ADMIN&#187; ose &#171;SUPER&#187; n\u00eb vend t\u00eb &#171;REPLICATION CLIENT&#187;, &#171;SHOW RELAYLOG EVENTS&#187; k\u00ebrkon privilegjin &#171;REPLICATION SLAVE ADMIN&#187; n\u00eb vend t\u00eb &#171;REPLICATION SLAVE&#187;.\n<li class=\"l\"> Jan\u00eb shtuar konstrukte &#171;<noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/insertreturning\/\">INSERT &#8230; RETURNING<\/a><\/noindex>&#187; dhe &#171;<noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/replacereturning\/\">REPLACE &#8230; RETURNING<\/a><\/noindex>&#171;, q\u00eb kthejn\u00eb nj\u00eb list\u00eb t\u00eb rekordeve t\u00eb futura\/z\u00ebvend\u00ebsuara n\u00eb nj\u00eb form\u00eb, sikur vlerat t\u00eb ishin kthyer duke p\u00ebrdorur shprehjen SELECT (n\u00eb p\u00ebrputhje me &#171;DELETE &#8230; RETURNING&#187;).\n<p>   INSERT INTO t2 VALUES (1,&#8217;Dog&#8217;),(2,&#8217;Lion&#8217;),(3,&#8217;Tiger&#8217;),(4,&#8217;Leopard&#8217;)<br \/>\n   RETURNING id2,id2+id2,id2&#038;id2,id2||id2;<br \/>\n   +&#8212;&#8212;+&#8212;&#8212;&#8212;+&#8212;&#8212;&#8212;+&#8212;&#8212;&#8212;-+<br \/>\n   | id2 | id2+id2 | id2&#038;id2 | id2||id2 |<br \/>\n   +&#8212;&#8212;+&#8212;&#8212;&#8212;+&#8212;&#8212;&#8212;+&#8212;&#8212;&#8212;-+<br \/>\n   |   1 |       2 |       1 |        1 |<br \/>\n   |   2 |       4 |       2 |        1 |<br \/>\n   |   3 |       6 |       3 |        1 |<br \/>\n   |   4 |       8 |       4 |        1 |<br \/>\n   +&#8212;&#8212;+&#8212;&#8212;&#8212;+&#8212;&#8212;&#8212;+&#8212;&#8212;&#8212;-+<\/p>\n<li class=\"l\"> Jan\u00eb shtuar shprehje &#171;<noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/except\/\">EXCEPT ALL<\/a><\/noindex>&#187; dhe &#171;<noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/intersect\/\">INTERSECT ALL<\/a><\/noindex>&#187; p\u00ebr p\u00ebrjashtimin\/shtimin e rezultatit me nj\u00eb grup t\u00eb caktuar vlerash.\n<li class=\"l\"> Ka dal\u00eb mund\u00ebsia e dh\u00ebnies s\u00eb komenteve brenda blloqeve &#171;CREATE DATABASE&#187; dhe &#171;ALTER DATABASE&#187;.\n<li class=\"l\"> Jan\u00eb shtuar konstrukta p\u00ebr rinovimin e indekseve dhe kolonave &#171;<noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/alter-table\/#rename-indexkey\">ALTER TABLE &#8230; RENAME INDEX \/ KEY<\/a><\/noindex>&#187; dhe &#171;<noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/alter-table\/#rename-column\">ALTER TABLE &#8230; RENAME COLUMN<\/a><\/noindex>&#171;.\n<li class=\"l\"> N\u00eb operacionin &#171;ALTER TABLE&#187; dhe &#171;RENAME TABLE&#187; \u00ebsht\u00eb shtuar mb\u00ebshtetje p\u00ebr kushtin &#171;IF EXISTS&#187; p\u00ebr t\u00eb kryer operacionin vet\u00ebm n\u00ebse tabela ekziston;\n<li class=\"l\"> P\u00ebr indekset n\u00eb &#171;CREATE TABLE&#187; \u00ebsht\u00eb realizuar atributi &#171;<noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/create-table\/#visible-index-option\">VISIBLE<\/a><\/noindex>&#171;.\n<li class=\"l\"> \u00cbsht\u00eb shtuar shprehja &#171;CYCLE&#187; p\u00ebr identifikimin e cikleve rekursive. <noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/common-table-expressions\/\">CTE<\/a><\/noindex>.\n<li class=\"l\"> Funksionet e reja <noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/json_arrayagg\/\">JSON_ARRAYAGG<\/a><\/noindex> dhe <noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/json_objectagg\/\">JSON_OBJECTAGG<\/a><\/noindex> p\u00ebr t\u00eb kthyer nj\u00eb array ose objekt JSON me vlerat e kolon\u00ebs s\u00eb caktuar.\n<li class=\"l\"> Shtuar tabela informative t\u00eb ndihm\u00ebs (THREAD_POOL_GROUPS, THREAD_POOL_QUEUES, THREAD_POOL_STATS dhe THREAD_POOL_WAITS) p\u00ebr grupin e thread-\u00ebve (thread_pool).\n<li class=\"l\"> Shprehja ANALYZE \u00ebsht\u00eb zgjeruar me tregimin e koh\u00ebs q\u00eb shpenzohet p\u00ebr verifikimin e blokut WHERE dhe p\u00ebrfundimin e operacioneve t\u00eb ndihm\u00ebs.\n<li class=\"l\"> N\u00eb optimizuesin e p\u00ebrpunimit t\u00eb intervaleve jan\u00eb marr\u00eb parasysh shenjat &#171;IS NOT NULL&#187;.\n<li class=\"l\"> N\u00eb m\u00ebnyr\u00eb t\u00eb r\u00ebnd\u00ebsishme \u00ebsht\u00eb reduktuar madh\u00ebsia e skedar\u00ebve t\u00eb p\u00ebrkohsh\u00ebm q\u00eb p\u00ebrdoren gjat\u00eb renditjes me tipet VARCHAR, CHAR dhe BLOB.\n<li class=\"l\"> N\u00eb <noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/binary-log\/\">logu binar<\/a><\/noindex>, e p\u00ebrdorur p\u00ebr organizimin e replikimit, jan\u00eb shtuar fusha t\u00eb reja me metadatat, duke p\u00ebrfshir\u00eb \u00c7elsin Primar, Emrin e Kolon\u00ebs, Setin e Karaktereve dhe Llojin e Gjeometris\u00eb. N\u00eb utilitarin mariadb-binlog dhe komandat &#171;SHOW BINLOG EVENTS&#187; dhe &#171;SHOW RELAYLOG EVENTS&#187; \u00ebsht\u00eb garantuar shfaqja e flamujve t\u00eb replikimit.\n<li class=\"l\"> Konstruksioni <noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/drop-table\/\">DROP TABLE<\/a><\/noindex> tani \u00ebsht\u00eb besuesh\u00ebm <noindex><a rel=\"nofollow\" href=\"https:\/\/jira.mariadb.org\/browse\/MDEV-11412\">t\u00ebrheq<\/a><\/noindex> tabelat, q\u00eb mbeten n\u00eb motorin e ruajtjes, edhe n\u00eb munges\u00eb t\u00eb skedareve &#171;.frm&#187; ose &#171;.par&#187;.\n<li class=\"l\"> \u00cbsht\u00eb realizuar nj\u00eb varianti i p\u00ebrshpejtuar harduerik i funksionit crc32() p\u00ebr CPU AMD64, ARMv8 dhe POWER 8.\n<li class=\"l\"> Jan\u00eb ndryshuar disa cil\u00ebsime t\u00eb paracaktuara. Parametri innodb_encryption_threads \u00ebsht\u00eb rritur n\u00eb 255, dhe vlera max_sort_length \u00ebsht\u00eb rritur nga 4 n\u00eb 8.\n<li class=\"l\"> Jan\u00eb prezantuar shum\u00eb optimizime t\u00eb performanc\u00ebs s\u00eb motorit InnoDB.\n<li class=\"l\"> N\u00eb mekanizmin e replikimit multi-master me sinkronizim Galera \u00ebsht\u00eb shtuar mb\u00ebshtetje e plot\u00eb  <noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/gtid\/\">GTID<\/a><\/noindex> (Global Transaction ID), identifikuesve t\u00eb transaksioneve t\u00eb p\u00ebrbashk\u00ebta p\u00ebr t\u00eb gjitha nyllat e klasht\u00ebr.\n<li class=\"l\"> \u00cbsht\u00eb realizuar kalimi n\u00eb deg\u00ebn e re t\u00eb bibliotek\u00ebs <noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/pcre\/\">PCRE2<\/a><\/noindex> (Perl Compatible Regular Expressions), n\u00eb vend t\u00eb seris\u00eb klasike PCRE 8.x.\n<li class=\"l\"> Jan\u00eb propozuar versione t\u00eb reja t\u00eb lidhjeve p\u00ebr lidhjen me DBMS MariaDB dhe MySQL nga programet n\u00eb gjuh\u00ebt Python dhe C: <noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/mariadb-connector-python-100-release-notes\/\">MariaDB Connector\/Python 1.0.0<\/a><\/noindex> dhe  <noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/mariadb-connector-c-319-release-notes\/\">MariaDB Connector\/C 3.1.9<\/a><\/noindex>. Lidhja p\u00ebr Python p\u00ebrputhet me Python DB API 2.0, \u00ebsht\u00eb shkruar n\u00eb gjuh\u00ebn C dhe p\u00ebrdor bibliotek\u00ebn Connector\/C p\u00ebr lidhjen me serverin.\n<\/ul>\n<p><noindex><a rel=\"nofollow\" name=\"link\"><\/a><\/noindex><\/p>\n<p>Burimi: <a \ncontent=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=53225\">opennet.ru<\/a><\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u041f\u043e\u0441\u043b\u0435 \u0433\u043e\u0434\u0430 \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u043a\u0438 \u0438 \u0447\u0435\u0442\u044b\u0440\u0451\u0445 \u043f\u0440\u0435\u0434\u0432\u0430\u0440\u0438\u0442\u0435\u043b\u044c\u043d\u044b\u0445 \u0432\u044b\u043f\u0443\u0441\u043a\u043e\u0432 \u043f\u043e\u0434\u0433\u043e\u0442\u043e\u0432\u043b\u0435\u043d \u043f\u0435\u0440\u0432\u044b\u0439 \u0441\u0442\u0430\u0431\u0438\u043b\u044c\u043d\u044b\u0439 \u0440\u0435\u043b\u0438\u0437 \u043d\u043e\u0432\u043e\u0439 \u0432\u0435\u0442\u043a\u0438 \u0421\u0423\u0411\u0414 MariaDB 10.4, \u0432 \u0440\u0430\u043c\u043a\u0430\u0445 \u043a\u043e\u0442\u043e\u0440\u043e\u0439 \u0440\u0430\u0437\u0432\u0438\u0432\u0430\u0435\u0442\u0441\u044f \u043e\u0442\u0432\u0435\u0442\u0432\u043b\u0435\u043d\u0438\u0435 \u043e\u0442 MySQL, \u0441\u043e\u0445\u0440\u0430\u043d\u044f\u044e\u0449\u0435\u0435 \u043e\u0431\u0440\u0430\u0442\u043d\u0443\u044e \u0441\u043e\u0432\u043c\u0435\u0441\u0442\u0438\u043c\u043e\u0441\u0442\u044c \u0438 \u043e\u0442\u043b\u0438\u0447\u0430\u044e\u0449\u0435\u0435\u0441\u044f \u0438\u043d\u0442\u0435\u0433\u0440\u0430\u0446\u0438\u0435\u0439 \u0434\u043e\u043f\u043e\u043b\u043d\u0438\u0442\u0435\u043b\u044c\u043d\u044b\u0445 \u0434\u0432\u0438\u0436\u043a\u043e\u0432 \u0445\u0440\u0430\u043d\u0435\u043d\u0438\u044f \u0438 \u0440\u0430\u0441\u0448\u0438\u0440\u0435\u043d\u043d\u044b\u0445 \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e\u0441\u0442\u0435\u0439. \u041f\u043e\u0434\u0434\u0435\u0440\u0436\u043a\u0430 \u043d\u043e\u0432\u043e\u0439 \u0432\u0435\u0442\u043a\u0438 \u0431\u0443\u0434\u0435\u0442 \u043e\u0441\u0443\u0449\u0435\u0441\u0442\u0432\u043b\u044f\u0442\u044c\u0441\u044f 5 \u043b\u0435\u0442, \u0434\u043e \u0438\u044e\u043d\u044f 2025 \u0433\u043e\u0434\u0430. \u0420\u0430\u0437\u0432\u0438\u0442\u0438\u0435 MariaDB \u043a\u0443\u0440\u0438\u0440\u0443\u0435\u0442 \u043d\u0435\u0437\u0430\u0432\u0438\u0441\u0438\u043c\u0430\u044f \u043e\u0440\u0433\u0430\u043d\u0438\u0437\u0430\u0446\u0438\u044f MariaDB Foundation \u0432 \u0441\u043e\u043e\u0442\u0432\u0435\u0442\u0441\u0442\u0432\u0438\u0438 [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[702],"tags":[],"class_list":["post-86434","post","type-post","status-publish","format-standard","hentry","category-news"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.0.1 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u041f\u043e\u0441\u043b\u0435 \u0433\u043e\u0434\u0430 \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u043a\u0438 \u0438 \u0447\u0435\u0442\u044b\u0440\u0451\u0445 \u043f\u0440\u0435\u0434\u0432\u0430\u0440\u0438\u0442\u0435\u043b\u044c\u043d\u044b\u0445 \u0432\u044b\u043f\u0443\u0441\u043a\u043e\u0432 \u043f\u043e\u0434\u0433\u043e\u0442\u043e\u0432\u043b\u0435\u043d \u043f\u0435\u0440\u0432\u044b\u0439 \u0441\u0442\u0430\u0431\u0438\u043b\u044c\u043d\u044b\u0439 \u0440\u0435\u043b\u0438\u0437 \u043d\u043e\u0432\u043e\u0439 \u0432\u0435\u0442\u043a\u0438 \u0421\u0423\u0411\u0414.\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Yuri Gagarin\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/prohoster.info\/sq\/blog\/news\/stabilnyj-vypusk-subd-mariadb-10-5\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.0.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"sq_AL\" \/>\n\t\t<meta property=\"og:site_name\" content=\"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"\ud83e\udd47\u0421\u0442\u0430\u0431\u0438\u043b\u044c\u043d\u044b\u0439 \u0432\u044b\u043f\u0443\u0441\u043a \u0421\u0423\u0411\u0414 MariaDB 10.5 | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u041f\u043e\u0441\u043b\u0435 \u0433\u043e\u0434\u0430 \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u043a\u0438 \u0438 \u0447\u0435\u0442\u044b\u0440\u0451\u0445 \u043f\u0440\u0435\u0434\u0432\u0430\u0440\u0438\u0442\u0435\u043b\u044c\u043d\u044b\u0445 \u0432\u044b\u043f\u0443\u0441\u043a\u043e\u0432 \u043f\u043e\u0434\u0433\u043e\u0442\u043e\u0432\u043b\u0435\u043d \u043f\u0435\u0440\u0432\u044b\u0439 \u0441\u0442\u0430\u0431\u0438\u043b\u044c\u043d\u044b\u0439 \u0440\u0435\u043b\u0438\u0437 \u043d\u043e\u0432\u043e\u0439 \u0432\u0435\u0442\u043a\u0438 \u0421\u0423\u0411\u0414.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/sq\/blog\/news\/stabilnyj-vypusk-subd-mariadb-10-5\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:width\" content=\"350\" \/>\n\t\t<meta property=\"og:image:height\" content=\"350\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2020-06-24T23:42:11+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2020-06-24T23:42:11+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"\ud83e\udd47L\u00ebshimi stabil i DBMS MariaDB 10.5 | ProHoster","description":"Pas nj\u00eb vit zhvillimi dhe kat\u00ebr versione paraprake, \u00ebsht\u00eb p\u00ebrgatitur versioni i par\u00eb stabil i deg\u00ebs s\u00eb re t\u00eb DBMS.","canonical_url":"https:\/\/prohoster.info\/sq\/blog\/news\/stabilnyj-vypusk-subd-mariadb-10-5","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"sq_AL","og:site_name":"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b","og:type":"article","og:title":"\ud83e\udd47\u0421\u0442\u0430\u0431\u0438\u043b\u044c\u043d\u044b\u0439 \u0432\u044b\u043f\u0443\u0441\u043a \u0421\u0423\u0411\u0414 MariaDB 10.5 | ProHoster","og:description":"\u041f\u043e\u0441\u043b\u0435 \u0433\u043e\u0434\u0430 \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u043a\u0438 \u0438 \u0447\u0435\u0442\u044b\u0440\u0451\u0445 \u043f\u0440\u0435\u0434\u0432\u0430\u0440\u0438\u0442\u0435\u043b\u044c\u043d\u044b\u0445 \u0432\u044b\u043f\u0443\u0441\u043a\u043e\u0432 \u043f\u043e\u0434\u0433\u043e\u0442\u043e\u0432\u043b\u0435\u043d \u043f\u0435\u0440\u0432\u044b\u0439 \u0441\u0442\u0430\u0431\u0438\u043b\u044c\u043d\u044b\u0439 \u0440\u0435\u043b\u0438\u0437 \u043d\u043e\u0432\u043e\u0439 \u0432\u0435\u0442\u043a\u0438 \u0421\u0423\u0411\u0414.","og:url":"https:\/\/prohoster.info\/sq\/blog\/news\/stabilnyj-vypusk-subd-mariadb-10-5","og:image":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:secure_url":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:width":350,"og:image:height":350,"article:published_time":"2020-06-24T23:42:11+00:00","article:modified_time":"2020-06-24T23:42:11+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"86434","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"seo_analyzer_scan_date":null,"breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-02-28 14:15:25","updated":"2022-10-03 01:36:14","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/86434","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/comments?post=86434"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/86434\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media?parent=86434"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/categories?post=86434"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/tags?post=86434"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}