{"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\/et\/blog\/news\/dostupna-subd-mysql-8-3-0","title":{"rendered":"Saadaval on andmebaas MySQL 8.3.0","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Oracle on loonud uue andmebaasi MySQL 8.3 haru ja avaldanud parandava v\u00e4rskenduse MySQL 8.0.36. MySQL Community Server 8.3.0 versioonid on valmistatud ette k\u00f5ikide peamiste Linuxi, FreeBSD, macOS ja Windows jaotuste jaoks.    <\/p>\n<p>MySQL 8.3.0 on kolmas v\u00e4ljaanne, mis on loodud uue v\u00e4ljaande mudeli raames, mis h\u00f5lmab kahte t\u00fc\u00fcpi MySQL haru \u2013 'Innovation' ja 'LTS'. Innovation harud, kuhu kuuluvad MySQL 8.1, 8.2 ja 8.3, on soovitatavad neile, kes soovivad varakult juurdep\u00e4\u00e4su uutele funktsioonidele. Need harud avaldatakse iga 3 kuu tagant ning neid toetatakse ainult kuni j\u00e4rgmise olulise v\u00e4ljaande avaldamiseni (nt p\u00e4rast 8.3 haru ilmumist l\u00f5petatakse 8.2 toe andmine). LTS-harud on soovitatavad rakenduste jaoks, mis vajavad ennustatavust ja pikaajalist muutumatut k\u00e4itumist. LTS harusid avaldatakse iga kahe aasta tagant ja neid toetatakse 5 aastat, millele lisandub veel 3 aastat pikendatud toetust. Kevadel 2024 oodatakse MySQL 8.4 LTS-v\u00e4ljaannet, p\u00e4rast mida moodustatakse uus Innovation-haru 9.0.        <\/p>\n<p>Peamised muudatused MySQL 8.3:  <\/p>\n<ul>\n<li class=\"l\"> Parandatud on 25 haavatavust, millest \u00fcks (CVE-2023-5363, m\u00f5jutab OpenSSL-i) v\u00f5ib olla kaugelt \u00e4ra kasutatakse. K\u00f5ige t\u00f5sisem probleem, mis on seotud Kerberose protokolli kasutamisega, on hinnatud 8.8 ohu tasemele. V\u00e4hem ohtlikud haavatavused, mille ohu tase on 6.5, puudutavad optimeerijat, UDF-i, DDL-i, DML-i, replikatsiooni, privileegis\u00fcsteemi ja kr\u00fcpteerimist\u00f6\u00f6riistu.\n<li class=\"l\"> Linuxi platvormil on lisatud support mooduli kompmvali. Selle aktiveerimiseks on ette n\u00e4htud valik '-DWITH_LD=mold|lld'.\n<li class=\"l\"> C++ standardi n\u00f5uded on t\u00f5stetud C++17-lt C++20-le.\n<li class=\"l\"> Toetuse l\u00f5petamine Boost C++ v\u00e4liste raamatukogudega koostamisel \u2013 n\u00fc\u00fcd kasutatakse MySQL kompileerimisel ainult sisseehitatud Boost raamatukogusid. CMake-st on eemaldatud ehitusvalikud WITH_BOOST, DOWNLOAD_BOOST ja DOWNLOAD_BOOST_TIMEOUT.\n<li class=\"l\"> Toetust Visual Studio 2022 kogumile on l\u00f5petatud. Minimalne toetatud Clangi t\u00f6\u00f6riistade versioon on t\u00f5stetud Clang 10-lt Clang 12-le.\n<li class=\"l\"> MySQL Enterprise Edition'is on lisatud toetus telemeetriate kogumiseks t\u00f6\u00f6metriikidega <a class=\"wpil_keyword_link\" href=\"https:\/\/prohoster.info\/et\/server\/dts-los-angeles\/\"   title=\"serverilt\" data-wpil-keyword-link=\"linked\"  data-wpil-monitor-id=\"3680\">serverilt<\/a> OpenTelemetry formaadis ja andmete edastamiseks toetavale v\u00f5rgut\u00f6\u00f6tlejale.\n<li class=\"l\"> GTID (globaalne tehingu identifikaator) identifikaatorite vormingut on laiendatud, mida kasutatakse replikatsioonil tehingur\u00fchma tuvastamiseks. Uus GTID vorming on 'UUID::NUMBER' (asemel 'UUID:NUMBER'), kus TAG on suvaline string, mis v\u00f5imaldab m\u00e4\u00e4rata unikaalsed nimed kindlale tehingute grupile, et lihtsustada t\u00f6\u00f6tlemist ja anal\u00fc\u00fcsi.\n<li class=\"l\"> Lisatud on kaks uut muutujat 'Deprecated_use_i_s_processlist_count' ja 'Deprecated_use_i_s_processlist_last_timestamp' vananenud INFORMATION_SCHEMA.PROCESSLIST tabeli kasutamise j\u00e4lgimiseks.\n<li class=\"l\"> Keskkonnamuutuja AUTHENTICATION_PAM_LOG seadmine ei too enam kaasa paroolide kuvamist diagnostilistes teadetes (parooli mainimiseks peab olema m\u00e4\u00e4ratud v\u00e4\u00e4rtus PAM_LOG_WITH_SECRET_INFO).\n<li class=\"l\"> Lisatud tabel tp_connections, mis sisaldab teavet iga poole l\u00f5ime (thread pool) \u00fchenduse kohta.\n<li class=\"l\"> Lisatud on s\u00fcsteemimuutuja 'explain_json_format_version', et valida JSON formaadi versioon, mida kasutatakse 'EXPLAIN FORMAT=JSON' avaldustes.\n<li class=\"l\"> InnoDB salvestuses on eemaldatud parameetrid '--innodb' ja '--skip-innodb', mis kuulutati vananenuks juba MySQL 5.6 v\u00e4ljaandes. InnoDB-le on eemaldatud memcached pistikprogramm, mis kuulutati vananenuks MySQL 8.0.22.\n<li class=\"l\"> M\u00f5ned kopeerimisega seotud k\u00e4surea seaded ja valikud, mis olid varasemates v\u00e4ljaannetes vananevateks kuulutatud, on eemaldatud: \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. GTID-replikaatoriga (gtid_mode=ON) seotud IGNORE_SERVER_IDS valiku kasutamine on peatatud.\n<li class=\"l\"> C API funktsioonide tugi on l\u00f5petatud: mysql_kill(), mysql_list_fields(), mysql_list_processes(), mysql_refresh(), mysql_reload(), mysql_shutdown(), mysql_ssl_set().\n<li class=\"l\"> \u00abFLUSH HOSTS\u00bb v\u00e4ljendi tugi, mis kuulutati vananenuks MySQL 8.0.23, on peatatud.      <\/ul>\n<p>Allikas: <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\/et\/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=\"et_EE\" \/>\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\/et\/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\udd47MySQL andmebaas 8.3.0 on n\u00fc\u00fcd saadaval | ProHoster","description":"Oracle on loonud uue MySQL andmebaasi 8.3 hargne ja avaldanud paranduste t\u00e4iustuse MySQL 8.0.36.","canonical_url":"https:\/\/prohoster.info\/et\/blog\/news\/dostupna-subd-mysql-8-3-0","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"et_EE","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\/et\/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\/et\/wp-json\/wp\/v2\/posts\/112960","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/comments?post=112960"}],"version-history":[{"count":1,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts\/112960\/revisions"}],"predecessor-version":[{"id":162208,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts\/112960\/revisions\/162208"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/media?parent=112960"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/categories?post=112960"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/tags?post=112960"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}