{"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\/lv\/blog\/news\/vypusk-subd-mysql-9-5-0","title":{"rendered":"MySQL 9.5.0 datu b\u0101zes izlaidums","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Oracle uz\u0146\u0113mums ir izveidojis jaunu MySQL 9.5.0 datub\u0101zu noda\u013cu. MySQL Community Server 9.5.0 versijas ir sagatavotas vis\u0101m galvenaj\u0101m Linux, FreeBSD, macOS un Windows izplat\u012b\u0161anas versij\u0101m. Saska\u0146\u0101 ar 2023. gad\u0101 ieviesto izlai\u0161anas mode\u013ca principu, MySQL 9.5 ir klasific\u0113ts k\u0101 'Inov\u0101cija'. Inov\u0101cijas noda\u013cas ir ieteicamas tiem, kas v\u0113las \u0101tri piek\u013c\u016bt jaunai funkcionalit\u0101tei, t\u0101s tiek public\u0113tas reizi trijos m\u0113ne\u0161os un tiek atbalst\u012btas tikai l\u012bdz n\u0101kam\u0101 noz\u012bm\u012bg\u0101 izlaiduma public\u0113\u0161anai (piem\u0113ram, p\u0113c 9.5 noda\u013cas par\u0101d\u012b\u0161an\u0101s tiek p\u0101rtraukta atbalsts 9.4 noda\u013cai). Ziem\u0101 pl\u0101nots izveidot LTS izlaidumu 9.6, kas ieteicams ievie\u0161anai, kur nepiecie\u0161ama paredzam\u012bba un ilgsto\u0161a nemain\u012bga uzved\u012bba. P\u0113c LTS noda\u013cas izveidosies jauna Inov\u0101cijas noda\u013ca \u2014 MySQL 10.0.      <\/p>\n<p>Galven\u0101s izmai\u0146as MySQL 9.5:  <\/p>\n<ul>\n<li class=\"l\"> Pievienota opcija 'activate_mandatory_roles' papla\u0161in\u0101tai lomu p\u0101rvald\u012bbai \u2014 kad opcija 'activate_all_roles_on_login' ir izsl\u0113gta un 'activate_mandatory_roles' ir iesl\u0113gta, tiek aktiviz\u0113ta oblig\u0101to lomu atbalsts (kas autom\u0101tiski tiek pie\u0161\u0137irts lietot\u0101jam, piesl\u0113dzoties).\n<li class=\"l\"> MySQL Multilingual Engine spraudn\u012b JavaScript valod\u0101 ir nodro\u0161in\u0101ta ECMAScript 2025 specifik\u0101cijas atbalsts.\n<li class=\"l\"> Pievienota r\u012bks mysqldm (MySQL Diagnostic Monitor), kas paredz\u0113ts diagnostisk\u0101s inform\u0101cijas v\u0101k\u0161anai (tiek analiz\u0113ta iepriek\u0161 noteikta piepras\u012bjumu kopa), ko lietot\u0101js var nodot atbalsta dienestam, lai atvieglotu probl\u0113mu risin\u0101\u0161anu.\n<li class=\"l\"> Pievienota iesp\u0113ja vienlaikus instal\u0113t parastus un LTS MySQL izlaidumus blakus viens otram.\n<li class=\"l\"> Replik\u0101cijas parametru noklus\u0113juma iestat\u012bjumos ir iek\u013cautas papla\u0161in\u0101tas aizsardz\u012bbas iestat\u012bjumi, kas ietver \u0161ifr\u0113\u0161anas izmanto\u0161anu vis\u0101m savienojumiem replik\u0101cijas laik\u0101.\n<li class=\"l\"> MySQL Thread Pool spraudn\u012b ir ieviesta autom\u0101tiska parametru iestat\u012b\u0161ana, lai sasniegtu maksim\u0101lo veiktsp\u0113ju atbilsto\u0161i eso\u0161ajai aparat\u016bras konfigur\u0101cijai.\n<li class=\"l\"> Main\u012bta parametra 'innodb_log_writer_threads' uzved\u012bba, kura aktiv\u0101cija tagad ir atkar\u012bga no akt\u012bv\u0101 bin\u0101ro redo \u017eurn\u0101lu re\u017e\u012bma (log_bin). Ja 'log_bin' nav akt\u012bvs, parametra 'innodb_log_writer_threads' aktiviz\u0113\u0161ana notiek sist\u0113m\u0101s ar vair\u0101k nek\u0101 4 lo\u0123isk\u0101m CPU, bet akt\u012bva 'log_bin' gad\u012bjum\u0101 - ar vair\u0101k nek\u0101 31 lo\u0123isku CPU.\n<li class=\"l\"> P\u0113c noklus\u0113juma parametra 'binlog_transaction_dependency_history_size' v\u0113rt\u012bba palielin\u0101ta no 25 t\u016bksto\u0161iem l\u012bdz miljonam. Maksim\u0101l\u0101 iesp\u0113jam\u0101 v\u0113rt\u012bba \u0161im parametram palielin\u0101ta no 1 l\u012bdz 10 miljoniem.\n<li class=\"l\"> Parametra 'caching_sha2_password_digest_rounds' noklus\u0113juma v\u0113rt\u012bba palielin\u0101ta l\u012bdz 10000.\n<li class=\"l\"> Ir pazi\u0146ots par SCRAM-SHA-1 autentifik\u0101cijas metodes izmanto\u0161anas noveco\u0161anu, piesl\u0113dzoties SASL LDAP. T\u0101 viet\u0101 ir ieteicams izmantot SCRAM-SHA-256 metodi, kas tagad ir noklus\u0113juma parametr\u0101 'authentication_ldap_sasl_auth_method_name'.\n<li class=\"l\"> Atbalsts main\u012bgajiem 'group_replication_allow_local_lower_version_join' un 'replica_parallel_type', kas iepriek\u0161 tika pasludin\u0101ti par novecoju\u0161iem, ir p\u0101rtraukts.\n<li class=\"l\"> Solaris platform\u0101 ir pievienots atbalsts kompil\u0101cijai, izmantojot Clang un GCC. T\u0101pat ir pievienota iesp\u0113ja izmantot OpenSSL 3 Solaris vid\u0113.\n<li class=\"l\"> Minim\u0101l\u0101 atbalst\u0101m\u0101 Cmake versija ir paaugstin\u0101ta l\u012bdz 3.17.5.\n<li class=\"l\"> Ir nov\u0113rstas 9 ievainojam\u012bbas, no kur\u0101m nopietn\u0101kajai ir pie\u0161\u0137irts b\u012bstam\u012bbas l\u012bmenis 5.5 no 10. Detaliz\u0113ta inform\u0101cija netiek sniegta, nor\u0101d\u012bts tikai, ka ievainojam\u012bbas past\u0101v InnoDB, DML un optimizator\u0101. Lai izmantotu ievainojam\u012bbas, nepiecie\u0161ama autentific\u0113ta piek\u013cuve Datu b\u0101zu p\u0101rvald\u012bbas sist\u0113mai.   <\/ul>\n<p>Avots: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=64100\">opennet.lv<\/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.5 - 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\/lv\/blog\/news\/vypusk-subd-mysql-9-5-0\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.5\" \/>\n\t\t<meta property=\"og:locale\" content=\"lv_LV\" \/>\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\/lv\/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 izlaidums | ProHoster","description":"Uz\u0146\u0113mums Oracle ir izveidojis jaunu MySQL 9.5.0 datu b\u0101zu p\u0101rvald\u012bbas versiju. MySQL Community Server 9.5.0 kompil\u0101cijas ir sagatavotas vis\u0101m galvenaj\u0101m Linux, FreeBSD, macOS un Windows distrib\u016bcij\u0101m.","canonical_url":"https:\/\/prohoster.info\/lv\/blog\/news\/vypusk-subd-mysql-9-5-0","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"lv_LV","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\/lv\/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\/lv\/wp-json\/wp\/v2\/posts\/146187","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/comments?post=146187"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/posts\/146187\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/media?parent=146187"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/categories?post=146187"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/tags?post=146187"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}