{"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\/ro\/blog\/news\/vypusk-subd-mysql-9-1-0","title":{"rendered":"Lansarea SGBD MySQL 9.1.0","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Compania Oracle a format o nou\u0103 ramur\u0103 a SGBD-ului MySQL 9.1.0. Construc\u021biile MySQL Community Server 9.1.0 sunt preg\u0103tite pentru toate principalele distribu\u021bii de Linux, FreeBSD, macOS \u0219i Windows. \u00cen cadrul modelului nou de formare a versiunilor introdus anul trecut, MySQL 9.1 este clasificat ca parte a ramurilor \u201eInova\u021bie\u201d, la care va fi alocat \u0219i urm\u0103torul release major MySQL 9.2. Ramurile de Inova\u021bie sunt recomandate pentru cei care doresc s\u0103 aib\u0103 acces mai devreme la func\u021bionalit\u0103\u021bi noi, fiind publicate la fiecare 3 luni \u0219i sus\u021binute doar p\u00e2n\u0103 la publicarea urm\u0103torului release major (de exemplu, suportul pentru ramura 9.0 a fost oprit dup\u0103 apari\u021bia ramurii 9.1). Vara anului viitor se preconizeaz\u0103 formarea unei versiuni LTS, recomandate pentru implement\u0103ri care necesit\u0103 predictibilitate \u0219i comportament constant pe termen lung. Urm\u0103toarea ramur\u0103 de Inova\u021bie va fi MySQL 10.0.        <\/p>\n<p>Principalele modific\u0103ri \u00een MySQL 9.1:  <\/p>\n<ul>\n<li class=\"l\"> Opera\u021bia \u201eCREATE VIEW\u201d a fost \u00eembog\u0103\u021bit\u0103 cu suportul expresiei \u201eIF NOT EXISTS\u201d, care permite crearea vizualiz\u0103rii doar dac\u0103 \u0219i vizualizarea cu numele specificat nu exist\u0103 \u00eenc\u0103, evit\u00e2nd astfel returnarea unei erori \u00een cazul \u00een care vizualizarea a fost deja creat\u0103.\n<li class=\"l\"> \u00cenc\u0103rcarea triggerelor a fost oprit\u0103 \u00een timpul opera\u021biunilor legate doar de citire. Anterior, trigger-urile erau \u00eenc\u0103rcate la orice acces la tabel, ceea ce ducea la consumul de memorie \u0219i la crearea unei sarcini pe CPU \u00een situa\u021biile \u00een care trigger-urile nu erau utilizate (de exemplu, la executarea interog\u0103rilor SELECT). \u00cen MySQL 9.1, procesarea \u0219i \u00eenc\u0103rcarea trigger-urilor este \u00eemp\u0103r\u021bit\u0103 \u00een dou\u0103 etape: citirea metadatelor despre trigger \u0219i interpretarea + executarea trigger-ului. Datele ob\u021binute \u00een prima etap\u0103 sunt p\u0103strate o singur\u0103 dat\u0103 \u0219i utilizate \u00een comun \u00een diverse instan\u021be ale trigger-ului. Interpretarea \u0219i executarea trigger-ului se realizeaz\u0103 doar pentru expresiile care duc la modificarea datelor. \u00cen plus, pentru a reduce consumul de memorie, s-a trecut de la alocarea static\u0103 a bufferelor pentru gestionarea erorilor \u00een trigger-e la o alocare dinamic\u0103 a memoriei, dup\u0103 necesitate.\n<li class=\"l\"> A fost extins\u0103 ie\u0219irea opera\u021biei \u201eEXPLAIN\u201d, care acum afi\u0219eaz\u0103 informa\u021bii despre utilizarea citirii multi-gama (multi-range) \u0219i aplicarea strategiei semi-join, \u00een care, \u00een timpul opera\u021biunilor JOIN, sunt procesate doar r\u00e2ndurile dintr-o singur\u0103 tabel\u0103.\n<li class=\"l\"> S-a asigurat execu\u021bia atomic\u0103 a opera\u021biunilor \u201eCREATE DATABASE\u201d \u0219i \u201eDROP DATABASE\u201d pentru a proteja \u00eempotriva defec\u021biunilor \u00een caz de \u00eenchidere necontrolat\u0103 sau apari\u021bia erorilor la nivel de sistem de fi\u0219iere \u00een timpul execut\u0103rii acestor opera\u021biuni. De exemplu, anterior, \u00een cazul \u00eenchiderii necontrolate a \u201eCREATE DATABASE\u201d, putea fi creat\u0103 o structur\u0103 incomplet\u0103 \u0219i nefunc\u021bional\u0103 a bazei de date, pentru cur\u0103\u021barea c\u0103reia era necesar\u0103 interven\u021bia manual\u0103.\n<li class=\"l\"> Procedurile stocate scrise \u00een JavaScript ofer\u0103 suport pentru tipul VECTOR. Datele cu acest tip pot fi acum transmise \u00een parametrii de intrare \u0219i ie\u0219ire.\n<li class=\"l\"> A fost ad\u0103ugat\u0103 posibilitatea autentific\u0103rii la conectarea la SGBD folosind protocolul OpenID Connect.\n<li class=\"l\"> Au fost remediate 27 de vulnerabilit\u0103\u021bi, cea mai grav\u0103 dintre ele (CVE-2024-5535) av\u00e2nd un nivel critic de severitate (9.1 din 10). Vulnerabilitatea poate fi exploatat\u0103 de la distan\u021b\u0103 f\u0103r\u0103 a necesita autentificarea. Problema este cauzat\u0103 de citirea datelor dintr-o zon\u0103 dincolo de bufferul alocat \u00een biblioteca OpenSSL \u0219i duce la \u00eenchideri nea\u0219teptate sau scurgeri de con\u021binut din memorie \u00een r\u0103spunsul dup\u0103 conectarea cu <a class=\"wpil_keyword_link\" href=\"https:\/\/prohoster.info\/ro\/server\/dts-prohoster\/\"   title=\"serverul\" data-wpil-keyword-link=\"linked\"  data-wpil-monitor-id=\"3093\">serverul<\/a>  parametrii incorec\u021bi ai protocolului.       <\/ul>\n<p>Sursa: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=62067\">opennet.ro<\/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.2.1 - 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\/ro\/blog\/news\/vypusk-subd-mysql-9-1-0\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.2.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"ro_RO\" \/>\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\/ro\/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\udd47Lansare SGBD MySQL 9.1.0 | ProHoster","description":"Compania Oracle a format un nou ramur\u0103 a SGBD MySQL 9.1.0. Versiunile MySQL Community Server 9.1.0 sunt preg\u0103tite pentru toate principalele distribu\u021bii Linux, FreeBSD, macOS \u0219i Windows.","canonical_url":"https:\/\/prohoster.info\/ro\/blog\/news\/vypusk-subd-mysql-9-1-0","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"ro_RO","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\/ro\/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\/ro\/wp-json\/wp\/v2\/posts\/120215","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/comments?post=120215"}],"version-history":[{"count":1,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/posts\/120215\/revisions"}],"predecessor-version":[{"id":160374,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/posts\/120215\/revisions\/160374"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/media?parent=120215"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/categories?post=120215"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/tags?post=120215"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}