{"id":520,"date":"2021-03-11T09:00:19","date_gmt":"2021-03-11T09:00:19","guid":{"rendered":"https:\/\/dev.sourcecode.sk\/wsczkb\/?post_type=ht_kb&#038;p=520"},"modified":"2021-07-19T15:36:10","modified_gmt":"2021-07-19T13:36:10","slug":"maria-db-10-1","status":"publish","type":"ht_kb","link":"https:\/\/www.websupport.cz\/podpora\/kb\/maria-db-10-1\/","title":{"rendered":"Maria DB 10.1"},"content":{"rendered":"\n<p>Od vyd\u00e1n\u00ed MySQL 5.1 pro\u0161lo MySQL intenz\u00edvn\u00edm v\u00fdvojem. Mnoh\u00e9 operace nad datab\u00e1z\u00ed se v\u00fdrazn\u011b optimalizovaly, vylep\u0161il se syst\u00e9m v\u00fdb\u011bru dat z datab\u00e1ze tak, aby se prohled\u00e1valy men\u0161\u00ed objemy p\u0159i stejn\u00e9m query. Tento v\u00fdvoj jsme samoz\u0159ejm\u011b reflektovali i nasazen\u00edm vy\u0161\u0161\u00ed verze MySQL. MariaDB&nbsp;je fork-em, odd\u011blenou v\u011btv\u00ed MySQL, kterou zalo\u017eili p\u016fvodn\u00ed v\u00fdvoj\u00e1\u0159i MySQL. Kdy\u017e jsme vyb\u00edrali, kterou variantu MySQL nasad\u00edme, d\u011blali jsme rozs\u00e1hl\u00e9 testy v\u00fdkonu, kde n\u00e1m jako jednozna\u010dn\u00fd v\u00edt\u011bz vy\u0161el pr\u00e1v\u011b 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 zp\u011btn\u011b pln\u011b kompatibiln\u00ed s Mysql 5.1.<\/p>\n\n\n\n<p>2.&nbsp;Dok\u00e1\u017ee optimalizovat drtivou v\u011bt\u0161inu subquery.<\/p>\n\n\n\n<p>3.&nbsp;M\u00e1 lep\u0161\u00ed query cache &#8211; &nbsp;um\u00ed si zapamatovat \u010dast\u00e9 query na datab\u00e1zi a vracet podstatn\u011b rychleji.<\/p>\n\n\n\n<p>4.&nbsp;M\u00e1 vy\u0161\u0161\u00ed v\u00fdkon p\u0159i operac\u00edch typu ORDER BY.<\/p>\n\n\n\n<p>5. M\u00e1 zaveden\u00fd Percona XtraDB jako n\u00e1hradu za standardn\u00ed 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\u00e1ze MariaDB 10.1\u00a0(phpmyadmin):\u00a0<a href=\"http:\/\/dbadmin.websupport.cz\" target=\"_blank\" rel=\"noreferrer noopener\">dbadmin.websupport.cz<\/a>.<\/p>\n\n\n\n<p>2. Spr\u00e1va datab\u00e1z\u00ed mysql (Adminer):\u00a0<a href=\"http:\/\/adminer.websupport.cz\/\" target=\"_blank\" rel=\"noreferrer noopener\">http:\/\/adminer.websupport.cz\/<\/a>.<\/p>\n\n\n\n<p>3.&nbsp;V php skriptech pou\u017e\u00edvejte pro 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>V\u00edce o v\u00fdhod\u00e1ch MariaDB 10.1&nbsp;se m\u016f\u017eete do\u010d\u00edst na n\u00e1sleduj\u00edc\u00edch linc\u00edch:<\/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 vyd\u00e1n\u00ed MySQL 5.1 pro\u0161lo MySQL intenz\u00edvn\u00edm v\u00fdvojem. Mnoh\u00e9 operace nad datab\u00e1z\u00ed se v\u00fdrazn\u011b optimalizovaly, vylep\u0161il se syst\u00e9m v\u00fdb\u011bru dat z datab\u00e1ze tak, aby se prohled\u00e1valy men\u0161\u00ed objemy p\u0159i stejn\u00e9m query. Tento v\u00fdvoj jsme samoz\u0159ejm\u011b reflektovali i nasazen\u00edm vy\u0161\u0161\u00ed verze MySQL. MariaDB&nbsp;je fork-em, odd\u011blenou v\u011btv\u00ed MySQL, kterou zalo\u017eili p\u016fvodn\u00ed v\u00fdvoj\u00e1\u0159i&#8230;<\/p>\n","protected":false},"author":3,"template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[57],"ht-kb-tag":[],"class_list":["post-520","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-databaze"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Maria DB 10.1 - Websupport Centrum n\u00e1pov\u011bdy<\/title>\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.cz\/podpora\/kb\/maria-db-10-1\/\" \/>\n<meta property=\"og:locale\" content=\"cs_CZ\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Maria DB 10.1 - Websupport Centrum n\u00e1pov\u011bdy\" \/>\n<meta property=\"og:description\" content=\"Od vyd\u00e1n\u00ed MySQL 5.1 pro\u0161lo MySQL intenz\u00edvn\u00edm v\u00fdvojem. Mnoh\u00e9 operace nad datab\u00e1z\u00ed se v\u00fdrazn\u011b optimalizovaly, vylep\u0161il se syst\u00e9m v\u00fdb\u011bru dat z datab\u00e1ze tak, aby se prohled\u00e1valy men\u0161\u00ed objemy p\u0159i stejn\u00e9m query. Tento v\u00fdvoj jsme samoz\u0159ejm\u011b reflektovali i nasazen\u00edm vy\u0161\u0161\u00ed verze MySQL. MariaDB&nbsp;je fork-em, odd\u011blenou v\u011btv\u00ed MySQL, kterou zalo\u017eili p\u016fvodn\u00ed v\u00fdvoj\u00e1\u0159i...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.websupport.cz\/podpora\/kb\/maria-db-10-1\/\" \/>\n<meta property=\"og:site_name\" content=\"Websupport Centrum n\u00e1pov\u011bdy\" \/>\n<meta property=\"article:modified_time\" content=\"2021-07-19T13:36:10+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Odhadovan\u00e1 doba \u010dten\u00ed\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minuta\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.websupport.cz\/podpora\/kb\/maria-db-10-1\/\",\"url\":\"https:\/\/www.websupport.cz\/podpora\/kb\/maria-db-10-1\/\",\"name\":\"Maria DB 10.1 - Websupport Centrum n\u00e1pov\u011bdy\",\"isPartOf\":{\"@id\":\"https:\/\/www.websupport.cz\/podpora\/#website\"},\"datePublished\":\"2021-03-11T09:00:19+00:00\",\"dateModified\":\"2021-07-19T13:36:10+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.websupport.cz\/podpora\/kb\/maria-db-10-1\/#breadcrumb\"},\"inLanguage\":\"cs\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.websupport.cz\/podpora\/kb\/maria-db-10-1\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.websupport.cz\/podpora\/kb\/maria-db-10-1\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.websupport.cz\/podpora\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Maria DB 10.1\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.websupport.cz\/podpora\/#website\",\"url\":\"https:\/\/www.websupport.cz\/podpora\/\",\"name\":\"Websupport Centrum n\u00e1pov\u011bdy\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.websupport.cz\/podpora\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"cs\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Maria DB 10.1 - Websupport Centrum n\u00e1pov\u011bdy","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.cz\/podpora\/kb\/maria-db-10-1\/","og_locale":"cs_CZ","og_type":"article","og_title":"Maria DB 10.1 - Websupport Centrum n\u00e1pov\u011bdy","og_description":"Od vyd\u00e1n\u00ed MySQL 5.1 pro\u0161lo MySQL intenz\u00edvn\u00edm v\u00fdvojem. Mnoh\u00e9 operace nad datab\u00e1z\u00ed se v\u00fdrazn\u011b optimalizovaly, vylep\u0161il se syst\u00e9m v\u00fdb\u011bru dat z datab\u00e1ze tak, aby se prohled\u00e1valy men\u0161\u00ed objemy p\u0159i stejn\u00e9m query. Tento v\u00fdvoj jsme samoz\u0159ejm\u011b reflektovali i nasazen\u00edm vy\u0161\u0161\u00ed verze MySQL. MariaDB&nbsp;je fork-em, odd\u011blenou v\u011btv\u00ed MySQL, kterou zalo\u017eili p\u016fvodn\u00ed v\u00fdvoj\u00e1\u0159i...","og_url":"https:\/\/www.websupport.cz\/podpora\/kb\/maria-db-10-1\/","og_site_name":"Websupport Centrum n\u00e1pov\u011bdy","article_modified_time":"2021-07-19T13:36:10+00:00","twitter_card":"summary_large_image","twitter_misc":{"Odhadovan\u00e1 doba \u010dten\u00ed":"1 minuta"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.websupport.cz\/podpora\/kb\/maria-db-10-1\/","url":"https:\/\/www.websupport.cz\/podpora\/kb\/maria-db-10-1\/","name":"Maria DB 10.1 - Websupport Centrum n\u00e1pov\u011bdy","isPartOf":{"@id":"https:\/\/www.websupport.cz\/podpora\/#website"},"datePublished":"2021-03-11T09:00:19+00:00","dateModified":"2021-07-19T13:36:10+00:00","breadcrumb":{"@id":"https:\/\/www.websupport.cz\/podpora\/kb\/maria-db-10-1\/#breadcrumb"},"inLanguage":"cs","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.websupport.cz\/podpora\/kb\/maria-db-10-1\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.websupport.cz\/podpora\/kb\/maria-db-10-1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.websupport.cz\/podpora\/"},{"@type":"ListItem","position":2,"name":"Maria DB 10.1"}]},{"@type":"WebSite","@id":"https:\/\/www.websupport.cz\/podpora\/#website","url":"https:\/\/www.websupport.cz\/podpora\/","name":"Websupport Centrum n\u00e1pov\u011bdy","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.websupport.cz\/podpora\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"cs"}]}},"_links":{"self":[{"href":"https:\/\/www.websupport.cz\/podpora\/wp-json\/wp\/v2\/ht-kb\/520","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.websupport.cz\/podpora\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/www.websupport.cz\/podpora\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.websupport.cz\/podpora\/wp-json\/wp\/v2\/users\/3"}],"version-history":[{"count":2,"href":"https:\/\/www.websupport.cz\/podpora\/wp-json\/wp\/v2\/ht-kb\/520\/revisions"}],"predecessor-version":[{"id":3800,"href":"https:\/\/www.websupport.cz\/podpora\/wp-json\/wp\/v2\/ht-kb\/520\/revisions\/3800"}],"wp:attachment":[{"href":"https:\/\/www.websupport.cz\/podpora\/wp-json\/wp\/v2\/media?parent=520"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.websupport.cz\/podpora\/wp-json\/wp\/v2\/ht-kb-category?post=520"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.websupport.cz\/podpora\/wp-json\/wp\/v2\/ht-kb-tag?post=520"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}