{"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\/cs\/blog\/news\/vypusk-subd-mysql-9-1-0","title":{"rendered":"Vyd\u00e1n\u00ed SGBD MySQL 9.1.0","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Spole\u010dnost Oracle vytvo\u0159ila novou v\u011btev datab\u00e1zov\u00e9ho syst\u00e9mu MySQL 9.1.0. Verze MySQL Community Server 9.1.0 byly p\u0159ipraveny pro v\u0161echny hlavn\u00ed distribuce Linuxu, FreeBSD, macOS a Windows. V r\u00e1mci lo\u0148sk\u00e9ho zaveden\u00ed nov\u00e9 modelu vyd\u00e1v\u00e1n\u00ed byla MySQL 9.1 za\u0159azena do v\u011btve \u201eInnovation\u201c, do kter\u00e9 bude za\u0159azen i n\u00e1sleduj\u00edc\u00ed v\u00fdznamn\u00fd vyd\u00e1n\u00ed MySQL 9.2. V\u011btve Innovation jsou doporu\u010dov\u00e1ny pro ty, kte\u0159\u00ed cht\u011bj\u00ed d\u0159\u00edve z\u00edskat p\u0159\u00edstup k nov\u00fdm funkc\u00edm, vych\u00e1zej\u00ed ka\u017ed\u00e9 3 m\u011bs\u00edce a jsou podporov\u00e1ny pouze do vyd\u00e1n\u00ed n\u00e1sleduj\u00edc\u00edho v\u00fdznamn\u00e9ho vyd\u00e1n\u00ed (nap\u0159\u00edklad po vzniku v\u011btve 9.1 p\u0159est\u00e1v\u00e1 b\u00fdt podpora v\u011btve 9.0). V l\u00e9t\u011b p\u0159\u00ed\u0161t\u00edho roku se pl\u00e1nuje vytvo\u0159en\u00ed LTS vyd\u00e1n\u00ed, doporu\u010den\u00e9ho pro nasazen\u00ed, kter\u00e9 pot\u0159ebuje p\u0159edv\u00eddatelnost a dlouh\u00e9 uchov\u00e1n\u00ed nezm\u011bn\u011bn\u00e9ho chov\u00e1n\u00ed. N\u00e1sledn\u011b po LTS v\u011btvi bude vytvo\u0159ena nov\u00e1 v\u011btev Innovation \u2014 MySQL 10.0.        <\/p>\n<p>Hlavn\u00ed zm\u011bny v MySQL 9.1:  <\/p>\n<ul>\n<li class=\"l\"> Do operace \u201eCREATE VIEW\u201c byla p\u0159id\u00e1na podpora pro v\u00fdraz \u201eIF NOT EXISTS\u201c, co\u017e umo\u017e\u0148uje vytvo\u0159it pohled pouze tehdy, pokud pohled se zadan\u00fdm n\u00e1zvem je\u0161t\u011b neexistuje, a zabr\u00e1nit tak vracen\u00ed chyby, pokud ji\u017e pohled byl vytvo\u0159en.\n<li class=\"l\"> Bylo zastaveno na\u010d\u00edt\u00e1n\u00ed trigger\u016f p\u0159i prov\u00e1d\u011bn\u00ed operac\u00ed, kter\u00e9 se t\u00fdkaj\u00ed pouze \u010dten\u00ed. D\u0159\u00edve se triggery na\u010d\u00edtaly p\u0159i jak\u00e9mkoli p\u0159\u00edstupu k tabulce, co\u017e vedlo k nadm\u011brn\u00e9 spot\u0159eb\u011b pam\u011bti a z\u00e1t\u011b\u017ei CPU v situac\u00edch, kdy se triggery nepou\u017e\u00edvaly (nap\u0159\u00edklad p\u0159i prov\u00e1d\u011bn\u00ed SELECT dotaz\u016f). V MySQL 9.1 je zpracov\u00e1n\u00ed a na\u010d\u00edt\u00e1n\u00ed trigger\u016f rozd\u011bleno do dvou f\u00e1z\u00ed: \u010dten\u00ed metadat o triggeru a anal\u00fdza + prov\u00e1d\u011bn\u00ed triggeru. Data z\u00edskan\u00e1 v prvn\u00ed f\u00e1zi jsou ulo\u017eena jednou a pot\u00e9 spole\u010dn\u011b pou\u017e\u00edv\u00e1na v r\u016fzn\u00fdch instanc\u00edch triggeru. Anal\u00fdza a prov\u00e1d\u011bn\u00ed triggeru se prov\u00e1d\u00ed pouze pro v\u00fdrazy, kter\u00e9 vedou ke zm\u011bn\u011b dat. Krom\u011b toho, aby se sn\u00ed\u017eila spot\u0159eba pam\u011bti, byla nam\u00edsto statick\u00e9ho ud\u011blov\u00e1n\u00ed buffer\u016f pro zpracov\u00e1n\u00ed chyb v triggerech zavedena dynamick\u00e1 alokace pam\u011bti podle pot\u0159eby.\n<li class=\"l\"> Roz\u0161\u00ed\u0159eno v\u00fdstupy operace \u201eEXPLAIN\u201c, ve kter\u00e9m jsou nyn\u00ed zobrazov\u00e1ny informace o pou\u017eit\u00ed v\u00edcere\u017eimov\u00e9ho \u010dten\u00ed (multi-range) a vyu\u017eit\u00ed strategie polokombinace (semijoin), p\u0159i kter\u00e9 jsou p\u0159i operac\u00edch JOIN zpracov\u00e1v\u00e1ny \u0159\u00e1dky pouze z jedn\u00e9 tabulky.\n<li class=\"l\"> Zaji\u0161t\u011bno atomick\u00e9 prov\u00e1d\u011bn\u00ed operac\u00ed \u201eCREATE DATABASE\u201c a \u201eDROP DATABASE\u201c k ochran\u011b p\u0159ed selh\u00e1n\u00edm v p\u0159\u00edpad\u011b havarijn\u00edho ukon\u010den\u00ed nebo vzniku chyb na \u00farovni souborov\u00e9ho syst\u00e9mu b\u011bhem prov\u00e1d\u011bn\u00ed t\u011bchto operac\u00ed. Nap\u0159\u00edklad d\u0159\u00edve p\u0159i havarijn\u00edm ukon\u010den\u00ed \u201eCREATE DATABASE\u201c mohla b\u00fdt vytvo\u0159ena ne\u00fapln\u00e1 nefunk\u010dn\u00ed struktura \u00falo\u017ei\u0161t\u011b datab\u00e1ze, jej\u00ed\u017e odstran\u011bn\u00ed vy\u017eadovalo ru\u010dn\u00ed z\u00e1sah.\n<li class=\"l\"> Ve psan\u00fdch na JavaScript ulo\u017een\u00fdch procedur\u00e1ch byla zaji\u0161t\u011bna podpora typu VECTOR. Data s t\u00edmto typem mohou nyn\u00ed b\u00fdt p\u0159ed\u00e1v\u00e1na jako vstupn\u00ed a n\u00e1vratov\u00e9 parametry.\n<li class=\"l\"> Byla p\u0159id\u00e1na mo\u017enost autentizace p\u0159i p\u0159ipojen\u00ed k S\u00daBD pomoc\u00ed protokolu OpenID Connect.\n<li class=\"l\"> Bylo odstran\u011bno 27 zranitelnost\u00ed, z nich\u017e nejv\u00e1\u017en\u011bj\u0161\u00ed (CVE-2024-5535) byla klasifikov\u00e1na jako kritick\u00e1 (9.1 z 10). Zranitelnost m\u016f\u017ee b\u00fdt zneu\u017eita vzd\u00e1len\u011b bez ov\u011b\u0159en\u00ed. Probl\u00e9m je zp\u016fsoben \u010dten\u00edm dat z oblasti mimo vymezen\u00fd buffer v knihovn\u011b OpenSSL a vede k havarijn\u00edmu ukon\u010den\u00ed nebo \u00faniku obsahu pam\u011bti v odpov\u011bdi po p\u0159ipojen\u00ed s <a class=\"wpil_keyword_link\" href=\"https:\/\/prohoster.info\/cs\/server\/dts-prohoster\/\"   title=\"serverem\" data-wpil-keyword-link=\"linked\"  data-wpil-monitor-id=\"3093\">serverem<\/a>  s uveden\u00edm nespr\u00e1vn\u00fdch parametr\u016f 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.3 - 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\/cs\/blog\/news\/vypusk-subd-mysql-9-1-0\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.3\" \/>\n\t\t<meta property=\"og:locale\" content=\"cs_CZ\" \/>\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\/cs\/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\udd47Vyd\u00e1n\u00ed S\u00daBD MySQL 9.1.0 | ProHoster","description":"Spole\u010dnost Oracle vytvo\u0159ila novou v\u011btev S\u00daBD MySQL 9.1.0. Sestavy MySQL Community Server 9.1.0 byly p\u0159ipraveny pro v\u0161echny hlavn\u00ed distribuce Linuxu, FreeBSD, macOS a Windows.","canonical_url":"https:\/\/prohoster.info\/cs\/blog\/news\/vypusk-subd-mysql-9-1-0","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"cs_CZ","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\/cs\/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\/cs\/wp-json\/wp\/v2\/posts\/120215","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/comments?post=120215"}],"version-history":[{"count":1,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/posts\/120215\/revisions"}],"predecessor-version":[{"id":160374,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/posts\/120215\/revisions\/160374"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/media?parent=120215"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/categories?post=120215"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/tags?post=120215"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}