{"id":106843,"date":"2023-02-17T18:48:32","date_gmt":"2023-02-17T16:48:32","guid":{"rendered":"https:\/\/prohoster.info\/?p=106843"},"modified":"2023-02-19T13:38:52","modified_gmt":"2023-02-19T11:38:52","slug":"stabilnyj-vypusk-subd-mariadb-10-11","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sq\/blog\/news\/stabilnyj-vypusk-subd-mariadb-10-11","title":{"rendered":"Publikimi i q\u00ebndruesh\u00ebm i DBMS MariaDB 10.11","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>P\u00ebr her\u00eb t\u00eb par\u00eb \u00ebsht\u00eb publikuar versioni i stabilizuar i deg\u00ebs s\u00eb re t\u00eb databaz\u00ebs MariaDB 10.11 (10.11.2), e cila zhvillohet si nj\u00eb bran-shk\u00ebputje nga MySQL, duke ruajtur p\u00ebrputhshm\u00ebrin\u00eb prapa dhe duke ofruar integrim t\u00eb motor\u00ebve t\u00eb ruajtjes shtes\u00eb dhe mund\u00ebsi t\u00eb zgjeruara. Zhvillimi i MariaDB mb\u00ebshtetet nga organizata e pavarur MariaDB Foundation n\u00eb p\u00ebrputhje me procesin e hapur dhe transparent t\u00eb zhvillimit, q\u00eb nuk varet nga prodhues t\u00eb ve\u00e7ant\u00eb. MariaDB ofrohet n\u00eb vend t\u00eb MySQL n\u00eb shum\u00eb distribuime Linux (RHEL, SUSE, Fedora, openSUSE, Slackware, OpenMandriva, ROSA, Arch Linux, Debian) dhe \u00ebsht\u00eb p\u00ebrdorur n\u00eb projekte t\u00eb m\u00ebdha si Wikipedia, Google Cloud SQL dhe Nimbuzz.     <\/p>\n<p>N\u00eb t\u00eb nj\u00ebjt\u00ebn koh\u00eb, deg\u00eb 11.0 \u00ebsht\u00eb n\u00eb testim alfa, ku ofrohen p\u00ebrmir\u00ebsime t\u00eb r\u00ebnd\u00ebsishme dhe ndryshime q\u00eb shkelin p\u00ebrputhshm\u00ebrin\u00eb. Dega MariaDB 10.11 \u00ebsht\u00eb kategorikuar si l\u00ebshim me mb\u00ebshtetje afatgjat\u00eb dhe do t\u00eb shoq\u00ebrohet paralelisht me MariaDB 11.x deri n\u00eb shkurt 2028.      <\/p>\n<p>P\u00ebrmir\u00ebsimet kryesore n\u00eb MariaDB 10.11:  <\/p>\n<ul>\n<li class=\"l\"> Operacioni \u201cGRANT \u2026 TO PUBLIC\u201d \u00ebsht\u00eb realizuar, me t\u00eb cilin mund t\u00eb ofrohen privilegje t\u00eb caktuara menj\u00ebher\u00eb p\u00ebr t\u00eb gjith\u00eb p\u00ebrdoruesit n\u00eb <a class=\"wpil_keyword_link\" href=\"https:\/\/prohoster.info\/sq\/server\/dts-newyork\/\"   title=\"server\" data-wpil-keyword-link=\"linked\"  data-wpil-monitor-id=\"2747\">server<\/a>.\n<li class=\"l\"> Autoritetet SUPER dhe \u201cREAD ONLY ADMIN\u201d jan\u00eb ndar\u00eb \u2014 privilegji \u201cSUPER\u201d tani nuk p\u00ebrfshin t\u00eb drejtat \u201cREAD ONLY ADMIN\u201d (mund\u00ebsia e shkrimit, edhe n\u00ebse \u00ebsht\u00eb vendosur moda vet\u00ebm p\u00ebr lexim).\n<li class=\"l\"> N\u00eb modin e inspektimit \u201cANALYZE FORMAT=JSON\u201d \u00ebsht\u00eb siguruar shfaqja e koh\u00ebs s\u00eb kaluar nga optimizuesi i pyetjeve.\n<li class=\"l\"> Jan\u00eb zgjidhur problemet me performanc\u00ebn, t\u00eb dukshme gjat\u00eb leximit nga nj\u00eb tabel\u00eb me parametra t\u00eb skem\u00ebs s\u00eb ruajtjes, si dhe gjat\u00eb skanimit t\u00eb plot\u00eb t\u00eb tabelave me parametrat dhe procedurat p\u00ebr skem\u00ebn e ruajtjes.\n<li class=\"l\"> N\u00eb utilitarin mariadb-dump \u00ebsht\u00eb shtuar mb\u00ebshtetje p\u00ebr ruajtjen dhe rikthimin e t\u00eb dh\u00ebnave historike nga tabelat e versionuara.\n<li class=\"l\"> \u00cbsht\u00eb shtuar konfigurimi system_versioning_insert_history p\u00ebr t\u00eb menaxhuar mund\u00ebsin\u00eb e ndryshimit t\u00eb versioneve t\u00eb kaluara t\u00eb t\u00eb dh\u00ebnave n\u00eb tabelat e versionuara.\n<li class=\"l\"> \u00cbsht\u00eb lejuar ndryshimi i konfigurimeve innodb_write_io_threads dhe innodb_read_io_threads n\u00eb fluks pa nevoj\u00ebn e rinisjes. <a class=\"wpil_keyword_link\" href=\"https:\/\/prohoster.info\/sq\/server\/dts-los-angeles\/\"   title=\"server\u00eb\" data-wpil-keyword-link=\"linked\"  data-wpil-monitor-id=\"3890\">server\u00eb<\/a>.\n<li class=\"l\"> N\u00eb platform\u00ebn Windows, \u00ebsht\u00eb siguruar hyrja e administratoreve t\u00eb Windows si root n\u00eb MariaDB pa k\u00ebrkes\u00ebn e fjal\u00ebkalimit.\n<li class=\"l\"> Jan\u00eb rib\u00ebr\u00eb emrat e variablave log_slow_min_examined_row_limit (min_examined_row_limit), log_slow_query (slow_query_log), log_slow_query_file (slow_query_log_file) dhe log_slow_query_time (long_query_time).            <\/ul>\n<p>Burimi: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=58666\">opennet.ru<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u041e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\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.11 (10.11.2), \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. \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 \u0441 \u043e\u0442\u043a\u0440\u044b\u0442\u044b\u043c \u0438 \u043f\u0440\u043e\u0437\u0440\u0430\u0447\u043d\u044b\u043c \u043f\u0440\u043e\u0446\u0435\u0441\u0441\u043e\u043c \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u043a\u0438, \u043d\u0435 \u0437\u0430\u0432\u0438\u0441\u044f\u0449\u0438\u043c \u043e\u0442 \u043e\u0442\u0434\u0435\u043b\u044c\u043d\u044b\u0445 \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u0435\u0439. MariaDB \u043f\u043e\u0441\u0442\u0430\u0432\u043b\u044f\u0435\u0442\u0441\u044f \u0432\u043c\u0435\u0441\u0442\u043e MySQL \u0432\u043e \u043c\u043d\u043e\u0433\u0438\u0445 [&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-106843","post","type-post","status-publish","format-standard","hentry","category-news"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.2 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u041e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\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.11 (10.11.2), \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.\" \/>\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-11\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.2\" \/>\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.11 | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u041e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\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.11 (10.11.2), \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.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/sq\/blog\/news\/stabilnyj-vypusk-subd-mariadb-10-11\" \/>\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=\"2023-02-17T16:48:32+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2023-02-19T11:38:52+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.11 | ProHoster","description":"\u00cbsht\u00eb publikuar rrelease stabil i par\u00eb i deg\u00ebs s\u00eb re t\u00eb DBMS MariaDB 10.11 (10.11.2), ku zhvillohet nj\u00eb dege e MySQL, e cila ruan p\u00ebrputhshm\u00ebrin\u00eb mbrapa dhe p\u00ebrqendrohet n\u00eb integrimin e motor\u00ebve t\u00eb tjer\u00eb t\u00eb shtesave.","canonical_url":"https:\/\/prohoster.info\/sq\/blog\/news\/stabilnyj-vypusk-subd-mariadb-10-11","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.11 | ProHoster","og:description":"\u041e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\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.11 (10.11.2), \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.","og:url":"https:\/\/prohoster.info\/sq\/blog\/news\/stabilnyj-vypusk-subd-mariadb-10-11","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":"2023-02-17T16:48:32+00:00","article:modified_time":"2023-02-19T11:38:52+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"106843","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":"default","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":"2026-02-09 21:39:59","updated":"2026-02-22 15:31:11","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\/106843","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=106843"}],"version-history":[{"count":2,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/106843\/revisions"}],"predecessor-version":[{"id":162418,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/106843\/revisions\/162418"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media?parent=106843"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/categories?post=106843"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/tags?post=106843"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}