{"id":106286,"date":"2022-12-28T15:36:45","date_gmt":"2022-12-28T13:36:45","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/predstavlena-novaya-znachitelnaya-vetka-subd-mariadb-11"},"modified":"2022-12-28T15:36:45","modified_gmt":"2022-12-28T13:36:45","slug":"predstavlena-novaya-znachitelnaya-vetka-subd-mariadb-11","status":"publish","type":"post","link":"https:\/\/prohoster.info\/ro\/blog\/news\/predstavlena-novaya-znachitelnaya-vetka-subd-mariadb-11","title":{"rendered":"A fost lansat\u0103 o nou\u0103 ramur\u0103 semnificativ\u0103 a SGBD-ului MariaDB 11","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Dup\u0103 10 ani de la \u00eenfiin\u021barea ramurii 10.x, a fost lansat\u0103 versiunea SGBD MariaDB 11.0.0, care aduce c\u00e2teva \u00eembun\u0103t\u0103\u021biri semnificative \u0219i modific\u0103ri care afecteaz\u0103 compatibilitatea. Ramura are \u00een prezent calitate de versiune alfa \u0219i va fi gata pentru aplica\u021bii \u00een produc\u021bie dup\u0103 stabilizare. Formarea urm\u0103toarei ramuri semnificative MariaDB 12, care va con\u021bine modific\u0103ri ce afecteaz\u0103 compatibilitatea, este a\u0219teptat\u0103 nu mai devreme de 10 ani (\u00een 2032).    <\/p>\n<p>Proiectul MariaDB dezvolt\u0103 o ramur\u0103 de la MySQL, care p\u0103streaz\u0103 compatibilitatea \u00eenapoi \u00eent\u00e2i \u0219i se distinge prin integrarea de motoare de stocare suplimentare \u0219i capacit\u0103\u021bi extinse. Dezvoltarea MariaDB este supervizat\u0103 de organiza\u021bia independent\u0103 MariaDB Foundation, conform unui proces de dezvoltare deschis \u0219i transparent, care nu depinde de anumi\u021bi furnizori. SGBD MariaDB este livrat \u00een locul MySQL \u00een multe distribu\u021bii Linux (RHEL, SUSE, Fedora, openSUSE, Slackware, OpenMandriva, ROSA, Arch Linux, Debian) \u0219i este implementat \u00een proiecte mari, cum ar fi Wikipedia, Google Cloud SQL \u0219i Nimbuzz.    <\/p>\n<p>\u00cembun\u0103t\u0103\u021birea cheie din ramura MariaDB 11 este trecerea optimizatorului de interog\u0103ri la un nou model de greutate (cost model), care asigur\u0103 o prezicere mai precis\u0103 a greut\u0103\u021bilor fiec\u0103rui plan de execu\u021bie a interog\u0103rii. De\u0219i noul model ajut\u0103 la eliminarea unor puncte de \u00eengustare a performan\u021bei, nu este exclus ca acesta s\u0103 nu fie optim \u00een toate scenariile \u0219i este posibil s\u0103 \u00eencetineasc\u0103 anumite interog\u0103ri, a\u0219a c\u0103 utilizatorilor li se recomand\u0103 s\u0103 participe la testare \u0219i s\u0103 informeze dezvoltatorii \u00een caz de probleme.    <\/p>\n<p>Modela anterioar\u0103 era potrivit\u0103 pentru determinarea indicelui optim, dar avea probleme cu aplicabilitatea opera\u021biunilor de scanare a tabelului, scanare a indicelui sau extragerea pe intervale. \u00cen noua model\u0103, aceast\u0103 deficien\u021b\u0103 a fost eliminat\u0103 prin schimbarea greut\u0103\u021bii de baz\u0103 a opera\u021biunilor cu motorul de stocare. Atunci c\u00e2nd se evalueaz\u0103 performan\u021ba opera\u021biunilor care depind de viteza de acces la disc, cum ar fi scanarea secven\u021bial\u0103 a \u00eenregistr\u0103rilor, se presupune acum c\u0103 datele sunt stocate pe un SSD, care asigur\u0103 o vitez\u0103 de citire de 400MB pe secund\u0103. De asemenea, au fost ajustate \u0219i alte parametru de greutate ale optimizatorului, ceea ce a permis, de exemplu, utilizarea indicilor pentru opera\u021biunile \u201eORDER BY\/GROUP BY\u201d \u00een subinterog\u0103ri \u0219i a accelerat lucrul cu tabele foarte mici.    <\/p>\n<p>Se remarc\u0103 faptul c\u0103 noua model\u0103 de greutate va permite selectarea unui plan de execu\u021bie a interog\u0103rilor mai optim \u00een urm\u0103toarele situa\u021bii:  <\/p>\n<ul>\n<li class=\"l\"> C\u00e2nd se utilizeaz\u0103 interog\u0103ri care acoper\u0103 mai mult de 2 tabele.\n<li class=\"l\"> C\u00e2nd exist\u0103 indici care con\u021bin un num\u0103r mare de valori identice.\n<li class=\"l\"> C\u00e2nd se utilizeaz\u0103 intervale care acoper\u0103 mai mult de 10% din tabel.\n<li class=\"l\"> C\u00e2nd sunt prezente interog\u0103ri complexe, \u00een care nu toate coloanele utilizate sunt indexate.\n<li class=\"l\"> C\u00e2nd se utilizeaz\u0103 interog\u0103ri care implic\u0103 diferite motoare de stocare (de exemplu, c\u00e2nd \u00eentr-o singur\u0103 interogare exist\u0103 referin\u021be la tabele \u00een motoarele InnoDB \u0219i Memory).\n<li class=\"l\"> C\u00e2nd se utilizeaz\u0103 FORCE INDEX pentru a \u00eembun\u0103t\u0103\u021bi planul interog\u0103rii.\n<li class=\"l\"> Atunci c\u00e2nd planul interog\u0103rii se degradeaz\u0103 \u00een cazul utiliz\u0103rii \u201eANALYZE TABLE\u201c.\n<li class=\"l\"> C\u00e2nd interogarea acoper\u0103 un num\u0103r mare de tabele derivate (un num\u0103r mare de SELECT \u00eenglobate).\n<li class=\"l\"> C\u00e2nd se utilizeaz\u0103 expresii ORDER BY sau GROUP BY care sunt acoperite de indici.  <\/ul>\n<p>Principalele \u00eenc\u0103lc\u0103ri ale compatibilit\u0103\u021bii \u00een ramura MariaDB 11:  <\/p>\n<ul>\n<li class=\"l\"> Permisiunile SUPER nu mai permit efectuarea ac\u021biunilor pentru care sunt disponibile privilegii separate. De exemplu, pentru a schimba formatul jurnalelor binare, vor fi necesare drepturile BINLOG ADMIN.\n<li class=\"l\"> Implementarea bufferului de modific\u0103ri \u00een InnoDB a fost eliminat\u0103.\n<li class=\"l\"> innodb_flush_method \u0219i innodb_file_per_table au fost declarate \u00eenvechite.\n<li class=\"l\"> Suportul pentru numele mysql* a fost declarat \u00eenvechit.\n<li class=\"l\"> Setarea parametrului explicit_defaults_for_timestamp la 0 a fost declarat\u0103 \u00eenvechit\u0103.\n<li class=\"l\"> Leg\u0103turile simbolice pentru compatibilitate cu MySQL au fost mutate \u00eentr-un pachet separat.\n<li class=\"l\"> Valoarea parametrului innodb_undo_tablespaces a fost schimbat\u0103 \u00een mod implicit la 3.    <\/ul>\n<\/ul>\n<p>Sursa: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=58399\">opennet.ro<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u0421\u043f\u0443\u0441\u0442\u044f 10 \u043b\u0435\u0442 \u0441 \u043c\u043e\u043c\u0435\u043d\u0442\u0430 \u043e\u0441\u043d\u043e\u0432\u0430\u043d\u0438\u044f \u0432\u0435\u0442\u043a\u0438 10.x \u043f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u0435\u043d \u0432\u044b\u043f\u0443\u0441\u043a \u0421\u0423\u0411\u0414 MariaDB 11.0.0, \u0432 \u043a\u043e\u0442\u043e\u0440\u043e\u043c \u043f\u0440\u0435\u0434\u043b\u043e\u0436\u0435\u043d\u043e \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u043e \u0437\u043d\u0430\u0447\u0438\u0442\u0435\u043b\u044c\u043d\u044b\u0445 \u0443\u043b\u0443\u0447\u0448\u0435\u043d\u0438\u0439 \u0438 \u0438\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u0439, \u043d\u0430\u0440\u0443\u0448\u0430\u044e\u0449\u0438\u0445 \u0441\u043e\u0432\u043c\u0435\u0441\u0442\u0438\u043c\u043e\u0441\u0442\u044c. \u0412\u0435\u0442\u043a\u0430 \u043f\u043e\u043a\u0430 \u0438\u043c\u0435\u0435\u0442 \u043a\u0430\u0447\u0435\u0441\u0442\u0432\u043e \u0430\u043b\u044c\u0444\u0430-\u0432\u044b\u043f\u0443\u0441\u043a\u0430 \u0438 \u0441\u0442\u0430\u043d\u0435\u0442 \u0433\u043e\u0442\u043e\u0432\u043e\u0439 \u0434\u043b\u044f \u0440\u0430\u0431\u043e\u0447\u0438\u0445 \u043f\u0440\u0438\u043c\u0435\u043d\u0435\u043d\u0438\u0439 \u043f\u043e\u0441\u043b\u0435 \u043f\u0440\u043e\u0432\u0435\u0434\u0435\u043d\u0438\u044f \u0441\u0442\u0430\u0431\u0438\u043b\u0438\u0437\u0430\u0446\u0438\u0438. \u0424\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435 \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0435\u0439 \u0437\u043d\u0430\u0447\u0438\u0442\u0435\u043b\u044c\u043d\u043e\u0439 \u0432\u0435\u0442\u043a\u0438 MariaDB 12, \u0441\u043e\u0434\u0435\u0440\u0436\u0430\u0449\u0435\u0439 \u0438\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u044f, \u043d\u0430\u0440\u0443\u0448\u0430\u044e\u0449\u0438\u0435 \u0441\u043e\u0432\u043c\u0435\u0441\u0442\u0438\u043c\u043e\u0441\u0442\u044c, \u043e\u0436\u0438\u0434\u0430\u0435\u0442\u0441\u044f \u043d\u0435 \u0440\u0430\u043d\u0435\u0435 \u0447\u0435\u043c \u0447\u0435\u0440\u0435\u0437 10 \u043b\u0435\u0442 (\u0432 [&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-106286","post","type-post","status-publish","format-standard","hentry","category-news"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.2.1 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u0421\u043f\u0443\u0441\u0442\u044f 10 \u043b\u0435\u0442 \u0441 \u043c\u043e\u043c\u0435\u043d\u0442\u0430 \u043e\u0441\u043d\u043e\u0432\u0430\u043d\u0438\u044f \u0432\u0435\u0442\u043a\u0438 10.x \u043f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u0435\u043d \u0432\u044b\u043f\u0443\u0441\u043a \u0421\u0423\u0411\u0414 MariaDB 11.0.0, \u0432 \u043a\u043e\u0442\u043e\u0440\u043e\u043c \u043f\u0440\u0435\u0434\u043b\u043e\u0436\u0435\u043d\u043e \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u043e \u0437\u043d\u0430\u0447\u0438\u0442\u0435\u043b\u044c\u043d\u044b\u0445 \u0443\u043b\u0443\u0447\u0448\u0435\u043d\u0438\u0439 \u0438 \u0438\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u0439, \u043d\u0430\u0440\u0443\u0448\u0430\u044e\u0449\u0438\u0445 \u0441\u043e\u0432\u043c\u0435\u0441\u0442\u0438\u043c\u043e\u0441\u0442\u044c.\" \/>\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\/ro\/blog\/news\/predstavlena-novaya-znachitelnaya-vetka-subd-mariadb-11\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.2.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"ro_RO\" \/>\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\u041f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u0435\u043d\u0430 \u043d\u043e\u0432\u0430\u044f \u0437\u043d\u0430\u0447\u0438\u0442\u0435\u043b\u044c\u043d\u0430\u044f \u0432\u0435\u0442\u043a\u0430 \u0421\u0423\u0411\u0414 MariaDB 11 | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u0421\u043f\u0443\u0441\u0442\u044f 10 \u043b\u0435\u0442 \u0441 \u043c\u043e\u043c\u0435\u043d\u0442\u0430 \u043e\u0441\u043d\u043e\u0432\u0430\u043d\u0438\u044f \u0432\u0435\u0442\u043a\u0438 10.x \u043f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u0435\u043d \u0432\u044b\u043f\u0443\u0441\u043a \u0421\u0423\u0411\u0414 MariaDB 11.0.0, \u0432 \u043a\u043e\u0442\u043e\u0440\u043e\u043c \u043f\u0440\u0435\u0434\u043b\u043e\u0436\u0435\u043d\u043e \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u043e \u0437\u043d\u0430\u0447\u0438\u0442\u0435\u043b\u044c\u043d\u044b\u0445 \u0443\u043b\u0443\u0447\u0448\u0435\u043d\u0438\u0439 \u0438 \u0438\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u0439, \u043d\u0430\u0440\u0443\u0448\u0430\u044e\u0449\u0438\u0445 \u0441\u043e\u0432\u043c\u0435\u0441\u0442\u0438\u043c\u043e\u0441\u0442\u044c.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/ro\/blog\/news\/predstavlena-novaya-znachitelnaya-vetka-subd-mariadb-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=\"2022-12-28T13:36:45+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2022-12-28T13:36:45+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\udd47A fost lansat\u0103 o nou\u0103 ramur\u0103 semnificativ\u0103 a SGBD MariaDB 11 | ProHoster","description":"Dup\u0103 10 ani de la \u00eenfiin\u021barea ramurii 10.x, a fost lansat release-ul SGBD MariaDB 11.0.0, care aduce c\u00e2teva \u00eembun\u0103t\u0103\u021biri semnificative \u0219i modific\u0103ri care afecteaz\u0103 compatibilitatea.","canonical_url":"https:\/\/prohoster.info\/ro\/blog\/news\/predstavlena-novaya-znachitelnaya-vetka-subd-mariadb-11","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"ro_RO","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\u041f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u0435\u043d\u0430 \u043d\u043e\u0432\u0430\u044f \u0437\u043d\u0430\u0447\u0438\u0442\u0435\u043b\u044c\u043d\u0430\u044f \u0432\u0435\u0442\u043a\u0430 \u0421\u0423\u0411\u0414 MariaDB 11 | ProHoster","og:description":"\u0421\u043f\u0443\u0441\u0442\u044f 10 \u043b\u0435\u0442 \u0441 \u043c\u043e\u043c\u0435\u043d\u0442\u0430 \u043e\u0441\u043d\u043e\u0432\u0430\u043d\u0438\u044f \u0432\u0435\u0442\u043a\u0438 10.x \u043f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u0435\u043d \u0432\u044b\u043f\u0443\u0441\u043a \u0421\u0423\u0411\u0414 MariaDB 11.0.0, \u0432 \u043a\u043e\u0442\u043e\u0440\u043e\u043c \u043f\u0440\u0435\u0434\u043b\u043e\u0436\u0435\u043d\u043e \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u043e \u0437\u043d\u0430\u0447\u0438\u0442\u0435\u043b\u044c\u043d\u044b\u0445 \u0443\u043b\u0443\u0447\u0448\u0435\u043d\u0438\u0439 \u0438 \u0438\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u0439, \u043d\u0430\u0440\u0443\u0448\u0430\u044e\u0449\u0438\u0445 \u0441\u043e\u0432\u043c\u0435\u0441\u0442\u0438\u043c\u043e\u0441\u0442\u044c.","og:url":"https:\/\/prohoster.info\/ro\/blog\/news\/predstavlena-novaya-znachitelnaya-vetka-subd-mariadb-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":"2022-12-28T13:36:45+00:00","article:modified_time":"2022-12-28T13:36:45+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":[],"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/posts\/106286","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/comments?post=106286"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/posts\/106286\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/media?parent=106286"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/categories?post=106286"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/tags?post=106286"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}