{"id":120215,"date":"2024-10-17T19:09:08","date_gmt":"2024-10-17T17:09:08","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/vypusk-subd-mysql-9-1-0"},"modified":"2024-10-17T19:09:08","modified_gmt":"2024-10-17T17:09:08","slug":"vypusk-subd-mysql-9-1-0","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sk\/blog\/news\/vypusk-subd-mysql-9-1-0","title":{"rendered":"Vydanie DBMS MySQL 9.1.0","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Spolo\u010dnos\u0165 Oracle vytvorila nov\u00fa vetvu datab\u00e1zov\u00e9ho syst\u00e9mu MySQL 9.1.0. Zostavy MySQL Community Server 9.1.0 s\u00fa pripraven\u00e9 pre v\u0161etky hlavn\u00e9 distrib\u00facie Linuxu, FreeBSD, macOS a Windows. V r\u00e1mci nov\u00e9ho modelu uvo\u013e\u0148ovania, zaveden\u00e9ho minul\u00fd rok, bol MySQL 9.1 zaraden\u00fd do vetiev \u201eInov\u00e1cia\u201c, kam bude zaraden\u00e9 aj nasleduj\u00face v\u00fdznamn\u00e9 uvo\u013enenie MySQL 9.2. Vetvy Inov\u00e1cia s\u00fa odpor\u00fa\u010dan\u00e9 pre t\u00fdch, ktor\u00ed chc\u00fa sk\u00f4r z\u00edska\u0165 pr\u00edstup k novej funkcionalite, s\u00fa publikovan\u00e9 ka\u017ed\u00e9 3 mesiace a s\u00fa podporovan\u00e9 iba do vydania nasleduj\u00faceho v\u00fdznamn\u00e9ho uvo\u013enenia (napr\u00edklad po vydan\u00ed vetvy 9.1 bola zastaven\u00e1 podpora pre vetvu 9.0). Na leto bud\u00faceho roka sa pl\u00e1nuje vytvorenie LTS uvo\u013enenia, odpor\u00fa\u010dan\u00e9ho pre implement\u00e1cie, ktor\u00e9 potrebuj\u00fa predv\u00eddate\u013enos\u0165 a dlhodob\u00e9 zachovanie nemenn\u00e9ho spr\u00e1vania. Nasleduj\u00faca po LTS vetve bude vytvoren\u00e1 nov\u00e1 vetva Inov\u00e1cia \u2014 MySQL 10.0.        <\/p>\n<p>Hlavn\u00e9 zmeny v MySQL 9.1:  <\/p>\n<ul>\n<li class=\"l\"> Do oper\u00e1cie \u201eCREATE VIEW\u201c bola pridan\u00e1 podpora pre v\u00fdraz \u201eIF NOT EXISTS\u201c, ktor\u00fd umo\u017e\u0148uje vytvori\u0165 poh\u013ead iba v pr\u00edpade, \u017ee poh\u013ead so zadan\u00fdm n\u00e1zvom e\u0161te neexistuje, a zabr\u00e1ni\u0165 n\u00e1vratu chyby, ak u\u017e bol poh\u013ead vytvoren\u00fd.\n<li class=\"l\"> Bol ukon\u010den\u00fd proces na\u010d\u00edtavania sp\u00fa\u0161\u0165a\u010dov pri vykon\u00e1van\u00ed oper\u00e1ci\u00ed, ktor\u00e9 s\u00fa len na \u010d\u00edtanie. Predt\u00fdm sa sp\u00fa\u0161\u0165a\u010de na\u010d\u00edtavali pri akomko\u013evek pr\u00edstupe k tabu\u013eke, \u010do viedlo k zbyto\u010dn\u00e9mu vyu\u017e\u00edvaniu pam\u00e4te a za\u0165a\u017eovaniu CPU v situ\u00e1ci\u00e1ch, ke\u010f sa sp\u00fa\u0161\u0165a\u010de nepou\u017e\u00edvali (napr\u00edklad pri vykon\u00e1van\u00ed dopytov SELECT). V MySQL 9.1 je spracovanie a na\u010d\u00edtanie sp\u00fa\u0161\u0165a\u010dov rozdelen\u00e9 do dvoch f\u00e1z: \u010d\u00edtanie metad\u00e1t o sp\u00fa\u0161\u0165a\u010di a anal\u00fdzu + vykonanie sp\u00fa\u0161\u0165a\u010da. D\u00e1ta z\u00edskan\u00e9 v prvej f\u00e1ze s\u00fa ulo\u017een\u00e9 raz a n\u00e1sledne zdie\u013ean\u00e9 v r\u00f4znych in\u0161tanci\u00e1ch sp\u00fa\u0161\u0165a\u010da. Anal\u00fdza a vykonanie sp\u00fa\u0161\u0165a\u010da sa uskuto\u010d\u0148uje iba pre v\u00fdrazy, ktor\u00e9 ved\u00fa k zmene \u00fadajov. Okrem toho, aby sa zn\u00ed\u017eila spotreba pam\u00e4te, bol namiesto statick\u00e9ho pride\u013eovania pam\u00e4te na spracovanie ch\u00fdb v sp\u00fa\u0161\u0165a\u010doch prechod na dynamick\u00e9 pride\u013eovanie pam\u00e4te na po\u017eiadanie.\n<li class=\"l\"> Roz\u0161\u00edren\u00fd v\u00fdstup oper\u00e1cie \u201eEXPLAIN\u201c, v ktorom s\u00fa teraz zobrazen\u00e9 inform\u00e1cie o pou\u017e\u00edvan\u00ed viacz\u00f3nov\u00e9ho \u010d\u00edtania (multi-range) a aplik\u00e1cii strat\u00e9gie polozl\u00fa\u010denia (semijoin), pri ktorej sa pri oper\u00e1ci\u00e1ch JOIN spracov\u00e1vaj\u00fa riadky iba z jednej tabu\u013eky.\n<li class=\"l\"> Zabezpe\u010den\u00e9 atomick\u00e9 vykon\u00e1vanie oper\u00e1ci\u00ed \u201eCREATE DATABASE\u201c a \u201eDROP DATABASE\u201c na ochranu pred zlyhaniami v pr\u00edpade havarijn\u00e9ho ukon\u010denia alebo vzniku ch\u00fdb na \u00farovni s\u00faborov\u00e9ho syst\u00e9mu po\u010das vykon\u00e1vania t\u00fdchto oper\u00e1ci\u00ed. Napr\u00edklad sk\u00f4r pri havarijnom ukon\u010den\u00ed \u201eCREATE DATABASE\u201c mohla by\u0165 vytvoren\u00e1 ne\u00fapln\u00e1 nefunk\u010dn\u00e1 \u0161trukt\u00fara \u00falo\u017eiska DB, na jej vy\u010distenie bolo potrebn\u00e9 manu\u00e1lne z\u00e1sah.\n<li class=\"l\"> V nap\u00edsan\u00fdch na JavaScript ulo\u017een\u00fdch proced\u00farach bola zabezpe\u010den\u00e1 podpora typu VECTOR. \u00dadaje s t\u00fdmto typom je teraz mo\u017en\u00e9 pren\u00e1\u0161a\u0165 v vstupn\u00fdch a v\u00fdstupn\u00fdch parametroch.\n<li class=\"l\"> Pridan\u00e1 mo\u017enos\u0165 autentifik\u00e1cie pri pripojen\u00ed k SYST\u00c9MOM DB pomocou protokolu OpenID Connect.\n<li class=\"l\"> Odstr\u00e1nen\u00fdch bolo 27 zranite\u013enost\u00ed, z ktor\u00fdch najz\u00e1va\u017enej\u0161ej (CVE-2024-5535) bol pridelen\u00fd kritick\u00fd stupe\u0148 nebezpe\u010denstva (9.1 z 10). Zranite\u013enos\u0165 m\u00f4\u017ee by\u0165 zneu\u017eit\u00e1 na dia\u013eku bez potreby autentifik\u00e1cie. Probl\u00e9m sp\u00f4sobuje \u010d\u00edtanie \u00fadajov z oblasti mimo vyhraden\u00e9ho vyrovn\u00e1vacieho pam\u00e4te v kni\u017enici OpenSSL a vedie k havarijn\u00e9mu ukon\u010deniu alebo \u00faniku obsahu pam\u00e4te v odpovedi po pripojen\u00ed s <a class=\"wpil_keyword_link\" href=\"https:\/\/prohoster.info\/sk\/server\/dts-prohoster\/\"   title=\"serverom\" data-wpil-keyword-link=\"linked\"  data-wpil-monitor-id=\"3093\">serverom<\/a>  s uveden\u00edm nespr\u00e1vnych parametrov protokolu.       <\/ul>\n<p>Zdroj: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=62067\">opennet.ru<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u041a\u043e\u043c\u043f\u0430\u043d\u0438\u044f Oracle \u0441\u0444\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u043b\u0430 \u043d\u043e\u0432\u0443\u044e \u0432\u0435\u0442\u043a\u0443 \u0421\u0423\u0411\u0414 MySQL 9.1.0. \u0421\u0431\u043e\u0440\u043a\u0438 MySQL Community Server 9.1.0 \u043f\u043e\u0434\u0433\u043e\u0442\u043e\u0432\u043b\u0435\u043d\u044b \u0434\u043b\u044f \u0432\u0441\u0435\u0445 \u043e\u0441\u043d\u043e\u0432\u043d\u044b\u0445 \u0434\u0438\u0441\u0442\u0440\u0438\u0431\u0443\u0442\u0438\u0432\u043e\u0432 Linux, FreeBSD, macOS \u0438 Windows. \u0412 \u0440\u0430\u043c\u043a\u0430\u0445 \u0432\u043d\u0435\u0434\u0440\u0451\u043d\u043d\u043e\u0439 \u0432 \u043f\u0440\u043e\u0448\u043b\u043e\u043c \u0433\u043e\u0434\u0443 \u043d\u043e\u0432\u043e\u0439 \u043c\u043e\u0434\u0435\u043b\u0438 \u0444\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u0440\u0435\u043b\u0438\u0437\u043e\u0432, MySQL 9.1 \u043e\u0442\u043d\u0435\u0441\u0451\u043d \u043a \u0432\u0435\u0442\u043a\u0430\u043c &#171;Innovation&#187;, \u043a \u043a\u043e\u0442\u043e\u0440\u044b\u043c \u0442\u0430\u043a\u0436\u0435 \u0431\u0443\u0434\u0435\u0442 \u043e\u0442\u043d\u0435\u0441\u0451\u043d \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0438\u0439 \u0437\u043d\u0430\u0447\u0438\u0442\u0435\u043b\u044c\u043d\u044b\u0439 \u0440\u0435\u043b\u0438\u0437 MySQL 9.2. Innovation-\u0432\u0435\u0442\u043a\u0438 \u0440\u0435\u043a\u043e\u043c\u0435\u043d\u0434\u043e\u0432\u0430\u043d\u044b \u0434\u043b\u044f \u0442\u0435\u0445, \u043a\u0442\u043e \u0445\u043e\u0447\u0435\u0442 [&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-120215","post","type-post","status-publish","format-standard","hentry","category-news"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.4 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u041a\u043e\u043c\u043f\u0430\u043d\u0438\u044f Oracle \u0441\u0444\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u043b\u0430 \u043d\u043e\u0432\u0443\u044e \u0432\u0435\u0442\u043a\u0443 \u0421\u0423\u0411\u0414 MySQL 9.1.0. \u0421\u0431\u043e\u0440\u043a\u0438 MySQL Community Server 9.1.0 \u043f\u043e\u0434\u0433\u043e\u0442\u043e\u0432\u043b\u0435\u043d\u044b \u0434\u043b\u044f \u0432\u0441\u0435\u0445 \u043e\u0441\u043d\u043e\u0432\u043d\u044b\u0445 \u0434\u0438\u0441\u0442\u0440\u0438\u0431\u0443\u0442\u0438\u0432\u043e\u0432 Linux, FreeBSD, macOS \u0438 Windows.\" \/>\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\/sk\/blog\/news\/vypusk-subd-mysql-9-1-0\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.4\" \/>\n\t\t<meta property=\"og:locale\" content=\"sk_SK\" \/>\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\u0412\u044b\u043f\u0443\u0441\u043a \u0421\u0423\u0411\u0414 MySQL 9.1.0 | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u041a\u043e\u043c\u043f\u0430\u043d\u0438\u044f Oracle \u0441\u0444\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u043b\u0430 \u043d\u043e\u0432\u0443\u044e \u0432\u0435\u0442\u043a\u0443 \u0421\u0423\u0411\u0414 MySQL 9.1.0. \u0421\u0431\u043e\u0440\u043a\u0438 MySQL Community Server 9.1.0 \u043f\u043e\u0434\u0433\u043e\u0442\u043e\u0432\u043b\u0435\u043d\u044b \u0434\u043b\u044f \u0432\u0441\u0435\u0445 \u043e\u0441\u043d\u043e\u0432\u043d\u044b\u0445 \u0434\u0438\u0441\u0442\u0440\u0438\u0431\u0443\u0442\u0438\u0432\u043e\u0432 Linux, FreeBSD, macOS \u0438 Windows.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/sk\/blog\/news\/vypusk-subd-mysql-9-1-0\" \/>\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=\"2024-10-17T17:09:08+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2024-10-17T17:09:08+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\udd47Uvo\u013enenie SYST\u00c9MU DB MySQL 9.1.0 | ProHoster","description":"Spolo\u010dnos\u0165 Oracle vytvorila nov\u00fa vetvu SYST\u00c9MU DB MySQL 9.1.0. Verzie MySQL Community Server 9.1.0 s\u00fa pripraven\u00e9 pre v\u0161etky hlavn\u00e9 distrib\u00facie Linux, FreeBSD, macOS a Windows.","canonical_url":"https:\/\/prohoster.info\/sk\/blog\/news\/vypusk-subd-mysql-9-1-0","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"sk_SK","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\u0412\u044b\u043f\u0443\u0441\u043a \u0421\u0423\u0411\u0414 MySQL 9.1.0 | ProHoster","og:description":"\u041a\u043e\u043c\u043f\u0430\u043d\u0438\u044f Oracle \u0441\u0444\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u043b\u0430 \u043d\u043e\u0432\u0443\u044e \u0432\u0435\u0442\u043a\u0443 \u0421\u0423\u0411\u0414 MySQL 9.1.0. \u0421\u0431\u043e\u0440\u043a\u0438 MySQL Community Server 9.1.0 \u043f\u043e\u0434\u0433\u043e\u0442\u043e\u0432\u043b\u0435\u043d\u044b \u0434\u043b\u044f \u0432\u0441\u0435\u0445 \u043e\u0441\u043d\u043e\u0432\u043d\u044b\u0445 \u0434\u0438\u0441\u0442\u0440\u0438\u0431\u0443\u0442\u0438\u0432\u043e\u0432 Linux, FreeBSD, macOS \u0438 Windows.","og:url":"https:\/\/prohoster.info\/sk\/blog\/news\/vypusk-subd-mysql-9-1-0","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":"2024-10-17T17:09:08+00:00","article:modified_time":"2024-10-17T17:09:08+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"120215","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":"2026-02-09 22:03:19","breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2026-01-23 07:23:19","updated":"2026-02-09 22:03:19","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/posts\/120215","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/comments?post=120215"}],"version-history":[{"count":1,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/posts\/120215\/revisions"}],"predecessor-version":[{"id":160374,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/posts\/120215\/revisions\/160374"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/media?parent=120215"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/categories?post=120215"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/tags?post=120215"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}