{"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\/pl\/blog\/news\/vypusk-subd-mysql-9-5-0","title":{"rendered":"Wydanie bazy danych MySQL 9.5.0","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Firma Oracle stworzy\u0142a now\u0105 ga\u0142\u0105\u017a systemu zarz\u0105dzania baz\u0105 danych MySQL 9.5.0. Wersje MySQL Community Server 9.5.0 s\u0105 przygotowane dla wszystkich g\u0142\u00f3wnych dystrybucji Linux, FreeBSD, macOS i Windows. Zgodnie z wprowadzonym w 2023 roku modelem tworzenia wersji, MySQL 9.5 nale\u017cy do ga\u0142\u0119zi \u201eInnovation\u201d. Ga\u0142\u0119zie Innovation s\u0105 rekomendowane dla tych, kt\u00f3rzy chc\u0105 wcze\u015bniej uzyska\u0107 dost\u0119p do nowych funkcji, publikowane s\u0105 co trzy miesi\u0105ce i s\u0105 wspierane tylko do momentu wydania kolejnej znacz\u0105cej wersji (np. po pojawieniu si\u0119 ga\u0142\u0119zi 9.5 wsparcie dla ga\u0142\u0119zi 9.4 zostanie zako\u0144czone). Na zim\u0119 planowane jest stworzenie wersji LTS 9.6, rekomendowanej do wdro\u017ce\u0144, kt\u00f3re wymagaj\u0105 przewidywalno\u015bci i d\u0142ugotrwa\u0142ego zachowania sta\u0142ego dzia\u0142ania. Nast\u0119pnie po ga\u0142\u0119zi LTS zostanie stworzona nowa ga\u0142\u0105\u017a Innovation \u2014 MySQL 10.0.      <\/p>\n<p>G\u0142\u00f3wne zmiany w MySQL 9.5:  <\/p>\n<ul>\n<li class=\"l\"> Dodano opcj\u0119 \u201eactivate_mandatory_roles\u201d dla zaawansowanego zarz\u0105dzania rolami \u2014 przy wy\u0142\u0105czonym ustawieniu \u201eactivate_all_roles_on_login\u201d i w\u0142\u0105czonej \u201eactivate_mandatory_roles\u201d w dodatku do standardowych r\u00f3l, aktywowana jest obs\u0142uga r\u00f3l obowi\u0105zkowych (automatycznie przypisywanych u\u017cytkownikowi podczas logowania).\n<li class=\"l\"> W wtyczce MySQL Multilingual Engine w implementacji j\u0119zyka JavaScript zapewniono wsparcie dla specyfikacji ECMAScript 2025.\n<li class=\"l\"> Dodano narz\u0119dzie mysqldm (MySQL Diagnostic Monitor), kt\u00f3re zbiera informacje diagnostyczne (analizuje wykonanie okre\u015blonego zestawu zapyta\u0144), kt\u00f3re u\u017cytkownik mo\u017ce przekaza\u0107 do wsparcia technicznego w celu uproszczenia analizy problem\u00f3w.\n<li class=\"l\"> Dodano mo\u017cliwo\u015b\u0107 jednoczesnej instalacji wersji standardowych i LTS MySQL obok siebie.\n<li class=\"l\"> W ustawieniach replikacji domy\u015blnie w\u0142\u0105czono rozszerzone opcje zabezpiecze\u0144, co oznacza u\u017cycie szyfrowania dla wszystkich po\u0142\u0105cze\u0144 podczas replikacji.\n<li class=\"l\"> W wtyczce MySQL Thread Pool wprowadzono automatyczne ustawianie parametr\u00f3w w celu osi\u0105gni\u0119cia maksymalnej wydajno\u015bci z uwzgl\u0119dnieniem dost\u0119pnej konfiguracji sprz\u0119towej.\n<li class=\"l\"> Zmieni\u0142o si\u0119 zachowanie parametru \u201einnodb_log_writer_threads\u201d, kt\u00f3rego w\u0142\u0105czenie teraz domy\u015blnie zale\u017cy od aktywnego trybu binarnego redo-log\u00f3w (log_bin). Przy nieaktywnym \u201elog_bin\u201d parametr \u201einnodb_log_writer_threads\u201d jest w\u0142\u0105czany dla system\u00f3w z wi\u0119cej ni\u017c 4 logicznymi CPU, a przy aktywnym \u2014 z wi\u0119cej ni\u017c 31 logicznymi CPU.\n<li class=\"l\"> Domy\u015blna warto\u015b\u0107 parametru \u201ebinlog_transaction_dependency_history_size\u201d zosta\u0142a zwi\u0119kszona z 25 tysi\u0119cy do miliona. Maksymalna mo\u017cliwa warto\u015b\u0107 tego parametru zosta\u0142a zwi\u0119kszona z 1 do 10 milion\u00f3w.\n<li class=\"l\"> Domy\u015blna warto\u015b\u0107 parametru \u201ecaching_sha2_password_digest_rounds\u201d zosta\u0142a zwi\u0119kszona do 10000.\n<li class=\"l\"> Og\u0142oszono, \u017ce metoda autoryzacji SCRAM-SHA-1 przy \u0142\u0105czeniu si\u0119 z SASL LDAP jest przestarza\u0142a. Zamiast niej nale\u017cy u\u017cywa\u0107 metody SCRAM-SHA-256, kt\u00f3ra jest teraz domy\u015blnie ustawiana w parametrze \u201eauthentication_ldap_sasl_auth_method_name\u201d.\n<li class=\"l\"> Wsparcie dla zmiennych \u201egroup_replication_allow_local_lower_version_join\u201d oraz \u201ereplica_parallel_type\u201d, wcze\u015bniej og\u0142oszonych jako przestarza\u0142e, zosta\u0142o zako\u0144czone.\n<li class=\"l\"> Na platformie Solaris dodano wsparcie dla kompilacji z wykorzystaniem Clang i GCC. Dodano r\u00f3wnie\u017c mo\u017cliwo\u015b\u0107 u\u017cycia OpenSSL 3 w Solaris.\n<li class=\"l\"> Minimalnie wspierana wersja Cmake zosta\u0142a podniesiona do 3.17.5.\n<li class=\"l\"> Usuni\u0119to 9 podatno\u015bci, z kt\u00f3rych najbardziej powa\u017cnej przypisano poziom zagro\u017cenia 5.5 na 10. Szczeg\u00f3\u0142y nie s\u0105 podawane, podano jedynie, \u017ce podatno\u015bci wyst\u0119puj\u0105 w InnoDB, DML i optymalizatorze. Aby wykorzysta\u0107 te podatno\u015bci, wymagany jest dost\u0119p uwierzytelniony do systemu zarz\u0105dzania baz\u0105 danych.   <\/ul>\n<p>\u0179r\u00f3d\u0142o: <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.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 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\/pl\/blog\/news\/vypusk-subd-mysql-9-5-0\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.1.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"pl_PL\" \/>\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\/pl\/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\udd47Wydanie systemu zarz\u0105dzania baz\u0105 danych MySQL 9.5.0 | ProHoster","description":"Firma Oracle utworzy\u0142a now\u0105 ga\u0142\u0105\u017a systemu zarz\u0105dzania bazami danych MySQL 9.5.0. Kompilacje MySQL Community Server 9.5.0 przygotowano dla wszystkich g\u0142\u00f3wnych dystrybucji Linux, FreeBSD, macOS oraz Windows.","canonical_url":"https:\/\/prohoster.info\/pl\/blog\/news\/vypusk-subd-mysql-9-5-0","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"pl_PL","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\/pl\/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\/pl\/wp-json\/wp\/v2\/posts\/146187","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/pl\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/pl\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/pl\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/pl\/wp-json\/wp\/v2\/comments?post=146187"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/pl\/wp-json\/wp\/v2\/posts\/146187\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/pl\/wp-json\/wp\/v2\/media?parent=146187"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/pl\/wp-json\/wp\/v2\/categories?post=146187"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/pl\/wp-json\/wp\/v2\/tags?post=146187"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}