{"id":121458,"date":"2025-01-23T15:46:10","date_gmt":"2025-01-23T13:46:10","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/vypusk-subd-mysql-9-2-0"},"modified":"2025-01-23T15:46:10","modified_gmt":"2025-01-23T13:46:10","slug":"vypusk-subd-mysql-9-2-0","status":"publish","type":"post","link":"https:\/\/prohoster.info\/lv\/blog\/news\/vypusk-subd-mysql-9-2-0","title":{"rendered":"Izlaidums datub\u0101zes MySQL 9.2.0","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Uz\u0146\u0113mums Oracle ir izveidojis jaunu MySQL datu b\u0101zes 9.2.0 versiju. MySQL Community Server 9.2.0 izstr\u0101d\u0101ta visiem galvenajiem Linux, FreeBSD, macOS un Windows izplat\u012bjumiem. Saska\u0146\u0101 ar 2023. gad\u0101 ieviesto jaun\u0101s versiju izstr\u0101des modeli, MySQL 9.2 ir klasific\u0113ts k\u0101 'Innovation' versijas, kur\u0101m pieder\u0113s ar\u012b n\u0101kam\u0101 iev\u0113rojam\u0101 MySQL 9.3 versija. Innovation versijas ir ieteicamas tiem, kuri v\u0113las agr\u0101k piek\u013c\u016bt jaun\u0101m funkcij\u0101m, t\u0101s tiek public\u0113tas ik p\u0113c 3 m\u0113ne\u0161iem un tiek atbalst\u012btas tikai l\u012bdz n\u0101kam\u0101s iev\u0113rojam\u0101s versijas public\u0113\u0161anai (piem\u0113ram, p\u0113c 9.2 versijas izn\u0101k\u0161anas 9.1 atbalsts tiek p\u0101rtraukts). Vasar\u0101 pl\u0101nots izstr\u0101d\u0101t LTS versiju, kas ieteicama ievie\u0161anai, kam nepiecie\u0161ama prognoz\u0113jam\u012bba un ilgsto\u0161a uzved\u012bbas saglab\u0101\u0161ana. P\u0113c LTS versijas izstr\u0101d\u0101\u0161ana tiks uzs\u0101kta jauna Innovation versija \u2014 MySQL 10.0.        <\/p>\n<p>Galven\u0101s izmai\u0146as MySQL 9.2:  <\/p>\n<ul>\n<li class=\"l\"> MLE (Multilingual Engine Component) dzin\u0113jam, kas \u013cauj izmantot uzglab\u0101taj\u0101s proced\u016br\u0101s un funkcij\u0101s kodu valod\u0101s, kas at\u0161\u0137iras no SQL, ir pievienota atbalsts atk\u0101rtoti izmantojam\u0101m bibliot\u0113k\u0101m JavaScript valod\u0101. Funkcijas no \u0161\u0101d\u0101m bibliot\u0113k\u0101m var tikt izsauktas no uzglab\u0101taj\u0101m proced\u016br\u0101m JavaScript valod\u0101, ta\u010du t\u0101m ir j\u0101b\u016bt skaidri iez\u012bm\u0113t\u0101m k\u0101 import\u0113jam\u0101m, izmantojot atsl\u0113gv\u0101rdu 'export'. Bibliot\u0113ku JavaScript pievieno\u0161anai ir pievienoti jauni SQL izteiksmes 'CREATE LIBRARY' un 'DROP LIBRARY'. Lai skat\u012btu pieejamo JavaScript bibliot\u0113ku sarakstu, ir pievienota izteiksme 'SHOW CREATE LIBRARY'. Inform\u0101cija par JavaScript bibliot\u0113k\u0101m tiek atspogu\u013cota sist\u0113mas tabul\u0101 'LIBRARIES', bet par uzglab\u0101taj\u0101m proced\u016br\u0101m, kas izmanto \u0161\u0101das bibliot\u0113kas, \u2014 tabul\u0101 'ROUTINE_LIBRARIES'. Bibliot\u0113kas pievieno\u0161ana uzglab\u0101taj\u0101 proced\u016br\u0101 tiek veikta, nor\u0101dot bibliot\u0113ku sarakstu izteiksm\u0113 'USING'.\n<li class=\"l\"> Pievienota API piek\u013cuve uzglab\u0101taj\u0101m proced\u016br\u0101m, funkcij\u0101m un sesijas main\u012bgajiem no JavaScript koda. Lai piek\u013c\u016btu MySQL funkcij\u0101m, ir pievienota metode getFunction(), bet uzglab\u0101taj\u0101m proced\u016br\u0101m \u2014 metode getProcedure(), kas atgrie\u017e JavaScript objektu Function, kuru var izpild\u012bt ar argumentiem. Piek\u013cuve main\u012bgajiem tiek veikta tie\u0161i k\u0101 pie JavaScript objekta Session \u012bpa\u0161\u012bb\u0101m. Turkl\u0101t ir pievienota iesp\u0113ja tie\u0161ai piek\u013cuvei ieb\u016bv\u0113taj\u0101m funkcij\u0101m rand(), sleep(), uuid() un isUUID(), kas ir l\u012bdz\u012bgas SQL funkcij\u0101m ar t\u0101du pa\u0161u nosaukumu.\n<li class=\"l\"> Pievienots API darbam ar transakcij\u0101m no JavaScript, kas \u013cauj veikt liel\u0101ko da\u013cu SQL izteikumu darbam ar transakcij\u0101m, piem\u0113ram, &#171;START TRANSACTION&#187;, &#171;COMMIT&#187;, &#171;ROLLBACK&#187; un &#171;SET AUTOCOMMIT&#187;.\n<li class=\"l\"> Pievienota iesp\u0113ja izmantot MySQL tipus ENUM un SET uzglab\u0101tu proced\u016bru argumentos, kas rakst\u012btas JavaScript.\n<li class=\"l\"> Pievienota privil\u0113\u0123ija CREATE_SPATIAL_REFERENCE_SYSTEM, ar kuras pal\u012bdz\u012bbu var p\u0101rvald\u012bt iesp\u0113ju veidot un dz\u0113st \u0123eogr\u0101fisko inform\u0101cijas sist\u0113mu datu telpisk\u0101s saist\u012bbas defin\u012bcijas. \u0160\u012bs privil\u0113\u0123ijas vai privil\u0113\u0123ijas SUPER esam\u012bba tagad ir oblig\u0101ta, lai veiktu izteikumus &#171;CREATE SPATIAL REFERENCE SYSTEM&#187;, &#171;CREATE OR REPLACE SPATIAL REFERENCE SYSTEM&#187; un &#171;DROP SPATIAL REFERENCE SYSTEM&#187;.\n<li class=\"l\"> Ievad\u0113 &#171;EXPLAIN FORMAT=JSON&#187; pievienota inform\u0101cija par JSON form\u0101ta versiju. Lai nor\u0101d\u012btu JSON form\u0101ta versiju, j\u0101izmanto main\u012bgais explain_json_format_version (&#171;SET explain_json_format_version=1|2&#187;).\n<li class=\"l\"> Dekl\u0101r\u0113ti par novecoju\u0161iem: izteikums &#171;FLUSH PRIVILEGES&#187;, komandas &#171;mysqladmin flush-privileges&#187; un &#171;mysqladmin reload&#187;, spraudnis &#171;version_tokens&#187;.\n<li class=\"l\"> Atbalsts atsl\u0113gv\u0101rdiem BINLOG ir p\u0101rtraukts.\n<li class=\"l\"> Nov\u0113rstas 32 ievainojam\u012bbas, no kur\u0101m 3 var izv\u0113rst att\u0101lin\u0101ti. Divas nopietn\u0101k\u0101s probl\u0113mas ir ar 9.1 b\u012bstam\u012bbas l\u012bmeni un attiecas uz ievainojam\u012bb\u0101m Kerberos un Curl komponentos. Maz\u0101k b\u012bstam\u0101s ievainojam\u012bbas skar InnoDB, Thread Pooling, DDL, optimizatoru, parseri un autentifik\u0101cijas sist\u0113mu.     <\/ul>\n<p>Avots: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=62603\">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.2.0. \u0421\u0431\u043e\u0440\u043a\u0438 MySQL Community Server 9.2.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 2023 \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.2 \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.3. 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-121458","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.2.0. \u0421\u0431\u043e\u0440\u043a\u0438 MySQL Community Server 9.2.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-2-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.2.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.2.0. \u0421\u0431\u043e\u0440\u043a\u0438 MySQL Community Server 9.2.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-2-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-01-23T13:46:10+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2025-01-23T13:46:10+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.2.0 datu b\u0101zes izn\u0101kums | ProHoster","description":"Uz\u0146\u0113mums Oracle ir izveidojis jaunu MySQL 9.2.0 datu b\u0101zes pavedienu. MySQL Community Server 9.2.0 izdevumi ir sagatavoti visiem galvenajiem Linux, FreeBSD, macOS un Windows distrib\u016bcij\u0101m.","canonical_url":"https:\/\/prohoster.info\/lv\/blog\/news\/vypusk-subd-mysql-9-2-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.2.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.2.0. \u0421\u0431\u043e\u0440\u043a\u0438 MySQL Community Server 9.2.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-2-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-01-23T13:46:10+00:00","article:modified_time":"2025-01-23T13:46:10+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"121458","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 09:56:19","breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2026-01-23 09:56:19","updated":"2026-01-23 09:56: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\/121458","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=121458"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/posts\/121458\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/media?parent=121458"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/categories?post=121458"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/tags?post=121458"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}