{"id":112960,"date":"2024-01-17T17:28:13","date_gmt":"2024-01-17T15:28:13","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/dostupna-subd-mysql-8-3-0"},"modified":"2024-01-17T17:28:13","modified_gmt":"2024-01-17T15:28:13","slug":"dostupna-subd-mysql-8-3-0","status":"publish","type":"post","link":"https:\/\/prohoster.info\/it\/blog\/news\/dostupna-subd-mysql-8-3-0","title":{"rendered":"Disponibile il DBMS MySQL 8.3.0","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Oracle ha creato un nuovo ramo del DBMS MySQL 8.3 e ha pubblicato un aggiornamento correttivo per MySQL 8.0.36. Le build di MySQL Community Server 8.3.0 sono preparate per tutte le principali distribuzioni di Linux, FreeBSD, macOS e Windows.    <\/p>\n<p>MySQL 8.3.0 \u00e8 la terza versione formata nell'ambito del nuovo modello di rilascio, che prevede due tipi di rami MySQL \u2014 \u00abInnovation\u00bb e \u00abLTS\u00bb. I rami Innovation, che includono MySQL 8.1, 8.2 e 8.3, sono raccomandati per coloro che desiderano accedere prima alle nuove funzionalit\u00e0. Questi rami vengono pubblicati ogni 3 mesi e sono supportati solo fino alla pubblicazione del successivo rilascio significativo (ad esempio, dopo l'arrivo del ramo 8.3, il supporto per il ramo 8.2 viene interrotto). I rami LTS sono consigliati per le implementazioni che necessitano di prevedibilit\u00e0 e di un comportamento stabile a lungo termine. I rami LTS verranno rilasciati ogni due anni e supportati per 5 anni in modo regolare, oltre a ulteriori 3 anni di supporto esteso. Il rilascio LTS MySQL 8.4 \u00e8 previsto per la primavera del 2024, dopo di che verr\u00e0 formato un nuovo ramo Innovation 9.0.        <\/p>\n<p>Modifiche principali in MySQL 8.3:  <\/p>\n<ul>\n<li class=\"l\"> Sono state corrette 25 vulnerabilit\u00e0, di cui una (CVE-2023-5363, che riguarda OpenSSL) pu\u00f2 essere sfruttata a distanza. Il problema pi\u00f9 serio legato all'uso del protocollo Kerberos ha un livello di pericolo di 8.8. Vulnerabilit\u00e0 meno gravi con un livello di pericolo di 6.5 riguardano l'ottimizzatore, UDF, DDL, DML, replica, sistema di privilegi e strumenti per la crittografia.\n<li class=\"l\"> Sulla piattaforma Linux \u00e8 stata aggiunta la supporto per il linker mold. Per attivarlo \u00e8 prevista l'opzione \u00ab-DWITH_LD=mold|lld\u00bb.\n<li class=\"l\"> I requisiti per il supporto del compilatore C++ sono stati innalzati da C++17 a C++20.\n<li class=\"l\"> Il supporto per la compilazione con le librerie esterne Boost C++ \u00e8 stato interrotto \u2014 ora MySQL utilizza solo le librerie Boost integrate. Le opzioni di compilazione WITH_BOOST, DOWNLOAD_BOOST e DOWNLOAD_BOOST_TIMEOUT sono state rimosse da CMake.\n<li class=\"l\"> \u00c8 stata interrotta la supporto per la costruzione in Visual Studio 2022. La versione minima del toolchain Clang supportata \u00e8 stata elevata da Clang 10 a Clang 12.\n<li class=\"l\"> Nella MySQL Enterprise Edition \u00e8 stata aggiunta la supporto per la raccolta di telemetria con metriche di operativit\u00e0 <a class=\"wpil_keyword_link\" href=\"https:\/\/prohoster.info\/it\/server\/dts-los-angeles\/\"   title=\"server\" data-wpil-keyword-link=\"linked\"  data-wpil-monitor-id=\"3680\">server<\/a> in formato OpenTelemetry e per la trasmissione dei dati a un gestore di rete che supporta questo formato.\n<li class=\"l\"> \u00c8 stato ampliato il formato degli identificatori GTID (global transaction identifier), utilizzato nella replicazione per identificare gruppi di transazioni. Il nuovo formato GTID \u00e8 \u00abUUID::NUMBER\u00bb (anzich\u00e9 \u00abUUID:NUMBER\u00bb), dove TAG \u00e8 una stringa arbitraria che consente di assegnare nomi unici a un determinato gruppo di transazioni per semplificare l'elaborazione e l'analisi.\n<li class=\"l\"> Sono state aggiunte due nuove variabili \u00abDeprecated_use_i_s_processlist_count\u00bb e \u00abDeprecated_use_i_s_processlist_last_timestamp\u00bb per monitorare l'utilizzo della tabella obsoleta INFORMATION_SCHEMA.PROCESSLIST.\n<li class=\"l\"> L'impostazione della variabile di ambiente AUTHENTICATION_PAM_LOG non porta pi\u00f9 alla visualizzazione delle password nei messaggi diagnostici (per menzionare la password \u00e8 necessario assegnare il valore PAM_LOG_WITH_SECRET_INFO).\n<li class=\"l\"> \u00c8 stata aggiunta la tabella tp_connections con informazioni su ogni connessione nel pool di thread.\n<li class=\"l\"> \u00c8 stata aggiunta una variabile di sistema \u00abexplain_json_format_version\u00bb per selezionare la versione del formato JSON utilizzato nelle espressioni \u00abEXPLAIN FORMAT=JSON\u00bb.\n<li class=\"l\"> Nello storage InnoDB sono stati rimossi i parametri \u00ab\u2014innodb\u00bb e \u00ab\u2014skip-innodb\u00bb, che erano stati dichiarati obsoleti gi\u00e0 nella versione MySQL 5.6. \u00c8 stato rimosso il plugin memcached per InnoDB, dichiarato obsoleto in MySQL 8.0.22.\n<li class=\"l\"> Sono state rimosse alcune impostazioni e opzioni della linea di comando relative alla replica, che erano state dichiarate obsolete in versioni precedenti: \u00ab--slave-rows-search-algorithms\u00bb, \u00ab--relay-log-info-file\u00bb, \u00ab--relay-log-info-repository\u00bb, \u00ab--master-info-file\u00bb, \u00ab--master-info-repository\u00bb, \u00ablog_bin_use_v1_events\u00bb, \u00abtransaction_write_set_extraction\u00bb, \u00abgroup_replication_ip_whitelist\u00bb, \u00abgroup_replication_primary_member\u00bb. \u00c8 stata disabilitata l'opzione IGNORE_SERVER_IDS con la modalit\u00e0 di replica GTID (gtid_mode=ON).\n<li class=\"l\"> \u00c8 stata interrotta la supporto delle funzioni C API: mysql_kill(), mysql_list_fields(), mysql_list_processes(), mysql_refresh(), mysql_reload(), mysql_shutdown(), mysql_ssl_set().\n<li class=\"l\"> \u00c8 stata interrotta la supporto dell'istruzione \u00abFLUSH HOSTS\u00bb, dichiarata obsoleta in MySQL 8.0.23.      <\/ul>\n<p>Fonte: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=60453\">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 8.3 \u0438 \u043e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043b\u0430 \u043a\u043e\u0440\u0440\u0435\u043a\u0442\u0438\u0440\u0443\u044e\u0449\u0435\u0435 \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u0435 MySQL 8.0.36. \u0421\u0431\u043e\u0440\u043a\u0438 MySQL Community Server 8.3.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. MySQL 8.3.0 \u044f\u0432\u043b\u044f\u0435\u0442\u0441\u044f \u0442\u0440\u0435\u0442\u044c\u0438\u043c \u0432\u044b\u043f\u0443\u0441\u043a\u043e\u043c, \u0441\u0444\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u043d\u043d\u044b\u043c \u0432 \u0440\u0430\u043c\u043a\u0430\u0445 \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, \u043f\u0440\u0435\u0434\u0443\u0441\u043c\u0430\u0442\u0440\u0438\u0432\u0430\u044e\u0449\u0435\u0439 \u043d\u0430\u043b\u0438\u0447\u0438\u0435 \u0434\u0432\u0443\u0445 \u0442\u0438\u043f\u043e\u0432 \u0432\u0435\u0442\u043e\u043a MySQL &#8212; &#171;Innovation&#187; \u0438 &#171;LTS&#187;. \u0412\u0435\u0442\u043a\u0438 Innovation, \u043a \u043a\u043e\u0442\u043e\u0440\u044b\u043c [&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-112960","post","type-post","status-publish","format-standard","hentry","category-news"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.1.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 8.3 \u0438 \u043e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043b\u0430 \u043a\u043e\u0440\u0440\u0435\u043a\u0442\u0438\u0440\u0443\u044e\u0449\u0435\u0435 \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u0435 MySQL 8.0.36.\" \/>\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\/it\/blog\/news\/dostupna-subd-mysql-8-3-0\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.1.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"it_IT\" \/>\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\u0414\u043e\u0441\u0442\u0443\u043f\u043d\u0430 \u0421\u0423\u0411\u0414 MySQL 8.3.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 8.3 \u0438 \u043e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043b\u0430 \u043a\u043e\u0440\u0440\u0435\u043a\u0442\u0438\u0440\u0443\u044e\u0449\u0435\u0435 \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u0435 MySQL 8.0.36.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/it\/blog\/news\/dostupna-subd-mysql-8-3-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-01-17T15:28:13+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2024-01-17T15:28:13+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\udd47Il DBMS MySQL 8.3.0 \u00e8 disponibile | ProHoster","description":"Oracle ha creato un nuovo ramo del DBMS MySQL 8.3 e ha pubblicato un aggiornamento correttivo per MySQL 8.0.36.","canonical_url":"https:\/\/prohoster.info\/it\/blog\/news\/dostupna-subd-mysql-8-3-0","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"it_IT","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\u0414\u043e\u0441\u0442\u0443\u043f\u043d\u0430 \u0421\u0423\u0411\u0414 MySQL 8.3.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 8.3 \u0438 \u043e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043b\u0430 \u043a\u043e\u0440\u0440\u0435\u043a\u0442\u0438\u0440\u0443\u044e\u0449\u0435\u0435 \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u0435 MySQL 8.0.36.","og:url":"https:\/\/prohoster.info\/it\/blog\/news\/dostupna-subd-mysql-8-3-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-01-17T15:28:13+00:00","article:modified_time":"2024-01-17T15:28:13+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"112960","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":null,"breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2026-02-22 15:29:48","updated":"2026-02-22 15:29:48","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/it\/wp-json\/wp\/v2\/posts\/112960","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/it\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/it\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/it\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/it\/wp-json\/wp\/v2\/comments?post=112960"}],"version-history":[{"count":1,"href":"https:\/\/prohoster.info\/it\/wp-json\/wp\/v2\/posts\/112960\/revisions"}],"predecessor-version":[{"id":162208,"href":"https:\/\/prohoster.info\/it\/wp-json\/wp\/v2\/posts\/112960\/revisions\/162208"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/it\/wp-json\/wp\/v2\/media?parent=112960"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/it\/wp-json\/wp\/v2\/categories?post=112960"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/it\/wp-json\/wp\/v2\/tags?post=112960"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}