{"id":121458,"date":"2025-01-23T15:46:10","date_gmt":"2025-01-23T13:46:10","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/vypusk-subd-mysql-9-2-0"},"modified":"2025-01-23T15:46:10","modified_gmt":"2025-01-23T13:46:10","slug":"vypusk-subd-mysql-9-2-0","status":"publish","type":"post","link":"https:\/\/prohoster.info\/da\/blog\/news\/vypusk-subd-mysql-9-2-0","title":{"rendered":"Udgivelse af MySQL DBMS 9.2.0","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Oracle har dannet en ny gren af databasesystemet MySQL 9.2.0. MySQL Community Server 9.2.0-bygninger er tilg\u00e6ngelige for alle st\u00f8rre Linux-distributioner, FreeBSD, macOS og Windows. Under det nye release-format, der blev indf\u00f8rt i 2023, er MySQL 9.2 blevet klassificeret under \"Innovation\"-grenene, som ogs\u00e5 vil inkludere den n\u00e6ste store udgivelse, MySQL 9.3. Innovation-grene anbefales til dem, der \u00f8nsker tidlig adgang til nye funktioner, og de udgives hvert tredje m\u00e5ned, mens de kun underst\u00f8ttes indtil udgivelsen af den n\u00e6ste betydelige version (f.eks. stoppes underst\u00f8ttelsen af gren 9.1 efter lanceringen af gren 9.2). Om sommeren planl\u00e6gges en LTS-udgivelse, der anbefales til implementeringer, der har brug for forudsigelighed og langvarig stabilitet. Efter LTS-grenen vil en ny Innovation-gren blive dannet - MySQL 10.0.        <\/p>\n<p>Vigtige \u00e6ndringer i MySQL 9.2:  <\/p>\n<ul>\n<li class=\"l\"> I MLE (Multilingual Engine Component) er der tilf\u00f8jet underst\u00f8ttelse af genbrugelige biblioteker skrevet i JavaScript til lagrede procedurer og funktioner. Funktioner fra s\u00e5danne biblioteker kan kaldes fra lagrede procedurer p\u00e5 JavaScript, men de skal eksplicit m\u00e6rkes som importerede med n\u00f8gleordet \"export\". Der er tilf\u00f8jet nye SQL-udtryk \"CREATE LIBRARY\" og \"DROP LIBRARY\" til at styre forbindelsen af JavaScript-biblioteker. Udtrykket \"SHOW CREATE LIBRARY\" er blevet tilf\u00f8jet for at vise listen over tilg\u00e6ngelige JavaScript-biblioteker. Oplysninger om JavaScript-biblioteker vises i systemtabellen \"LIBRARIES\", mens oplysninger om lagrede procedurer, der bruger s\u00e5danne biblioteker, findes i tabellen \"ROUTINE_LIBRARIES\". Tilslutningen af biblioteker i lagrede procedurer sker ved at angive en liste af biblioteker i udtrykket \"USING\".\n<li class=\"l\"> Der er tilf\u00f8jet API til adgang til lagrede procedurer, funktioner og session-variabler fra JavaScript-kode. Der er tilf\u00f8jet metoden getFunction() til at f\u00e5 adgang til MySQL-funktioner, og metoden getProcedure() til lagrede procedurer, som returnerer et JavaScript-objekt Function, der kan k\u00f8res med argumenter. Adgang til variabler sker direkte som egenskaber af JavaScript-objektet Session. Derudover er der tilf\u00f8jet mulighed for direkte adgang til de indbyggede funktioner rand(), sleep(), uuid() og isUUID(), som svarer til de tilsvarende SQL-funktioner.\n<li class=\"l\"> API til h\u00e5ndtering af transaktioner fra JavaScript er tilf\u00f8jet, hvilket g\u00f8r det muligt at udf\u00f8re handlinger med de fleste SQL-udtryk vedr\u00f8rende transaktioner, s\u00e5som  &#171;START TRANSACTION&#187;, &#171;COMMIT&#187;, &#171;ROLLBACK&#187; og &#171;SET AUTOCOMMIT&#187;.\n<li class=\"l\"> Muligheden for at bruge MySQL-typerne ENUM og SET i argumenterne for lagrede procedurer skrevet i JavaScript er blevet tilf\u00f8jet.\n<li class=\"l\"> Privilegiet CREATE_SPATIAL_REFERENCE_SYSTEM er tilf\u00f8jet, som g\u00f8r det muligt at styre muligheden for at oprette og slette definitioner af rumlig datal\u00e5sning i geografiske informationssystemer. Tilstedev\u00e6relsen af dette privilegium eller privilegiet SUPER er nu p\u00e5kr\u00e6vet for at udf\u00f8re udtryk som &#171;CREATE SPATIAL REFERENCE SYSTEM&#187;, &#171;CREATE OR REPLACE SPATIAL REFERENCE SYSTEM&#187; og &#171;DROP SPATIAL REFERENCE SYSTEM&#187;.\n<li class=\"l\"> Information om versionen af JSON-formatet er tilf\u00f8jet i outputtet &#171;EXPLAIN FORMAT=JSON&#187;. For at angive versionen af JSON-formatet skal variablen explain_json_format_version anvendes (&#171;SET explain_json_format_version=1|2&#187;).\n<li class=\"l\"> F\u00f8lgende er erkl\u00e6ret som for\u00e6ldede: udtrykket &#171;FLUSH PRIVILEGES&#187;, kommandoerne &#171;mysqladmin flush-privileges&#187; og &#171;mysqladmin reload&#187;, og pluginet &#171;version_tokens&#187;.\n<li class=\"l\"> St\u00f8tten til n\u00f8gleordet BINLOG er blevet stoppet.\n<li class=\"l\"> 32 s\u00e5rbarheder er blevet rettet, hvoraf 3 kan udnyttes eksternt. De to mest alvorlige problemer har en faregrad p\u00e5 9.1 og er relateret til s\u00e5rbarheder i komponenterne Kerberos og Curl. Mindre farlige s\u00e5rbarheder p\u00e5virker InnoDB, Thread Pooling, DDL, optimering, parser og autentificeringssystemet.     <\/ul>\n<p>Kilde: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=62603\">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.2.0. \u0421\u0431\u043e\u0440\u043a\u0438 MySQL Community Server 9.2.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 2023 \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.2 \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.3. 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-121458","post","type-post","status-publish","format-standard","hentry","category-news"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.3 - 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.2.0. \u0421\u0431\u043e\u0440\u043a\u0438 MySQL Community Server 9.2.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\/da\/blog\/news\/vypusk-subd-mysql-9-2-0\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.3\" \/>\n\t\t<meta property=\"og:locale\" content=\"da_DK\" \/>\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.2.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.2.0. \u0421\u0431\u043e\u0440\u043a\u0438 MySQL Community Server 9.2.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\/da\/blog\/news\/vypusk-subd-mysql-9-2-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=\"2025-01-23T13:46:10+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2025-01-23T13:46:10+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\udd47Udgivelsen af databasesystemet MySQL 9.2.0 | ProHoster","description":"Oracle har dannet en ny gren af databasesystemet MySQL 9.2.0. Bygningerne af MySQL Community Server 9.2.0 er forberedt til alle st\u00f8rre distributioner af Linux, FreeBSD, macOS og Windows.","canonical_url":"https:\/\/prohoster.info\/da\/blog\/news\/vypusk-subd-mysql-9-2-0","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"da_DK","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.2.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.2.0. \u0421\u0431\u043e\u0440\u043a\u0438 MySQL Community Server 9.2.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\/da\/blog\/news\/vypusk-subd-mysql-9-2-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":"2025-01-23T13:46:10+00:00","article:modified_time":"2025-01-23T13:46:10+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"121458","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-01-23 09:56:19","breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2026-01-23 09:56:19","updated":"2026-01-23 09:56:19","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/da\/wp-json\/wp\/v2\/posts\/121458","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/da\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/da\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/da\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/da\/wp-json\/wp\/v2\/comments?post=121458"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/da\/wp-json\/wp\/v2\/posts\/121458\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/da\/wp-json\/wp\/v2\/media?parent=121458"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/da\/wp-json\/wp\/v2\/categories?post=121458"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/da\/wp-json\/wp\/v2\/tags?post=121458"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}