{"id":1312,"date":"2018-12-10T21:22:23","date_gmt":"2018-12-10T20:22:23","guid":{"rendered":"https:\/\/www.websupport.sk\/podpora\/?post_type=ht_kb&#038;p=1312"},"modified":"2019-01-13T20:37:38","modified_gmt":"2019-01-13T19:37:38","slug":"maria-db-10-1","status":"publish","type":"ht_kb","link":"https:\/\/www.websupport.sk\/podpora\/kb\/maria-db-10-1\/","title":{"rendered":"Maria DB 10.1"},"content":{"rendered":"\n<p>Od vydania MySQL 5.1 pre\u0161lo MySQL intenz\u00edvnym v\u00fdvojom. Mnoh\u00e9 oper\u00e1cie nad datab\u00e1zou sa v\u00fdrazne optimalizovali, vylep\u0161il sa syst\u00e9m v\u00fdberu d\u00e1t z datab\u00e1zy tak, aby sa preh\u013ead\u00e1vali men\u0161ie objemy pri rovnakom query. Samozrejme tento v\u00fdvoj sme reflektovali aj nasaden\u00edm vy\u0161\u0161ej verzie MySQL. MariaDB&nbsp;je fork-om, oddelenou vetvou &nbsp;MySQL, ktor\u00fa zalo\u017eili povodni v\u00fdvoj\u00e1ri MySQL. Ke\u010f sme vyberali, ktor\u00fa variantu MySQL nasad\u00edme, robili sme rozisahle testy v\u00fdkonu, kde n\u00e1m ako jednozna\u010dn\u00fd v\u00ed\u0165az vy\u0161iel prav\u00e9 MariaDB 10.1.&nbsp;<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Pre\u010do pou\u017ei\u0165 MariaDB 10.1&nbsp;?&nbsp;<\/strong><\/h4>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<p>1.&nbsp;Je sp\u00e4tne plne kompatibiln\u00e1 s Mysql 5.1.<\/p>\n\n\n\n<p>2.&nbsp;Dok\u00e1\u017ee optimalizova\u0165 drviv\u00fa v\u00e4\u010d\u0161inu subquery.<\/p>\n\n\n\n<p>3.&nbsp;M\u00e1 lep\u0161\u00ed query cache &#8211; &nbsp;vie si zapam\u00e4ta\u0165 \u010dast\u00e9 query na datab\u00e1zu a tieto vraca\u0165 podstatne r\u00fdchlej\u0161ie.<\/p>\n\n\n\n<p>4.&nbsp;M\u00e1 vy\u0161\u0161\u00ed v\u00fdkon pri oper\u00e1ci\u00e1ch typu ORDER BY.<\/p>\n\n\n\n<p>5. M\u00e1 zaveden\u00fd Percona XtraDB ako n\u00e1hradu za \u0161tandardn\u00fd InnoDB.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>\u00dadaje k MariaDB 10.1<\/strong><\/h4>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<p>1. Spr\u00e1va datab\u00e1zy MariaDB 10.1&nbsp;(phpmyadmin):&nbsp;<a href=\"https:\/\/db101.websupport.sk\/\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/db101.websupport.sk\/<\/a>.<\/p>\n\n\n\n<p>2. Spr\u00e1va datab\u00e1z mysql (Adminer):&nbsp;<a href=\"http:\/\/adminer.websupport.sk\/\" target=\"_blank\" rel=\"noreferrer noopener\">http:\/\/adminer.websupport.sk\/<\/a>.<\/p>\n\n\n\n<p>3.&nbsp;V php skriptoch pou\u017e\u00edvajte pre MariaDB 10.1:&nbsp;&nbsp;<strong>:\/tmp\/mariadb101.sock<\/strong><\/p>\n\n\n\n<p>4.&nbsp;MariaDB 10.1&nbsp;server:&nbsp;<strong>mariadb101.websupport.sk,<\/strong>&nbsp;<strong>port: 3312<\/strong><\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Viac o v\u00fdhod\u00e1ch MariaDB 10.1&nbsp;sa m\u00f4\u017eete do\u010d\u00edta\u0165 na nasleduj\u00facich linkoch:<\/strong><\/h4>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/mariadb.com\/kb\/en\/mariadb-vs-mysql-features\/\">https:\/\/mariadb.com\/kb\/en\/mariadb-vs-mysql-features\/<\/a><\/li><li><a href=\"https:\/\/www.skysql.com\/why-skysql\/whitepapers\/mariadb-vs-mysql\">https:\/\/www.skysql.com\/why-skysql\/whitepapers\/mariadb-vs-mysql<\/a><\/li><\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Od vydania MySQL 5.1 pre\u0161lo MySQL intenz\u00edvnym v\u00fdvojom. Mnoh\u00e9 oper\u00e1cie nad datab\u00e1zou sa v\u00fdrazne optimalizovali, vylep\u0161il sa syst\u00e9m v\u00fdberu d\u00e1t z datab\u00e1zy tak, aby sa preh\u013ead\u00e1vali men\u0161ie objemy pri rovnakom query. Samozrejme tento v\u00fdvoj sme reflektovali aj nasaden\u00edm vy\u0161\u0161ej verzie MySQL. MariaDB&nbsp;je fork-om, oddelenou vetvou &nbsp;MySQL, ktor\u00fa zalo\u017eili povodni v\u00fdvoj\u00e1ri&#8230;<\/p>\n","protected":false},"author":29,"template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[41],"ht-kb-tag":[],"class_list":["post-1312","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-databazy"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Maria DB 10.1 - Websupport centrum podpory<\/title>\n<meta name=\"description\" content=\"Od vydania MySQL 5.1 pre\u0161lo MySQL intenz\u00edvnym v\u00fdvojom. MariaDB je fork-om, oddelenou vetvou MySQL, ktor\u00fa zalo\u017eili p\u00f4vodni v\u00fdvoj\u00e1ri MySQL.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.websupport.sk\/podpora\/kb\/maria-db-10-1\/\" \/>\n<meta property=\"og:locale\" content=\"sk_SK\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Maria DB 10.1 - Websupport centrum podpory\" \/>\n<meta property=\"og:description\" content=\"Od vydania MySQL 5.1 pre\u0161lo MySQL intenz\u00edvnym v\u00fdvojom. MariaDB je fork-om, oddelenou vetvou MySQL, ktor\u00fa zalo\u017eili p\u00f4vodni v\u00fdvoj\u00e1ri MySQL.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.websupport.sk\/podpora\/kb\/maria-db-10-1\/\" \/>\n<meta property=\"og:site_name\" content=\"Websupport centrum podpory\" \/>\n<meta property=\"article:modified_time\" content=\"2019-01-13T19:37:38+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Predpokladan\u00fd \u010das \u010d\u00edtania\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 min\u00fata\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.websupport.sk\\\/podpora\\\/kb\\\/maria-db-10-1\\\/\",\"url\":\"https:\\\/\\\/www.websupport.sk\\\/podpora\\\/kb\\\/maria-db-10-1\\\/\",\"name\":\"Maria DB 10.1 - Websupport centrum podpory\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.websupport.sk\\\/podpora\\\/#website\"},\"datePublished\":\"2018-12-10T20:22:23+00:00\",\"dateModified\":\"2019-01-13T19:37:38+00:00\",\"description\":\"Od vydania MySQL 5.1 pre\u0161lo MySQL intenz\u00edvnym v\u00fdvojom. MariaDB je fork-om, oddelenou vetvou MySQL, ktor\u00fa zalo\u017eili p\u00f4vodni v\u00fdvoj\u00e1ri MySQL.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.websupport.sk\\\/podpora\\\/kb\\\/maria-db-10-1\\\/#breadcrumb\"},\"inLanguage\":\"sk-SK\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.websupport.sk\\\/podpora\\\/kb\\\/maria-db-10-1\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.websupport.sk\\\/podpora\\\/kb\\\/maria-db-10-1\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.websupport.sk\\\/podpora\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Maria DB 10.1\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.websupport.sk\\\/podpora\\\/#website\",\"url\":\"https:\\\/\\\/www.websupport.sk\\\/podpora\\\/\",\"name\":\"Websupport centrum podpory\",\"description\":\"Radi v\u00e1m pom\u00f4\u017eeme s va\u0161im probl\u00e9mom\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.websupport.sk\\\/podpora\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"sk-SK\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Maria DB 10.1 - Websupport centrum podpory","description":"Od vydania MySQL 5.1 pre\u0161lo MySQL intenz\u00edvnym v\u00fdvojom. MariaDB je fork-om, oddelenou vetvou MySQL, ktor\u00fa zalo\u017eili p\u00f4vodni v\u00fdvoj\u00e1ri MySQL.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.websupport.sk\/podpora\/kb\/maria-db-10-1\/","og_locale":"sk_SK","og_type":"article","og_title":"Maria DB 10.1 - Websupport centrum podpory","og_description":"Od vydania MySQL 5.1 pre\u0161lo MySQL intenz\u00edvnym v\u00fdvojom. MariaDB je fork-om, oddelenou vetvou MySQL, ktor\u00fa zalo\u017eili p\u00f4vodni v\u00fdvoj\u00e1ri MySQL.","og_url":"https:\/\/www.websupport.sk\/podpora\/kb\/maria-db-10-1\/","og_site_name":"Websupport centrum podpory","article_modified_time":"2019-01-13T19:37:38+00:00","twitter_card":"summary_large_image","twitter_misc":{"Predpokladan\u00fd \u010das \u010d\u00edtania":"1 min\u00fata"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.websupport.sk\/podpora\/kb\/maria-db-10-1\/","url":"https:\/\/www.websupport.sk\/podpora\/kb\/maria-db-10-1\/","name":"Maria DB 10.1 - Websupport centrum podpory","isPartOf":{"@id":"https:\/\/www.websupport.sk\/podpora\/#website"},"datePublished":"2018-12-10T20:22:23+00:00","dateModified":"2019-01-13T19:37:38+00:00","description":"Od vydania MySQL 5.1 pre\u0161lo MySQL intenz\u00edvnym v\u00fdvojom. MariaDB je fork-om, oddelenou vetvou MySQL, ktor\u00fa zalo\u017eili p\u00f4vodni v\u00fdvoj\u00e1ri MySQL.","breadcrumb":{"@id":"https:\/\/www.websupport.sk\/podpora\/kb\/maria-db-10-1\/#breadcrumb"},"inLanguage":"sk-SK","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.websupport.sk\/podpora\/kb\/maria-db-10-1\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.websupport.sk\/podpora\/kb\/maria-db-10-1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.websupport.sk\/podpora\/"},{"@type":"ListItem","position":2,"name":"Maria DB 10.1"}]},{"@type":"WebSite","@id":"https:\/\/www.websupport.sk\/podpora\/#website","url":"https:\/\/www.websupport.sk\/podpora\/","name":"Websupport centrum podpory","description":"Radi v\u00e1m pom\u00f4\u017eeme s va\u0161im probl\u00e9mom","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.websupport.sk\/podpora\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"sk-SK"}]}},"_links":{"self":[{"href":"https:\/\/www.websupport.sk\/podpora\/wp-json\/wp\/v2\/ht-kb\/1312","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.websupport.sk\/podpora\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/www.websupport.sk\/podpora\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.websupport.sk\/podpora\/wp-json\/wp\/v2\/users\/29"}],"version-history":[{"count":2,"href":"https:\/\/www.websupport.sk\/podpora\/wp-json\/wp\/v2\/ht-kb\/1312\/revisions"}],"predecessor-version":[{"id":1928,"href":"https:\/\/www.websupport.sk\/podpora\/wp-json\/wp\/v2\/ht-kb\/1312\/revisions\/1928"}],"wp:attachment":[{"href":"https:\/\/www.websupport.sk\/podpora\/wp-json\/wp\/v2\/media?parent=1312"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.websupport.sk\/podpora\/wp-json\/wp\/v2\/ht-kb-category?post=1312"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.websupport.sk\/podpora\/wp-json\/wp\/v2\/ht-kb-tag?post=1312"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}