{"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\/sl\/blog\/news\/vypusk-subd-mysql-9-1-0","title":{"rendered":"Izdaja sistema za upravljanje podatkov MySQL 9.1.0","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Oracle je oblikoval novo vejo DBMS MySQL 9.1.0. Zgradbe MySQL Community Server 9.1.0 so pripravljene za vse glavne distribucije Linux, FreeBSD, macOS in Windows. V okviru novega modela oblikovanja izdaj, uvedenega lani, je MySQL 9.1 uvr\u0161\u010den v veje \u201eInnovation\u201c, kamor bo uvr\u0161\u010den tudi naslednji pomemben izpust MySQL 9.2. Innovation-veje so priporo\u010dene za tiste, ki \u017eelijo zgodnej\u0161i dostop do novih funkcionalnosti, objavljajo se vsakih 3 mesece in podpirajo le do objave naslednjega pomembnega izhoda (na primer, po pojavu veje 9.1 se podpora veji 9.0 ustavi). Poleti naslednje leto na\u010drtujejo oblikovanje LTS-izdaje, priporo\u010dene za uvedbe, ki potrebujejo predvidljivost in dolgo ohranjanje nespremenjenega obna\u0161anja. Takoj za LTS-vejo bo oblikovana nova Innovation-veja \u2014 MySQL 10.0.        <\/p>\n<p>Glavne spremembe v MySQL 9.1:  <\/p>\n<ul>\n<li class=\"l\"> Operaciji \u201eCREATE VIEW\u201c je dodana podpora za izraz \u201eIF NOT EXISTS\u201c, ki omogo\u010da ustvarjanje pogleda samo, \u010de pogled z navedenim imenom \u0161e ne obstaja, ter prepre\u010duje vrnitev napake, \u010de je pogled \u017ee ustvarjen.\n<li class=\"l\"> Nastalo je prenehanje nalaganja spro\u017eilcev pri izvedbi operacij, povezanih samo z branjem. Predhodno so se spro\u017eilci nalagali ob vsakem dostopu do tabele, kar je pove\u010devalo porabo pomnilnika in obremenjevalo CPU v situacijah, ko spro\u017eilci niso bili uporabljeni (na primer, pri izvedbi SELECT poizvedb). V MySQL 9.1 je obravnava in nalaganje spro\u017eilcev razdeljena na dve fazi: branje metapodatkov o spro\u017eilcu in raz\u010dlenitev + izvedba spro\u017eilca. Podatki, pridobljeni v prvi fazi, se enkrat shranijo in nato skupno uporabljajo v razli\u010dnih instancah spro\u017eilca. Raz\u010dlenitev in izvedba spro\u017eilca poteka samo za izraze, ki povzro\u010dajo spremembo podatkov. Poleg tega je za zmanj\u0161anje porabe pomnilnika namesto stati\u010dnega dodeljevanja pomnilnika za obravnavo napak v spro\u017eilcih pre\u0161lo na dinami\u010dno dodeljevanje pomnilnika po potrebi.\n<li class=\"l\"> Izpis operacije \u201eEXPLAIN\u201c je raz\u0161irjen, saj zdaj prikazuje informacije o uporabi ve\u010dobmo\u010dnega branja (multi-range) in uporabi strategije polskega zdru\u017eevanja (semijoin), pri kateri se pri operacijah JOIN obravnavajo le vrstice iz ene tabele.\n<li class=\"l\"> Zagotovljeno je atomsko izvajanje operacij \u201eCREATE DATABASE\u201c in \u201eDROP DATABASE\u201c za za\u0161\u010dito pred napakami v primeru nenadnega zaklju\u010dka ali napak na ravni datote\u010dnega sistema med izvajanjem teh operacij. Na primer, prej je lahko pri nenadnem zaklju\u010dku operacije \u201eCREATE DATABASE\u201c nastala nepopolna neuporabna struktura skladi\u0161\u010da baze podatkov, katere \u010di\u0161\u010denje je zahtevalo ro\u010dno posredovanje.\n<li class=\"l\"> V napisani JavaScript shranjeni proceduri je zagotovljena podpora za tip VECTOR. Podatki s to\u010dno dolo\u010denim tipom zdaj lahko prehajajo v vhodnih in vrnjenih parametrih.\n<li class=\"l\"> Dodana je mo\u017enost avtentikacije pri povezovanju s SDBM z uporabo protokola OpenID Connect.\n<li class=\"l\"> Odpravljeno je bilo 27 ranljivosti, od katerih je bila najresnej\u0161a (CVE-2024-5535) ozna\u010dena kot kriti\u010dno nevarna (9,1 od 10). Ranljivost se lahko izkoristi na daljavo brez prehajanja avtentikacije. Te\u017eavo povzro\u010da branje podatkov iz obmo\u010dja zunaj dodeljenega pomnilnika v knji\u017enici OpenSSL, kar vodi do nujnega zaklju\u010dka ali uhajanja vsebine pomnilnika v odgovoru po povezavi z <a class=\"wpil_keyword_link\" href=\"https:\/\/prohoster.info\/sl\/server\/dts-prohoster\/\"   title=\"serverom\" data-wpil-keyword-link=\"linked\"  data-wpil-monitor-id=\"3093\">serverom<\/a>  z navedbo nepravilnih parametrov protokola.       <\/ul>\n<p>Izvor: <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\/sl\/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=\"sl_SI\" \/>\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\/sl\/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\udd47Izdaja SDBM MySQL 9.1.0 | ProHoster","description":"Podjetje Oracle je oblikovalo novo vejo SDBM MySQL 9.1.0. Zgradbe MySQL Community Server 9.1.0 so pripravljene za vse glavne distribucije Linuxa, FreeBSD, macOS in Windows.","canonical_url":"https:\/\/prohoster.info\/sl\/blog\/news\/vypusk-subd-mysql-9-1-0","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"sl_SI","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\/sl\/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\/sl\/wp-json\/wp\/v2\/posts\/120215","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/sl\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/sl\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sl\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sl\/wp-json\/wp\/v2\/comments?post=120215"}],"version-history":[{"count":1,"href":"https:\/\/prohoster.info\/sl\/wp-json\/wp\/v2\/posts\/120215\/revisions"}],"predecessor-version":[{"id":160374,"href":"https:\/\/prohoster.info\/sl\/wp-json\/wp\/v2\/posts\/120215\/revisions\/160374"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sl\/wp-json\/wp\/v2\/media?parent=120215"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sl\/wp-json\/wp\/v2\/categories?post=120215"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sl\/wp-json\/wp\/v2\/tags?post=120215"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}