{"id":146187,"date":"2025-10-23T17:12:00","date_gmt":"2025-10-23T15:12:00","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/vypusk-subd-mysql-9-5-0"},"modified":"2025-10-23T17:12:00","modified_gmt":"2025-10-23T15:12:00","slug":"vypusk-subd-mysql-9-5-0","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sv\/blog\/news\/vypusk-subd-mysql-9-5-0","title":{"rendered":"Utg\u00e5van av databashanteraren MySQL 9.5.0","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Oracle har skapat en ny gren av databashanteraren MySQL 9.5.0. Byggnaderna av MySQL Community Server 9.5.0 \u00e4r f\u00f6rberedda f\u00f6r alla st\u00f6rre Linux-distributioner, FreeBSD, macOS och Windows. I enlighet med den sl\u00e4ppmodell som inf\u00f6rdes 2023, har MySQL 9.5 klassificerats som en &#171;Innovation&#187;-gren. Innovation-grenar rekommenderas f\u00f6r dem som vill ha tidig \u00e5tkomst till ny funktionalitet, publiceras var tredje m\u00e5nad och st\u00f6ds endast fram till publiceringen av n\u00e4sta betydande version (till exempel, efter att gren 9.5 publicerades, upph\u00f6rde st\u00f6det f\u00f6r gren 9.4). P\u00e5 vintern planeras en LTS-version 9.6 att skapas, vilken rekommenderas f\u00f6r implementeringar som beh\u00f6ver f\u00f6ruts\u00e4gbarhet och l\u00e5ngvarigt of\u00f6r\u00e4ndrat beteende. Efter LTS-grenen kommer en ny Innovation-gren att skapas - MySQL 10.0.      <\/p>\n<p>Huvudsakliga f\u00f6r\u00e4ndringar i MySQL 9.5:  <\/p>\n<ul>\n<li class=\"l\"> En ny option &#171;activate_mandatory_roles&#187; har lagts till f\u00f6r ut\u00f6kat rollhantering - n\u00e4r inst\u00e4llningen &#171;activate_all_roles_on_login&#187; \u00e4r avst\u00e4ngd och &#171;activate_mandatory_roles&#187; \u00e4r aktiverad, s\u00e5 aktiveras st\u00f6d f\u00f6r obligatoriska roller (som automatiskt tilldelas anv\u00e4ndaren vid inloggning) ut\u00f6ver de standardroller som finns.\n<li class=\"l\"> I MySQL Multilingual Engine-pluginet har st\u00f6d f\u00f6r specifikationen ECMAScript 2025 lagts till i JavaScript-implementeringen.\n<li class=\"l\"> En verktyg mysqldm (MySQL Diagnostic Monitor) har lagts till, avsedd f\u00f6r insamling av diagnostisk information (analys av exekveringen av en f\u00f6rdefinierad upps\u00e4ttning fr\u00e5gor), som kan \u00f6verl\u00e4mnas av anv\u00e4ndaren till supporttj\u00e4nsten f\u00f6r att underl\u00e4tta fels\u00f6kning.\n<li class=\"l\"> M\u00f6jlighet till simultan installation av b\u00e5de vanliga och LTS-versioner av MySQL har lagts till.\n<li class=\"l\"> I standardinst\u00e4llningarna f\u00f6r replikation har ut\u00f6kade skydds\u00e5tg\u00e4rder aktiverats, vilket inneb\u00e4r anv\u00e4ndning av kryptering f\u00f6r alla anslutningar vid replikation.\n<li class=\"l\"> I MySQL Thread Pool-pluginet har automatisk inst\u00e4llning av parametrar f\u00f6r att uppn\u00e5 maximal prestanda med h\u00e4nsyn till den befintliga h\u00e5rdvarukonfigurationen implementerats.\n<li class=\"l\"> Beteendet f\u00f6r parametern &#171;innodb_log_writer_threads&#187; har \u00e4ndrats, d\u00e4r aktiveringen av denna nu per standard beror p\u00e5 den aktiva l\u00e4get f\u00f6r bin\u00e4ra redo-loggar (log_bin). N\u00e4r &#171;log_bin&#187; \u00e4r avst\u00e4ngt, aktiveras parametern &#171;innodb_log_writer_threads&#187; f\u00f6r system med mer \u00e4n 4 logiska CPU:er, och n\u00e4r den \u00e4r aktiverad - f\u00f6r system med mer \u00e4n 31 logiska CPU:er.\n<li class=\"l\"> Som standard har v\u00e4rdet f\u00f6r parametern &#171;binlog_transaction_dependency_history_size&#187; \u00f6kat fr\u00e5n 25 000 till en miljon. Det maximala m\u00f6jliga v\u00e4rdet f\u00f6r denna parameter har \u00f6kat fr\u00e5n 1 till 10 miljoner.\n<li class=\"l\"> Standardv\u00e4rdet f\u00f6r parametern &#171;caching_sha2_password_digest_rounds&#187; har \u00f6kats till 10 000.\n<li class=\"l\"> Anv\u00e4ndningen av autentiseringsmetoden SCRAM-SHA-1 vid anslutning till SASL LDAP har f\u00f6rklarats som f\u00f6r\u00e5ldrad. Ist\u00e4llet b\u00f6r autentiseringsmetoden SCRAM-SHA-256 anv\u00e4ndas, vilken nu anges som standard i parametern &#171;authentication_ldap_sasl_auth_method_name&#187;.\n<li class=\"l\"> St\u00f6det f\u00f6r variablerna &#171;group_replication_allow_local_lower_version_join&#187; och &#171;replica_parallel_type&#187; har upph\u00f6rt, d\u00e5 de tidigare f\u00f6rklarades som f\u00f6r\u00e5ldrade.\n<li class=\"l\"> St\u00f6det f\u00f6r byggnation p\u00e5 Solaris-plattformen med Clang och GCC har lagts till. M\u00f6jligheten att anv\u00e4nda OpenSSL 3 p\u00e5 Solaris har \u00e4ven lagts till.\n<li class=\"l\"> Den minimi st\u00f6dda versionen av CMake har h\u00f6jts till 3.17.5.\n<li class=\"l\"> Nio s\u00e5rbarheter har \u00e5tg\u00e4rdats, d\u00e4r den mest allvarliga bed\u00f6ms ha en farlighetsniv\u00e5 p\u00e5 5,5 av 10. Detaljer meddelas inte, endast att s\u00e5rbarheterna finns i InnoDB, DML och optimeraren. F\u00f6r att utnyttja s\u00e5rbarheterna kr\u00e4vs autentiserad \u00e5tkomst till databashanteringssystemet.   <\/ul>\n<p>K\u00e4lla: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=64100\">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.5.0. \u0421\u0431\u043e\u0440\u043a\u0438 MySQL Community Server 9.5.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 \u0441\u043e\u043e\u0442\u0432\u0435\u0442\u0441\u0442\u0432\u0438\u0438 \u0441 \u0432\u043d\u0435\u0434\u0440\u0451\u043d\u043d\u043e\u0439 \u0432 2023 \u0433\u043e\u0434\u0443 \u043c\u043e\u0434\u0435\u043b\u044c\u044e \u0444\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u0440\u0435\u043b\u0438\u0437\u043e\u0432, MySQL 9.5 \u043e\u0442\u043d\u0435\u0441\u0451\u043d \u043a \u0432\u0435\u0442\u043a\u0430\u043c &#171;Innovation&#187;. 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 \u0440\u0430\u043d\u044c\u0448\u0435 \u043f\u043e\u043b\u0443\u0447\u0430\u0442\u044c \u0434\u043e\u0441\u0442\u0443\u043f \u043a \u043d\u043e\u0432\u043e\u0439 \u0444\u0443\u043d\u043a\u0446\u0438\u043e\u043d\u0430\u043b\u044c\u043d\u043e\u0441\u0442\u0438, \u043f\u0443\u0431\u043b\u0438\u043a\u0443\u044e\u0442\u0441\u044f \u043a\u0430\u0436\u0434\u044b\u0435 3 \u043c\u0435\u0441\u044f\u0446\u0430 [&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-146187","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 9.5.0. \u0421\u0431\u043e\u0440\u043a\u0438 MySQL Community Server 9.5.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\/sv\/blog\/news\/vypusk-subd-mysql-9-5-0\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.4\" \/>\n\t\t<meta property=\"og:locale\" content=\"sv_SE\" \/>\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.5.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.5.0. \u0421\u0431\u043e\u0440\u043a\u0438 MySQL Community Server 9.5.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\/sv\/blog\/news\/vypusk-subd-mysql-9-5-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-10-23T15:12:00+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2025-10-23T15:12:00+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\udd47Utgivning av databashanteringssystemet MySQL 9.5.0 | ProHoster","description":"F\u00f6retaget Oracle har bildat en ny gren av databashanteringssystemet MySQL 9.5.0. Byggnader av MySQL Community Server 9.5.0 har f\u00f6rberetts f\u00f6r alla st\u00f6rre Linux-distributioner, FreeBSD, macOS och Windows.","canonical_url":"https:\/\/prohoster.info\/sv\/blog\/news\/vypusk-subd-mysql-9-5-0","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"sv_SE","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.5.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.5.0. \u0421\u0431\u043e\u0440\u043a\u0438 MySQL Community Server 9.5.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\/sv\/blog\/news\/vypusk-subd-mysql-9-5-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-10-23T15:12:00+00:00","article:modified_time":"2025-10-23T15:12:00+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"146187","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 15:31:19","breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2026-01-23 15:31:19","updated":"2026-01-23 15:31:19","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/posts\/146187","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/comments?post=146187"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/posts\/146187\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/media?parent=146187"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/categories?post=146187"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/tags?post=146187"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}