{"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\/hu\/blog\/news\/vypusk-subd-mysql-9-5-0","title":{"rendered":"MySQL 9.5.0 adatb\u00e1zis-kezel\u0151 rendszer kiad\u00e1sa","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Az Oracle \u00faj MySQL 9.5.0 adatb\u00e1zis-kezel\u0151 \u00e1gat ind\u00edtott. A MySQL Community Server 9.5.0 verzi\u00f3i minden f\u0151 Linux, FreeBSD, macOS \u00e9s Windows disztrib\u00faci\u00f3hoz el\u00e9rhet\u0151k. Az 2023-ban bevezetett kiad\u00e1si modell szerint a MySQL 9.5 az 'Innovation' \u00e1gak k\u00f6z\u00e9 tartozik. Az Innovation \u00e1gakat azoknak aj\u00e1nlj\u00e1k, akik kor\u00e1bban szeretn\u00e9nek hozz\u00e1f\u00e9rni az \u00faj funkci\u00f3khoz, ezek h\u00e1rom havonta jelennek meg, \u00e9s csak a k\u00f6vetkez\u0151 jelent\u0151s kiad\u00e1s publik\u00e1l\u00e1s\u00e1ig t\u00e1mogatottak (p\u00e9ld\u00e1ul a 9.5 \u00e1g megjelen\u00e9se ut\u00e1n a 9.4 \u00e1g t\u00e1mogat\u00e1sa megsz\u0171nik). T\u00e9len tervezik az LTS 9.6 kiad\u00e1s l\u00e9trehoz\u00e1s\u00e1t, amelyet azoknak aj\u00e1nlanak, akiknek kisz\u00e1m\u00edthat\u00f3s\u00e1gra \u00e9s hossz\u00fa t\u00e1v\u00fa, v\u00e1ltozatlan m\u0171k\u00f6d\u00e9sre van sz\u00fcks\u00e9g\u00fck. Az LTS \u00e1g ut\u00e1n \u00fajabb Innovation \u00e1g fog megjelenni - MySQL 10.0.      <\/p>\n<p>A MySQL 9.5 f\u0151bb v\u00e1ltoz\u00e1sai:  <\/p>\n<ul>\n<li class=\"l\"> Hozz\u00e1adva az 'activate_mandatory_roles' opci\u00f3, amely fejlettebb szerepk\u00f6rkezel\u00e9st tesz lehet\u0151v\u00e9 - ha az 'activate_all_roles_on_login' be\u00e1ll\u00edt\u00e1s ki van kapcsolva, \u00e9s az 'activate_mandatory_roles' be van kapcsolva, akkor a standard szerepk\u00f6r\u00f6k mellett aktiv\u00e1l\u00f3dik a k\u00f6telez\u0151 szerepk\u00f6r\u00f6k t\u00e1mogat\u00e1sa (amelyek automatikusan kioszt\u00e1sra ker\u00fclnek a felhaszn\u00e1l\u00f3nak a csatlakoz\u00e1skor).\n<li class=\"l\"> A MySQL Multilingual Engine JavaScript nyelvi megval\u00f3s\u00edt\u00e1s\u00e1ban t\u00e1mogat\u00e1st kapott az ECMAScript 2025 specifik\u00e1ci\u00f3.\n<li class=\"l\"> \u00daj \"mysqldm\" (MySQL Diagnostic Monitor) eszk\u00f6z ker\u00fclt bevezet\u00e9sre, amely diagnosztikai inform\u00e1ci\u00f3k gy\u0171jt\u00e9s\u00e9re szolg\u00e1l (egy el\u0151re meghat\u00e1rozott k\u00e9rd\u00e9ssor v\u00e9grehajt\u00e1s\u00e1t elemzi), \u00e9s a felhaszn\u00e1l\u00f3 \u00e1ltal a t\u00e1mogat\u00e1si szolg\u00e1latnak \u00e1tadhat\u00f3 a probl\u00e9m\u00e1k egyszer\u0171bb elemz\u00e9s\u00e9hez.\n<li class=\"l\"> Lehet\u0151v\u00e9 v\u00e1lt a MySQL hagyom\u00e1nyos \u00e9s LTS kiad\u00e1sok egyidej\u0171 telep\u00edt\u00e9se.\n<li class=\"l\"> Az alap\u00e9rtelmezett replik\u00e1ci\u00f3s be\u00e1ll\u00edt\u00e1sokn\u00e1l a kiterjesztett v\u00e9delmi be\u00e1ll\u00edt\u00e1sok aktiv\u00e1lva vannak, amelyek titkos\u00edt\u00e1st ig\u00e9nyelnek minden kapcsolatra a replik\u00e1ci\u00f3 sor\u00e1n.\n<li class=\"l\"> A MySQL Thread Pool plugin automatikusan be\u00e1ll\u00edtja a param\u00e9tereket a maxim\u00e1lis teljes\u00edtm\u00e9ny el\u00e9r\u00e9se \u00e9rdek\u00e9ben a rendelkez\u00e9sre \u00e1ll\u00f3 hardver konfigur\u00e1ci\u00f3 figyelembev\u00e9tel\u00e9vel.\n<li class=\"l\"> Megv\u00e1ltozott az 'innodb_log_writer_threads' param\u00e9ter viselked\u00e9se, amelynek bekapcsol\u00e1sa most m\u00e1r a bin\u00e1ris redo-logok (log_bin) akt\u00edv m\u00f3dj\u00e1t\u00f3l f\u00fcgg. Ha a 'log_bin' inakt\u00edv, az 'innodb_log_writer_threads' param\u00e9ter a 4-n\u00e9l t\u00f6bb logikai CPU-val rendelkez\u0151 rendszerekn\u00e9l aktiv\u00e1l\u00f3dik, m\u00edg akt\u00edv 'log_bin' eset\u00e9n a 31-n\u00e9l t\u00f6bb logikai CPU-val rendelkez\u0151 rendszerekn\u00e9l.\n<li class=\"l\"> Alap\u00e9rtelmez\u00e9s szerint a 'binlog_transaction_dependency_history_size' param\u00e9ter \u00e9rt\u00e9ke 25 000-r\u00f3l 1 milli\u00f3ra n\u0151tt. Ennek a param\u00e9ternek a maxim\u00e1lis lehets\u00e9ges \u00e9rt\u00e9ke 1-r\u0151l 10 milli\u00f3ra emelkedett.\n<li class=\"l\"> A 'caching_sha2_password_digest_rounds' param\u00e9ter alap\u00e9rtelmezett \u00e9rt\u00e9k\u00e9t 10 000-re emelt\u00e9k.\n<li class=\"l\"> Elavult a SCRAM-SHA-1 hiteles\u00edt\u00e9si m\u00f3dszer haszn\u00e1lata a SASL LDAP-hoz val\u00f3 csatlakoz\u00e1skor. E helyett a SCRAM-SHA-256 m\u00f3dszert kell haszn\u00e1lni, amely most m\u00e1r alap\u00e9rtelmezettk\u00e9nt van be\u00e1ll\u00edtva az 'authentication_ldap_sasl_auth_method_name' param\u00e9terben.\n<li class=\"l\"> A 'group_replication_allow_local_lower_version_join' \u00e9s a 'replica_parallel_type' v\u00e1ltoz\u00f3k t\u00e1mogat\u00e1sa megsz\u0171nt, amelyeket kor\u00e1bban elavultnak nyilv\u00e1n\u00edtottak.\n<li class=\"l\"> A Solaris platformon hozz\u00e1adt\u00e1k a Clang \u00e9s GCC haszn\u00e1lat\u00e1val v\u00e9gzett build-t\u00e1mogat\u00e1st. Emellett lehet\u0151v\u00e9 v\u00e1lt az OpenSSL 3 haszn\u00e1lata a Solaris alatt.\n<li class=\"l\"> A minimum t\u00e1mogatott CMake verzi\u00f3t 3.17.5-re emelt\u00e9k.\n<li class=\"l\"> \u00d6sszesen 9 sebezhet\u0151s\u00e9get sz\u00fcntettek meg, a legs\u00falyosabb 5,5-\u00f6s kock\u00e1zati szinttel. R\u00e9szletek nem \u00e1llnak rendelkez\u00e9sre, csup\u00e1n annyit k\u00f6z\u00f6ltek, hogy a sebezhet\u0151s\u00e9gek az InnoDB, DML \u00e9s az optimaliz\u00e1l\u00f3 ter\u00fclet\u00e9n tal\u00e1lhat\u00f3k. A sebezhet\u0151s\u00e9gek kihaszn\u00e1l\u00e1s\u00e1hoz hiteles\u00edtett hozz\u00e1f\u00e9r\u00e9s sz\u00fcks\u00e9ges az adatb\u00e1zishoz.   <\/ul>\n<p>Forr\u00e1s: <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.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.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\/hu\/blog\/news\/vypusk-subd-mysql-9-5-0\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.3\" \/>\n\t\t<meta property=\"og:locale\" content=\"hu_HU\" \/>\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\/hu\/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\udd47MySQL 9.5.0 kiad\u00e1s | ProHoster","description":"Az Oracle \u00faj MySQL 9.5.0 adatb\u00e1zis-sorozatot alak\u00edtott ki. A MySQL Community Server 9.5.0 buildjei elk\u00e9sz\u00fcltek minden f\u0151 Linux, FreeBSD, macOS \u00e9s Windows disztrib\u00faci\u00f3hoz.","canonical_url":"https:\/\/prohoster.info\/hu\/blog\/news\/vypusk-subd-mysql-9-5-0","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"hu_HU","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\/hu\/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\/hu\/wp-json\/wp\/v2\/posts\/146187","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/comments?post=146187"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/posts\/146187\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/media?parent=146187"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/categories?post=146187"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/tags?post=146187"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}