{"id":123615,"date":"2025-04-20T09:05:07","date_gmt":"2025-04-20T07:05:07","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/vypusk-subd-mysql-9-3-0"},"modified":"2025-04-20T09:05:07","modified_gmt":"2025-04-20T07:05:07","slug":"vypusk-subd-mysql-9-3-0","status":"publish","type":"post","link":"https:\/\/prohoster.info\/lv\/blog\/news\/vypusk-subd-mysql-9-3-0","title":{"rendered":"MySQL 9.3.0 DBMS izlaidums","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Oracle ir izveidojusi jaunu MySQL 9.3.0 datu b\u0101zu p\u0101rvald\u012bbas sist\u0113mas (DBPS) zaru. MySQL Community Server 9.3.0 versijas ir sagatavotas vis\u0101m galvenaj\u0101m Linux, FreeBSD, macOS un Windows izplat\u012bjumu versij\u0101m. Saska\u0146\u0101 ar 2023. gad\u0101 ieviesto jauno versiju izstr\u0101des modeli, MySQL 9.3 ir klasific\u0113ts k\u0101 'Innovation' zars. Innovation zari ir ieteicami tiem, kas v\u0113las \u0101tr\u0101k piek\u013c\u016bt jaun\u0101m funkcionalit\u0101t\u0113m, tiek public\u0113ti ik p\u0113c 3 m\u0113ne\u0161iem un tiek atbalst\u012bti tikai l\u012bdz n\u0101kam\u0101 noz\u012bm\u012bg\u0101 izlaiduma public\u0113\u0161anai (piem\u0113ram, p\u0113c 9.3 zara izveides atbalsts 9.2 zaram tiek p\u0101rtraukts). Vasar\u0101 pl\u0101no izveidot LTS izlaidumu 9.4, kas ir ieteicams ievie\u0161anai, kurai nepiecie\u0161ama paredzam\u012bba un ilgi saglab\u0101jama nemain\u012bga uzved\u012bba. P\u0113c LTS zara tiks izveidots jauns Innovation zars - MySQL 10.0.        <\/p>\n<p>Galven\u0101s izmai\u0146as MySQL 9.3:  <\/p>\n<ul>\n<li class=\"l\"> Mysqldump util\u012bt\u0101 ir pievienota opcija '--users', lai izveidotu lo\u0123iskos datus ar inform\u0101ciju par vis\u0101m lietot\u0101ju kontiem, ko var ieg\u016bt, izmantojot SQL izteiksmes 'CREATE USER' un 'GRANT'. Lai atbilsto\u0161i pievienotu 'DROP USER' izteiksmi pirms 'CREATE USER', ir paredz\u0113ta opcija '--add-drop-user', bet, lai selekt\u012bvi atspogu\u013cotu atsevi\u0161\u0137us lietot\u0101jus datos, ir opcijas '--include-user=user@host' un '--exclude-user=user@host', kuras var nor\u0101d\u012bt vair\u0101kas reizes.\n<li class=\"l\"> MLE (Multilingual Engine Component) dzin\u0113j\u0101, kas \u013cauj izmantot valodas, kas at\u0161\u0137iras no SQL, kr\u0101tuves proced\u016br\u0101s un funkcij\u0101s, ir uzlabota JavaScript atbalsta funkcionalit\u0101te. JavaScript valod\u0101 rakst\u012bt\u0101m kr\u0101tuves proced\u016br\u0101m ir ieviests 'DECIMAL' tips, ko var izmantot ien\u0101ko\u0161ajiem un atgrie\u017eamajiem argumentiem. Dro\u0161\u012bbas nol\u016bkos MySQL 'DECIMAL' tips p\u0113c noklus\u0113juma tiek p\u0101rveidots uz JavaScript 'String' tipu, ta\u010du \u0161o uzved\u012bbu var main\u012bt ar komandu 'SELECT mle_set_session_state('{'decimal_type':'Number'}')', p\u0113c kuras tiks izmantots JavaScript 'Number' tips. Atbalsta v\u0113rt\u012bbu p\u0101rv\u0113r\u0161anu uz DECIMAL tipu ar JavaScript Boolean, Number, String un BigInt tipiem.\n<li class=\"l\"> JavaScript kr\u0101tuves proced\u016br\u0101s ir pievienota atbalsta funkcionalit\u0101te lok\u0101lo parametru iestat\u012b\u0161anai, izmantojot JavaScript API Intl. Piem\u0113ram, lai noteiktu pa\u0161reiz\u0113jo valodu, var izmantot \u012bpa\u0161\u012bbas 'Intl.DateTimeFormat().resolvedOptions().locale', bet, lai p\u0101rietu uz citu valodu - metodi 'toLocaleString()'.\n<li class=\"l\"> Papla\u0161in\u0101t\u0101s iesp\u0113jas JavaScript bibliot\u0113ku p\u0101rvald\u012bb\u0101: tagad, lai main\u012btu import\u0113to bibliot\u0113ku sarakstu, varat izmantot izteiksmes &#171;ALTER PROCEDURE&#187; un &#171;ALTER FUNCTION&#187;. Tika pievienota iesp\u0113ja izmantot izteiksmi &#171;ALTER LIBRARY&#187; bibliot\u0113kas SQL koment\u0101ra pievieno\u0161anai, dz\u0113\u0161anai vai modific\u0113\u0161anai. Inform\u0101cijas ieg\u016b\u0161anai par bibliot\u0113ku ir ieviesta izteiksme &#171;SHOW LIBRARY STATUS&#187;.\n<li class=\"l\"> Tika pievienota atbalsts dinamiskiem JavaScript bibliot\u0113ku iel\u0101d\u0113\u0161anai. Lai dinamiskai bibliot\u0113kas import\u0113\u0161anai izmantotu, j\u0101lieto atsl\u0113gv\u0101rds &#171;await&#187;, piem\u0113ram, &#171;let module = await import(&#8216;\\\/db1\\\/lib_${object_type}&#8217;)&#187;.\n<li class=\"l\"> Papla\u0161in\u0101tas vaic\u0101jumu optimiz\u0101cijas, kas izmanto kvantific\u0113tos sal\u012bdzino\u0161os operatorus. Papildus atbalstam operatoriem &#171;=ANY&#187; un &#171;&lt;&gt;ALL&#187; zem\u0101k uzrakstu optimiz\u0101cijai jaunaj\u0101 versij\u0101 tika pievienots atbalsts operatoriem &#171;&gt;ANY&#187;, &#171;&gt;=ANY&#187;, &#171;&lt;ANY&#187;, &#171;&lt;=ANY&#187;, &#171;&gt;ALL&#187;, &#171;&gt;=ALL&#187;, &#171;&lt;ALL&#187; un &#171;&lt;=ALL&#187;.\n<li class=\"l\"> Tika no\u0146emts spraudnis &#171;version_tokens&#187;, kas iepriek\u0161 tika pazi\u0146ots par novecoju\u0161u.\n<li class=\"l\"> Aizliegts izvirz\u012bt 0 v\u0113rt\u012bbu sist\u0113miskajai main\u012bgajai replica_parallel_workers.\n<li class=\"l\"> Nov\u0113rsti 28 ievainojam\u012bbas, no kur\u0101m 26 var tikt izmantotas att\u0101lin\u0101ti ar piek\u013cuvi, lai nos\u016bt\u012btu piepras\u012bjumus uz DBMS. Se\u0161as nopietn\u0101k\u0101s probl\u0113mas ir ar b\u012bstam\u012bbas l\u012bmeni 6.5 un saist\u012btas ar ievainojam\u012bb\u0101m InnoDB dzin\u0113j\u0101, pars\u0113t\u0101j\u0101 un optimiz\u0113t\u0101j\u0101. Maz\u0101k b\u012bstamas ievainojam\u012bbas ietekm\u0113 mysqldump, InnoDB, optimiz\u0113t\u0101ju, DDL, UDF, pars\u0113t\u0101ju un replik\u0101cijas sist\u0113mu.   <\/ul>\n<p>Avots: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=63106\">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.3.0. \u0421\u0431\u043e\u0440\u043a\u0438 MySQL Community Server 9.3.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 \u043d\u043e\u0432\u043e\u0439 \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.3 \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 [&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-123615","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.3.0. \u0421\u0431\u043e\u0440\u043a\u0438 MySQL Community Server 9.3.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-3-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.3.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.3.0. \u0421\u0431\u043e\u0440\u043a\u0438 MySQL Community Server 9.3.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-3-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-04-20T07:05:07+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2025-04-20T07:05:07+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 DBMS 9.3.0 izlai\u0161ana | ProHoster","description":"Uz\u0146\u0113mums Oracle izveidojis jaunu MySQL DBMS 9.3.0 zari. MySQL Community Server 9.3.0 b\u016bves ir sagatavotas vis\u0101m popul\u0101r\u0101kaj\u0101m Linux, FreeBSD, macOS un Windows izplat\u012b\u0161an\u0101m.","canonical_url":"https:\/\/prohoster.info\/lv\/blog\/news\/vypusk-subd-mysql-9-3-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.3.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.3.0. \u0421\u0431\u043e\u0440\u043a\u0438 MySQL Community Server 9.3.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-3-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-04-20T07:05:07+00:00","article:modified_time":"2025-04-20T07:05:07+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"123615","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 12:19:20","breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2026-01-23 12:19:20","updated":"2026-01-23 12:19:20","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\/123615","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=123615"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/posts\/123615\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/media?parent=123615"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/categories?post=123615"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/tags?post=123615"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}