{"id":120215,"date":"2024-10-17T19:09:08","date_gmt":"2024-10-17T17:09:08","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/vypusk-subd-mysql-9-1-0"},"modified":"2024-10-17T19:09:08","modified_gmt":"2024-10-17T17:09:08","slug":"vypusk-subd-mysql-9-1-0","status":"publish","type":"post","link":"https:\/\/prohoster.info\/lv\/blog\/news\/vypusk-subd-mysql-9-1-0","title":{"rendered":"MySQL DBMS 9.1.0 izlai\u0161ana","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Oracle komp\u0101nija ir izveidojusi jaunu MySQL 9.1.0 datu b\u0101zu p\u0101rvald\u012bbas sist\u0113mas (DBPS) zaru. MySQL Community Server 9.1.0 kompil\u0101cijas ir sagatavotas vis\u0101m galvenaj\u0101m Linux, FreeBSD, macOS un Windows izplat\u012bjumu versij\u0101m. Saska\u0146\u0101 ar p\u0113rn ieviesto jauno izlai\u0161anas mode\u013ca form\u0113\u0161anu, MySQL 9.1 tiek iek\u013cauts \"Innovation\" zaros, kuru vid\u016b b\u016bs ar\u012b n\u0101kamais noz\u012bm\u012bgais izlai\u0161anas pavediens MySQL 9.2. Innovation zari ir ieteicami tiem, kuri v\u0113las agr\u0101k piek\u013c\u016bt jaunaj\u0101m funkcij\u0101m, tie tiek public\u0113ti ik p\u0113c 3 m\u0113ne\u0161iem un tiek atbalst\u012bti tikai l\u012bdz n\u0101kam\u0101 noz\u012bm\u012bg\u0101 izlai\u0161anas public\u0113\u0161anai (piem\u0113ram, p\u0113c 9.1 zara izveides tiek p\u0101rtraukta 9.0 zara atbalsts). N\u0101kam\u0101 gada vasar\u0101 pl\u0101nots izveidot LTS izlaidi, kas ieteicama ievie\u0161anai, kur\u0101m nepiecie\u0161ama paredzam\u012bba un ilgsto\u0161a nemain\u012bga uzved\u012bba. P\u0113c LTS zara tiks izveidots jauns Innovation zars \u2014 MySQL 10.0.        <\/p>\n<p>Galven\u0101s izmai\u0146as MySQL 9.1:  <\/p>\n<ul>\n<li class=\"l\"> Uz \"CREATE VIEW\" darb\u012bbu ir pievienota atbalsta izteiksme \"IF NOT EXISTS\", kas \u013cauj izveidot skatu tikai tad, ja ar nor\u0101d\u012bto nosaukumu skats v\u0113l nepast\u0101v, un nov\u0113r\u0161 k\u013c\u016bdas atgrie\u0161anu, ja skats jau ir izveidots.\n<li class=\"l\"> Izpildot tikai las\u012b\u0161anas oper\u0101cijas, trigeru iel\u0101de ir p\u0101rtraukta. Agr\u0101k trigeri tika iel\u0101d\u0113ti pie jebkuras piek\u013cuves tabulai, kas rad\u012bja atmi\u0146as pat\u0113ri\u0146u un slodzi uz CPU, situ\u0101cij\u0101s, kad trigeri netika izmantoti (piem\u0113ram, izpildot SELECT vaic\u0101jumus). MySQL 9.1 trigeru apstr\u0101de un iel\u0101de ir sadal\u012bta div\u0101s posm\u0101s: metadatu par trigeriem las\u012b\u0161ana un trigeru izpilde. Dati, kas ieg\u016bti pirmaj\u0101 posm\u0101, tiek saglab\u0101ti vienu reizi un p\u0113c tam kop\u012bgi izmantoti da\u017e\u0101diem trigeru eksempl\u0101riem. Trigeru anal\u012bze un izpilde notiek tikai datu izmai\u0146u izraiso\u0161iem izteiksm\u0113m. Turkl\u0101t, lai samazin\u0101tu atmi\u0146as pat\u0113ri\u0146u, tika veikts p\u0101reja uz dinamisku atmi\u0146as pie\u0161\u0137ir\u0161anu trigeru k\u013c\u016bdu apstr\u0101dei p\u0113c vajadz\u012bbas.\n<li class=\"l\"> Tika papla\u0161in\u0101ts \"EXPLAIN\" darb\u012bbas izn\u0101kums, kur tagad tiek par\u0101d\u012bta inform\u0101cija par vair\u0101ku diapazonu las\u012b\u0161anas (multi-range) izmanto\u0161anu un pusapvieno\u0161anas (semijoin) strat\u0113\u0123ijas piem\u0113ro\u0161anu, kur\u0101 JOIN darb\u012bbu laik\u0101 tiek apstr\u0101d\u0101tas tikai rindu no vienas tabulas.\n<li class=\"l\"> Tika nodro\u0161in\u0101ta atom\u0101ra \"CREATE DATABASE\" un \"DROP DATABASE\" darb\u012bbu izpilde, lai pasarg\u0101tu no k\u013c\u016bm\u0113m un p\u0113k\u0161\u0146as izsl\u0113g\u0161an\u0101s vai k\u013c\u016bmju ra\u0161an\u0101s failu sist\u0113mas l\u012bmen\u012b \u0161o darb\u012bbu izpildes laik\u0101. Piem\u0113ram, iepriek\u0161, ja \"CREATE DATABASE\" beidz\u0101s ar k\u013c\u016bdu, var\u0113ja tikt izveidota nepiln\u012bga un neder\u012bga datu b\u0101zes glab\u0101\u0161anas strukt\u016bra, kuras t\u012br\u012b\u0161anai bija nepiecie\u0161ama manu\u0101la iejauk\u0161an\u0101s.\n<li class=\"l\"> JavaScript valod\u0101 rakst\u012bt\u0101s glab\u0101jam\u0101s proced\u016br\u0101s ir nodro\u0161in\u0101ta VEKTORA tipa atbalsts. Dati ar nor\u0101d\u012bto tipu tagad var tikt nodoti ievad\u012b\u0161anas un atgriezto parametru status\u0101.\n<li class=\"l\"> Ievesta iesp\u0113ja autentific\u0113ties, piesl\u0113dzoties DBMS, izmantojot OpenID Connect protokolu.\n<li class=\"l\"> Nov\u0113rstas 27 ievainojam\u012bbas, no kur\u0101m nopietn\u0101k\u0101 (CVE-2024-5535) sa\u0146\u0113musi kritisku b\u012bstam\u012bbas l\u012bmeni (9.1 no 10). Ievainojam\u012bbu var izmantot att\u0101lin\u0101ti, nep\u0101rbaudot autentifik\u0101ciju. Probl\u0113ma radusies, lasot datus no apgabala \u0101rpus pie\u0161\u0137irt\u0101 bufera OpenSSL bibliot\u0113k\u0101, un t\u0101 var novest pie av\u0101rijas vai atmi\u0146as satura nopl\u016bdes atbild\u0113 p\u0113c savienojuma izveides ar <a class=\"wpil_keyword_link\" href=\"https:\/\/prohoster.info\/lv\/server\/dts-prohoster\/\"   title=\"serveri\" data-wpil-keyword-link=\"linked\"  data-wpil-monitor-id=\"3093\">serveri<\/a>  nepareizi nor\u0101d\u012btiem protokola parametriem.       <\/ul>\n<p>Avots: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=62067\">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.1.0. \u0421\u0431\u043e\u0440\u043a\u0438 MySQL Community Server 9.1.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 \u043f\u0440\u043e\u0448\u043b\u043e\u043c \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.1 \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.2. 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-120215","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.1.0. \u0421\u0431\u043e\u0440\u043a\u0438 MySQL Community Server 9.1.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-1-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.1.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.1.0. \u0421\u0431\u043e\u0440\u043a\u0438 MySQL Community Server 9.1.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-1-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=\"2024-10-17T17:09:08+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2024-10-17T17:09:08+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.1.0 DBMS izlai\u0161ana | ProHoster","description":"Uz\u0146\u0113mums Oracle ir izveidojis jaunu MySQL 9.1.0 DBMS zaru. MySQL Community Server 9.1.0 b\u016bves 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-1-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.1.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.1.0. \u0421\u0431\u043e\u0440\u043a\u0438 MySQL Community Server 9.1.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-1-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":"2024-10-17T17:09:08+00:00","article:modified_time":"2024-10-17T17:09:08+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"120215","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-02-09 22:03:19","breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2026-01-23 07:23:19","updated":"2026-02-09 22:03: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\/120215","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=120215"}],"version-history":[{"count":1,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/posts\/120215\/revisions"}],"predecessor-version":[{"id":160374,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/posts\/120215\/revisions\/160374"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/media?parent=120215"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/categories?post=120215"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/tags?post=120215"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}