{"id":161781,"date":"2026-02-19T11:11:59","date_gmt":"2026-02-19T09:11:59","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/stabilnyj-vypusk-subd-mariadb-12-2"},"modified":"2026-02-19T11:11:59","modified_gmt":"2026-02-19T09:11:59","slug":"stabilnyj-vypusk-subd-mariadb-12-2","status":"publish","type":"post","link":"https:\/\/prohoster.info\/et\/blog\/news\/stabilnyj-vypusk-subd-mariadb-12-2","title":{"rendered":"MariaDB 12.2 andmebaasi stabiilne v\u00e4ljaanne","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>MariaDB 12.2.2 versiooni v\u00e4ljaanne on avalikustatud, mis m\u00e4rgib esimest stabiilset v\u00e4ljalaset harust 12.2. MariaDB 12.2 haru on m\u00e4\u00e4ratud vahepealseks v\u00e4ljaandeks (rolling), j\u00e4tkab funktsionaalsuse j\u00e4rkj\u00e4rgulist arendamist ning asendab MariaDB 12.1 haru. Samal ajal on v\u00e4lja antud MariaDB 12.3.1 versioon koos uue binlogi rakendusega, millel on kandidaatriigi staatus tulevase LTS-haru v\u00e4ljaandmiseks. MariaDB 12.2 haru toetamise aeg l\u00f5peb v\u00e4ljundi 12.3.2 ajaks.    <\/p>\n<p>MariaDB projekt arendab MySQL-ist hargnenud versiooni, mis s\u00e4ilitab tagasip\u00f6\u00f6ratavuse ja erineb t\u00e4iendavate salvestusmootorite integreerimise ja laialdaste v\u00f5imaluste poolest. MariaDB arendust juhib s\u00f5ltumatu organisatsioon MariaDB Foundation vastavalt avatud ja l\u00e4bipaistvale arendusprotsessile, mis ei s\u00f5ltu \u00fcksikutest tootjatest. MariaDB on paljudes Linuxi jaotustes (RHEL, SUSE, Fedora, openSUSE, Slackware, OpenMandriva, ROSA, Arch Linux, Debian) saadaval MySQL asemel ja on rakendatud suurtes projektides nagu Wikipedia, Google Cloud SQL ja Nimbuzz.       <\/p>\n<p>MariaDB 12.2 haru muudatused:  <\/p>\n<ul>\n<li class=\"l\"> Oracle\u2019i andmebaasi \u00fchilduvuse re\u017eiimis on rakendatud funktsioonid TO_NUMBER (stringi numbriks teisendamine) ja TRUNC (kuup\u00e4eva l\u00f5ikamine, n\u00e4iteks tunni, p\u00e4eva, kuu v\u00f5i aasta tasemel).\n<li class=\"l\"> Tabelite \u00fchendamise (JOIN) toimingute k\u00e4igus on rakendatud optimeerimist, mis arvestab alamp\u00e4ringutes \"GROUP BY\" v\u00e4ljendi unikaalsust, et t\u00e4psemalt prognoosida tulevaste ridade arvu (out_rows) ja \u00f5igesti rakendada indekseid.\n<li class=\"l\"> Lisatud uued ROWID_FILTER \/ NO_ROWID_FILTER ja INDEX_MERGE \/ NO_INDEX_MERGE optimeerija haldamise valikud, samuti v\u00f5imalus n\u00e4idata plokkide nimesid p\u00e4ringutes kaudselt (optimeerimise valikuid saab rakendada t\u00e4pselt p\u00e4ringute osadele, viidates neile nimede kaudu \"select#N\", kus N on ploki j\u00e4rjestnumber). N\u00e4iteks: \"select \/*+ JOIN_ORDER(@select#2\" twenty,ten) *\/ ....\".\n<li class=\"l\"> JSON funktsioonide korral on t\u00fchistatud struktuuride pesastamise taseme piirangud (eemaldatud JSON_DEPTH_LIMIT, mis varem v\u00f5ttis v\u00e4\u00e4rtuse 32).\n<li class=\"l\"> INFORMATION_SCHEMA skeemi on lisatud tabel TRIGGERED_UPDATE_COLUMNS (INFORMATION_SCHEMA.TRIGGERED_UPDATE_COLUMNS), mis n\u00e4itab, millised veerud muutuvad trikkide aktiveerimisel.\n<li class=\"l\"> INFORMATION_SCHEMA skeemi PARAMETERS tabelis on rakendatud veerg PARAMETER_DEFAULT, mis sisaldab salvestatud protseduuride parameetrite vaikimisi v\u00e4\u00e4rtusi.\n<li class=\"l\"> Eksperimentaalne toetamine \"CREATE GLOBAL TEMPORARY TABLE\" v\u00e4ljendile on sisse viidud globaalsete ajutiste tabelite loomiseks. Sellised ajutised tabelid kustutatakse seansi l\u00f5ppedes ning on n\u00e4htavad k\u00f5igile kasutajatele, kuid sisaldavad andmeid, mis on iga kasutaja jaoks individuaalsed.\n<li class=\"l\"> Testre\u017eiimis on pakutud parandatud toetus replikatsiooniks tabelite vahel, millel on erinev struktuur.    <\/ul>\n<p>Allikas: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=64826\">opennet.ru<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u041e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d \u0432\u044b\u043f\u0443\u0441\u043a \u0421\u0423\u0411\u0414 MariaDB 12.2.2, \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u043e\u0442\u043c\u0435\u0447\u0435\u043d \u043a\u0430\u043a \u043f\u0435\u0440\u0432\u044b\u0439 \u0441\u0442\u0430\u0431\u0438\u043b\u044c\u043d\u044b\u0439 \u0440\u0435\u043b\u0438\u0437 \u0432\u0435\u0442\u043a\u0438 12.2. \u0412\u0435\u0442\u043a\u0430 MariaDB 12.2 \u043e\u0442\u043d\u0435\u0441\u0435\u043d\u0430 \u043a \u043f\u0440\u043e\u043c\u0435\u0436\u0443\u0442\u043e\u0447\u043d\u044b\u043c \u0432\u044b\u043f\u0443\u0441\u043a\u0430\u043c (rolling), \u043f\u0440\u043e\u0434\u043e\u043b\u0436\u0430\u0435\u0442 \u043f\u043e\u0441\u0442\u0435\u043f\u0435\u043d\u043d\u043e\u0435 \u0440\u0430\u0437\u0432\u0438\u0442\u0438\u0435 \u0444\u0443\u043d\u043a\u0446\u0438\u043e\u043d\u0430\u043b\u044c\u043d\u043e\u0441\u0442\u0438 \u0438 \u043f\u0440\u0438\u0448\u043b\u0430 \u043d\u0430 \u0441\u043c\u0435\u043d\u0443 \u0432\u0435\u0442\u043a\u0435 MariaDB 12.1. \u041e\u0434\u043d\u043e\u0432\u0440\u0435\u043c\u0435\u043d\u043d\u043e \u043e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d \u0432\u044b\u043f\u0443\u0441\u043a MariaDB 12.3.1 \u0441 \u043d\u043e\u0432\u043e\u0439 \u0440\u0435\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u0435\u0439 binlog, \u0438\u043c\u0435\u044e\u0449\u0438\u0439 \u0441\u0442\u0430\u0442\u0443\u0441 \u043a\u0430\u043d\u0434\u0438\u0434\u0430\u0442\u0430 \u0432 \u0440\u0435\u043b\u0438\u0437\u044b \u0431\u0443\u0434\u0443\u0449\u0435\u0439 LTS-\u0432\u0435\u0442\u043a\u0438. \u0412\u0435\u0442\u043a\u0430 MariaDB 12.2 \u0431\u0443\u0434\u0435\u0442 \u0441\u043e\u043f\u0440\u043e\u0432\u043e\u0436\u0434\u0430\u0442\u044c\u0441\u044f \u0434\u043e \u0444\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":8,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[702],"tags":[],"class_list":["post-161781","post","type-post","status-publish","format-standard","hentry","category-news"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.1.1 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u041e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d \u0432\u044b\u043f\u0443\u0441\u043a \u0421\u0423\u0411\u0414 MariaDB 12.2.2, \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u043e\u0442\u043c\u0435\u0447\u0435\u043d \u043a\u0430\u043a \u043f\u0435\u0440\u0432\u044b\u0439 \u0441\u0442\u0430\u0431\u0438\u043b\u044c\u043d\u044b\u0439 \u0440\u0435\u043b\u0438\u0437 \u0432\u0435\u0442\u043a\u0438 12.2.\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Erik Peterson\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/prohoster.info\/et\/blog\/news\/stabilnyj-vypusk-subd-mariadb-12-2\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.1.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"et_EE\" \/>\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\u0421\u0442\u0430\u0431\u0438\u043b\u044c\u043d\u044b\u0439 \u0432\u044b\u043f\u0443\u0441\u043a \u0421\u0423\u0411\u0414 MariaDB 12.2 | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u041e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d \u0432\u044b\u043f\u0443\u0441\u043a \u0421\u0423\u0411\u0414 MariaDB 12.2.2, \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u043e\u0442\u043c\u0435\u0447\u0435\u043d \u043a\u0430\u043a \u043f\u0435\u0440\u0432\u044b\u0439 \u0441\u0442\u0430\u0431\u0438\u043b\u044c\u043d\u044b\u0439 \u0440\u0435\u043b\u0438\u0437 \u0432\u0435\u0442\u043a\u0438 12.2.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/et\/blog\/news\/stabilnyj-vypusk-subd-mariadb-12-2\" \/>\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=\"2026-02-19T09:11:59+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2026-02-19T09:11:59+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\udd47 Stabiilne MariaDB 12.2 andmebaasi v\u00e4ljaanne | ProHoster","description":"MariaDB 12.2.2 versioon on avalikustatud, mis on m\u00e4rgitud esimeseks stabiilseks v\u00e4ljalaseks harust 12.2.","canonical_url":"https:\/\/prohoster.info\/et\/blog\/news\/stabilnyj-vypusk-subd-mariadb-12-2","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"et_EE","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\u0421\u0442\u0430\u0431\u0438\u043b\u044c\u043d\u044b\u0439 \u0432\u044b\u043f\u0443\u0441\u043a \u0421\u0423\u0411\u0414 MariaDB 12.2 | ProHoster","og:description":"\u041e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d \u0432\u044b\u043f\u0443\u0441\u043a \u0421\u0423\u0411\u0414 MariaDB 12.2.2, \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u043e\u0442\u043c\u0435\u0447\u0435\u043d \u043a\u0430\u043a \u043f\u0435\u0440\u0432\u044b\u0439 \u0441\u0442\u0430\u0431\u0438\u043b\u044c\u043d\u044b\u0439 \u0440\u0435\u043b\u0438\u0437 \u0432\u0435\u0442\u043a\u0438 12.2.","og:url":"https:\/\/prohoster.info\/et\/blog\/news\/stabilnyj-vypusk-subd-mariadb-12-2","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":"2026-02-19T09:11:59+00:00","article:modified_time":"2026-02-19T09:11:59+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"161781","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-19 09:12:58","breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2026-02-19 09:11:59","updated":"2026-02-19 09:12:58","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts\/161781","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/comments?post=161781"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts\/161781\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/media?parent=161781"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/categories?post=161781"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/tags?post=161781"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}