{"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\/lv\/blog\/news\/dostupna-subd-mysql-8-3-0","title":{"rendered":"Pieejama DBMS MySQL 8.3.0","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Uz\u0146\u0113mums Oracle ir izveidojis jaunu MySQL 8.3 datu b\u0101zes noda\u013cu un public\u0113jis labojumu MySQL 8.0.36. MySQL Community Server 8.3.0 versijas ir sagatavotas vis\u0101m galvenaj\u0101m Linux, FreeBSD, macOS un Windows versij\u0101m.    <\/p>\n<p>MySQL 8.3.0 ir tre\u0161ais izlaidums, kas izveidots jaun\u0101 izlai\u0161anas mode\u013ca ietvaros, kur\u0101 ir divu veidu MySQL zaru \u2014 \u201eInnovation\u201d un \u201eLTS\u201d. Innovation zari, uz kuriem attiecas MySQL 8.1, 8.2 un 8.3, ir ieteicami tiem, kas v\u0113las \u0101tri piek\u013c\u016bt jaun\u0101m funkcij\u0101m. \u0160ie zari tiek public\u0113ti ik p\u0113c trim m\u0113ne\u0161iem un tiek atbalst\u012bti tikai l\u012bdz n\u0101kam\u0101 b\u016btisk\u0101 izlaiduma public\u0113\u0161anai (piem\u0113ram, p\u0113c 8.3 zara par\u0101d\u012b\u0161an\u0101s, atbalsts 8.2 zaram tiek p\u0101rtraukts). LTS zari ir ieteicami izstr\u0101diem, kuriem nepiecie\u0161ama prognoz\u0113jam\u012bba un ilgsto\u0161a nemain\u012bga uzved\u012bba. LTS zari tiks izlaisti reizi divos gados un tiks atbalst\u012bti regul\u0101ri 5 gadus, papildus tam v\u0113l 3 gadi pagarin\u0101t\u0101 atbalsta. 2024. gada pavasar\u012b ir gaid\u0101ms MySQL 8.4 LTS izlaidums, p\u0113c kura tiks izveidots jauns Innovation zaras 9.0.        <\/p>\n<p>Galven\u0101s izmai\u0146as MySQL 8.3:  <\/p>\n<ul>\n<li class=\"l\"> Tika nov\u0113rstas 25 ievainojam\u012bbas, no kur\u0101m viena (CVE-2023-5363, kas ietekm\u0113 OpenSSL) var tikt izmantota att\u0101lin\u0101ti. Visnopietn\u0101kajai probl\u0113mai, kas saist\u012bta ar Kerberos protokola izmanto\u0161anu, ir pie\u0161\u0137irta b\u012bstam\u012bbas pak\u0101pe 8.8. Maz\u0101k b\u012bstam\u0101m ievainojam\u012bb\u0101m ar b\u012bstam\u012bbas pak\u0101pi 6.5 ir nepiecie\u0161ams optimiz\u0113t\u0101js, UDF, DDL, DML, replik\u0101cija, privil\u0113\u0123iju sist\u0113ma un \u0161ifr\u0113\u0161anas l\u012bdzek\u013ci.\n<li class=\"l\"> Linux platform\u0101 ir pievienots mold linker atbalsts. Lai to iesp\u0113jotu, ir paredz\u0113ta opcija \u201e-DWITH_LD=mold|lld\u201d.\n<li class=\"l\"> Atbalsta pras\u012bbas C++ standartu ir paaugstin\u0101tas no C++17 uz C++20.\n<li class=\"l\"> Atbalsts \u0101r\u0113j\u0101m Boost C++ bibliot\u0113k\u0101m ir p\u0101rtraukts \u2014 MySQL kompil\u0113\u0161anai tagad tiek izmantotas tikai ieb\u016bv\u0113t\u0101s Boost bibliot\u0113kas. CMake ir iz\u0146emti kompil\u0113\u0161anas opcijas WITH_BOOST, DOWNLOAD_BOOST un DOWNLOAD_BOOST_TIMEOUT.\n<li class=\"l\"> Atbalsts b\u016bv\u0113\u0161anai Visual Studio 2022 ir p\u0101rtraukts. Minim\u0101l\u0101 atbalst\u012bt\u0101 Clang instrumentu versija ir paaugstin\u0101ta no Clang 10 l\u012bdz Clang 12.\n<li class=\"l\"> MySQL Enterprise Edition ir pievienots atbalsts telemetrijas datu apkopo\u0161anai ar metrik\u0101m par veiktsp\u0113ju <a class=\"wpil_keyword_link\" href=\"https:\/\/prohoster.info\/lv\/server\/dts-los-angeles\/\"   title=\"serveris\" data-wpil-keyword-link=\"linked\"  data-wpil-monitor-id=\"3680\">serveris<\/a> form\u0101t\u0101 OpenTelemetry un datu nodo\u0161anai uz t\u012bkla apstr\u0101d\u0101t\u0101ju, kas atbalsta \u0161o form\u0101tu.\n<li class=\"l\"> Ir papla\u0161in\u0101ts GTID (glob\u0101lais transakciju identifikators) identifikatoru form\u0101ts, kas tiek izmantots replik\u0101cij\u0101 transakciju grupu identific\u0113\u0161anai. Jaunais GTID form\u0101ts ir \u201eUUID::NUMBER\u201d (t\u0101 viet\u0101, lai b\u016btu \u201eUUID:NUMBER\u201d), kur TAG ir nejau\u0161a virkne, kas \u013cauj pie\u0161\u0137irt unik\u0101lus nosaukumus noteiktai transakciju grupai, lai vienk\u0101r\u0161otu apstr\u0101di un anal\u012bzi.\n<li class=\"l\"> Ir pievienotas divas jaunas main\u012bg\u0101s \u201eDeprecated_use_i_s_processlist_count\u201d un \u201eDeprecated_use_i_s_processlist_last_timestamp\u201d vec\u0101s INFORMATION_SCHEMA.PROCESSLIST tabulas izmanto\u0161anas izseko\u0161anai.\n<li class=\"l\"> Vides main\u012bg\u0101s AUTHENTICATION_PAM_LOG iestat\u012b\u0161ana vairs neizsauc paroli par\u0101d\u012b\u0161anu diagnostikas zi\u0146ojumos (paroles min\u0113\u0161anai ir nepiecie\u0161ama v\u0113rt\u012bbas pie\u0161\u0137ir\u0161ana PAM_LOG_WITH_SECRET_INFO).\n<li class=\"l\"> Pievienota tp_connections tabula ar inform\u0101ciju par katru savienojumu pavedienu lok\u0101 (thread pool).\n<li class=\"l\"> Ir pievienots sist\u0113mas main\u012bgais \u201eexplain_json_format_version\u201d JSON form\u0101ta versijas izv\u0113lei, kas tiek izmantota izteiksmes \u201eEXPLAIN FORMAT=JSON\u201d ietvaros.\n<li class=\"l\"> InnoDB kr\u0101tuv\u0113 ir no\u0146emti parametri \u201e\u2014innodb\u201d un \u201e\u2014skip-innodb\u201d, kuri tika pasludin\u0101ti par novecoju\u0161iem jau MySQL 5.6 izlaidum\u0101. InnoDB memcached spraudnis, kas tika pasludin\u0101ts par novecoju\u0161u MySQL 8.0.22, ir iz\u0146emts.\n<li class=\"l\"> Tika iev\u0113rojami ir atjaunin\u0101tas daudzas komandrindas iestat\u012bjumi un opcijas, kas saist\u012btas ar replik\u0101ciju, kuras iepriek\u0161\u0113j\u0101s versij\u0101s bija atz\u012btas par novecoju\u0161\u0101m: &#171;&#8212;slave-rows-search-algorithms&#187;, &#171;&#8212;relay-log-info-file&#187;, &#171;&#8212;relay-log-info-repository&#187;, &#171;&#8212;master-info-file&#187;, &#171;&#8212;master-info-repository&#187;, &#171;log_bin_use_v1_events&#187;, &#171;transaction_write_set_extraction&#187;, &#171;group_replication_ip_whitelist&#187;, &#171;group_replication_primary_member&#187;. Ir izbeigta IGNORE_SERVER_IDS opcijas izmanto\u0161ana ar GTID replik\u0101ciju (gtid_mode=ON).\n<li class=\"l\"> Atbalsts C API funkcij\u0101m ir p\u0101rtraukts: mysql_kill(), mysql_list_fields(), mysql_list_processes(), mysql_refresh(), mysql_reload(), mysql_shutdown(), mysql_ssl_set().\n<li class=\"l\"> Atbalsts izteicienam &#171;FLUSH HOSTS&#187; ir izbeigts, jo tas tika atz\u012bts par novecoju\u0161u MySQL 8.0.23.      <\/ul>\n<p>Avots: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=60453\">opennet.lv<\/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.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 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\/lv\/blog\/news\/dostupna-subd-mysql-8-3-0\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.4\" \/>\n\t\t<meta property=\"og:locale\" content=\"lv_LV\" \/>\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\/lv\/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\udd47Pieejama datub\u0101ze MySQL 8.3.0 | ProHoster","description":"Oracle uz\u0146\u0113mums ir izveidojis jaunu MySQL 8.3 datub\u0101zes versiju un public\u0113jis labojuma atjaunin\u0101jumu MySQL 8.0.36.","canonical_url":"https:\/\/prohoster.info\/lv\/blog\/news\/dostupna-subd-mysql-8-3-0","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"lv_LV","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\/lv\/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\/lv\/wp-json\/wp\/v2\/posts\/112960","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/comments?post=112960"}],"version-history":[{"count":1,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/posts\/112960\/revisions"}],"predecessor-version":[{"id":162208,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/posts\/112960\/revisions\/162208"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/media?parent=112960"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/categories?post=112960"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/tags?post=112960"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}