{"id":86434,"date":"2020-06-25T01:42:11","date_gmt":"2020-06-24T23:42:11","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/stabilnyj-vypusk-subd-mariadb-10-5"},"modified":"2020-06-25T01:42:11","modified_gmt":"2020-06-24T23:42:11","slug":"stabilnyj-vypusk-subd-mariadb-10-5","status":"publish","type":"post","link":"https:\/\/prohoster.info\/et\/blog\/news\/stabilnyj-vypusk-subd-mariadb-10-5","title":{"rendered":"Stabiilne MariaDB 10.5 andmebaasi v\u00e4ljaanne","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>P\u00e4rast aasta arendust ja nelja eelv\u00e4ljaannet <noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.org\/mariadb-10-5-4-now-available\/\">on ette valmistatud<\/a><\/noindex> on esimene stabiilne versioon uue andmebaasi haru kohta <noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/mariadb-1054-release-notes\/\">MariaDB 10.4<\/a><\/noindex>, mille raames areneb MySQL'ist eraldunud versioon, mis s\u00e4ilitab tagasitagamise \u00fchilduvuse ja   <noindex><a rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=39444#note\">erineb<\/a><\/noindex> t\u00e4iendavate salvestusmootorite integreerimise ja laiendatud v\u00f5imalustega. Uue haru toetamine kestab 5 aastat, kuni juuni 2025. <\/p>\n<p>MariaDB arengut juhib s\u00f5ltumatu organisatsioon MariaDB Foundation, j\u00e4rgides t\u00e4iesti avatud ja l\u00e4bipaistvat arendamismudelit, mis ei s\u00f5ltu \u00fcksikutest tootjatest. MariaDB tarnitakse MySQL asemel paljudes Linuxi distributsioonides (RHEL, SUSE, Fedora, openSUSE, Slackware, OpenMandriva, ROSA, Arch Linux, Debian) ja on rakendatud suurtes projektides nagu <noindex><a rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=36759\">Wikipedia<\/a><\/noindex>, <noindex><a rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=37905\">Google Cloud SQL<\/a><\/noindex> ja <noindex><a rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=36506\">Nimbuzz<\/a><\/noindex>.<\/p>\n<p>Peamised <noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/mdb-1054-rn\/\">parandused<\/a><\/noindex> <noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/changes-improvements-in-mariadb-105\/\">MariaDB 10.5<\/a><\/noindex>:\n<\/p>\n<ul>\n<li class=\"l\"> Lisa salvestusmootor <noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/s3-storage-engine\/\">S3<\/a><\/noindex>, mis v\u00f5imaldab salvestada MariaDB tabeleid Amazon S3-s v\u00f5i igas teises avalikus v\u00f5i erahoiustamises, mis toetab S3 API-d. Toetatakse S3-s nii tavaliste kui ka jaotatud (partitsioneeritud) tabelite salvestamist. Kui tabelid on pilves jaotatud, saavad neid otse kasutada ka teised serverid, millel on juurdep\u00e4\u00e4s S3 hoidmale.\n<li class=\"l\"> Lisa salvestusmootor <noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/mariadb-columnstore\/\">ColumnStore<\/a><\/noindex>, mis salvestab andmeid veergude kaupa ja kasutab <noindex><a rel=\"nofollow\" href=\"https:\/\/ru.wikipedia.org\/wiki\/%D0%9C%D0%B0%D1%81%D1%81%D0%BE%D0%B2%D0%BE-%D0%BF%D0%B0%D1%80%D0%B0%D0%BB%D0%BB%D0%B5%D0%BB%D1%8C%D0%BD%D0%B0%D1%8F_%D0%B0%D1%80%D1%85%D0%B8%D1%82%D0%B5%D0%BA%D1%82%D1%83%D1%80%D0%B0\">massiivset paralleelset<\/a><\/noindex> jaotatud arhitektuuri. Mootor p\u00f5hineb MySQL-hoidla <noindex><a rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=25267\">InfiniDB<\/a><\/noindex> t\u00f6\u00f6tlusprotsessidel ja on m\u00f5eldud suurte andmemahtu anal\u00fc\u00fctiliste p\u00e4ringute t\u00f6\u00f6tlemiseks ja t\u00e4itmiseks (Data Warehouse).<br \/>\nColumnStore salvestab andmeid mitte ridade kaupa, vaid veergude l\u00f5ikes, mis v\u00f5imaldab optimeerida r\u00fchmitamise t\u00e4itmist suurest andmebaasist, mis h\u00f5lmab petabaitide andmeid. Toetatakse lineaarset skaleerimist, andmete salvestamist kokkusurutud vormis, vertikaalset ja horisontaalset partitsioneerimist, t\u00f5husat konkurentsiv\u00f5imeliste p\u00e4ringute t\u00e4itmist.<\/p>\n<li class=\"l\"> \u0412\u0441\u0435 \u0438\u0441\u043f\u043e\u043b\u043d\u044f\u0435\u043c\u044b\u0435 \u0444\u0430\u0439\u043b\u044b, \u043d\u0430\u0447\u0438\u043d\u0430\u044e\u0449\u0438\u0435\u0441\u044f \u0441\u043e \u0441\u043b\u043e\u0432\u0430 &#171;mysql&#187; \u043f\u0435\u0440\u0435\u0438\u043c\u0435\u043d\u043e\u0432\u0430\u043d\u044b \u0441 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0435\u043c \u0441\u043b\u043e\u0432\u0430 &#171;mariadb&#187;. \u0421\u0442\u0430\u0440\u044b\u0435 \u0438\u043c\u0435\u043d\u0430 \u0441\u043e\u0445\u0440\u0430\u043d\u0435\u043d\u044b \u0432 \u0444\u043e\u0440\u043c\u0435 \u0441\u0438\u043c\u0432\u043e\u043b\u0438\u0447\u0435\u0441\u043a\u0438\u0445 \u0441\u0441\u044b\u043b\u043e\u043a.\n<li class=\"l\"> Lisatud on uus andmet\u00fc\u00fcp <noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/inet6\/\">INET6<\/a><\/noindex> IPv6 aadresside salvestamiseks.\n<li class=\"l\"> \u0412\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u0430 \u0440\u0430\u0431\u043e\u0442\u0430 \u043f\u043e \u0440\u0430\u0437\u0434\u0435\u043b\u0435\u043d\u0438\u044e \u043f\u0440\u0438\u0432\u0438\u043b\u0435\u0433\u0438\u0439 \u043d\u0430 \u0431\u043e\u043b\u0435\u0435 \u043c\u0435\u043b\u043a\u0438\u0435 \u0441\u043e\u0441\u0442\u0430\u0432\u043b\u044f\u044e\u0449\u0438\u0435. \u0412\u043c\u0435\u0441\u0442\u043e \u043e\u0431\u0449\u0435\u0439 \u043f\u0440\u0438\u0432\u0438\u043b\u0435\u0433\u0438\u0438 SUPER \u043f\u0440\u0435\u0434\u043b\u043e\u0436\u0435\u043d\u0430 \u0441\u0435\u0440\u0438\u044f \u0438\u0437 \u0432\u044b\u0431\u043e\u0440\u043e\u0447\u043d\u044b\u0445 \u043f\u0440\u0438\u0432\u0438\u043b\u0435\u0433\u0438\u0439   &#171;BINLOG ADMIN&#187;,<br \/>\n    &#171;BINLOG REPLAY&#187;,<br \/>\n    &#171;CONNECTION ADMIN&#187;,<br \/>\n    &#171;FEDERATED ADMIN&#187;,<br \/>\n    &#171;READ_ONLY ADMIN&#187;,<br \/>\n    &#171;REPLICATION MASTER ADMIN&#187;,<br \/>\n    &#171;REPLICATION SLAVE ADMIN&#187; \u0438<br \/>\n    &#171;SET USER&#187;. <\/p>\n<li class=\"l\"> \u041f\u0440\u0438\u0432\u0438\u043b\u0435\u0433\u0438\u044f  &#171;REPLICATION CLIENT&#187; \u043f\u0435\u0440\u0435\u0438\u043c\u0435\u043d\u043e\u0432\u0430\u043d\u0430 \u0432 &#171;BINLOG MONITOR&#187;, \u0430 \u0432\u044b\u0440\u0430\u0436\u0435\u043d\u0438\u0435 &#171;SHOW MASTER STATUS&#187; \u0432 &#171;SHOW BINLOG STATUS&#187;. \u041f\u0435\u0440\u0435\u0438\u043c\u0435\u043d\u043e\u0432\u0430\u043d\u0438\u0435 \u0443\u0442\u043e\u0447\u043d\u044f\u0435\u0442 \u043f\u043e\u0432\u0435\u0434\u0435\u043d\u0438\u0435 \u0438 \u043d\u0435 \u0441\u0432\u044f\u0437\u0430\u043d\u043e \u0441 \u043f\u043e\u043b\u0438\u0442\u043a\u043e\u0440\u0440\u0435\u043a\u0442\u043d\u043e\u0441\u0442\u044c\u044e, \u043f\u0440\u043e\u0435\u043a\u0442 \u043d\u0435 \u043e\u0442\u043a\u0430\u0437\u044b\u0432\u0430\u0435\u0442\u0441\u044f \u043e\u0442 \u0442\u0435\u0440\u043c\u0438\u043d\u043e\u0432 master\/slave \u0438 \u0434\u0430\u0436\u0435 \u0434\u043e\u0431\u0430\u0432\u0438\u043b \u043d\u043e\u0432\u044b\u0435 \u043f\u0440\u0438\u0432\u0438\u043b\u0435\u0433\u0438\u0438 &#171;MASTER ADMIN&#187; \u0438 &#171;SLAVE ADMIN&#187;. \u041f\u0440\u0438 \u044d\u0442\u043e\u043c \u0432 SQL \u0432\u044b\u0440\u0430\u0436\u0435\u043d\u0438\u044f \u0434\u043e\u0431\u0430\u0432\u043b\u0435\u043d \u043d\u043e\u0432\u044b\u0439 \u043a\u043b\u044e\u0447 &#171;REPLICA&#187;, \u044f\u0432\u043b\u044f\u044e\u0449\u0438\u0439\u0441\u044f \u0441\u0438\u043d\u043e\u043d\u0438\u043c\u043e\u043c &#171;SLAVE&#187;.\n<li class=\"l\"> \u0414\u043b\u044f \u043d\u0435\u043a\u043e\u0442\u043e\u0440\u044b\u0435 \u0432\u044b\u0440\u0430\u0436\u0435\u043d\u0438\u0439 \u0438\u0437\u043c\u0435\u043d\u0435\u043d\u044b \u043f\u0440\u0438\u0432\u0438\u043b\u0435\u0433\u0438\u0438, \u043d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c\u044b\u0435 \u0434\u043b\u044f \u0438\u0445 \u0432\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u044f.   &#171;SHOW BINLOG EVENTS&#187; \u0442\u0435\u043f\u0435\u0440\u044c \u0442\u0440\u0435\u0431\u0443\u0435\u0442 \u043f\u0440\u0430\u0432 &#171;BINLOG MONITOR&#187; \u0432\u043c\u0435\u0441\u0442\u043e &#171;REPLICATION SLAVE&#187;,  &#171;SHOW SLAVE HOSTS&#187; \u0442\u0440\u0435\u0431\u0443\u0435\u0442 \u043f\u0440\u0438\u0432\u0438\u043b\u0435\u0433\u0438\u0438 &#171;REPLICATION MASTER ADMIN&#187; \u0432\u043c\u0435\u0441\u0442\u043e &#171;REPLICATION SLAVE&#187;, &#171;SHOW SLAVE STATUS&#187; \u0442\u0440\u0435\u0431\u0443\u0435\u0442 \u043f\u0440\u0430\u0432 &#171;REPLICATION SLAVE ADMIN&#187; \u0438\u043b\u0438 &#171;SUPER&#187; \u0432\u043c\u0435\u0441\u0442\u043e &#171;REPLICATION CLIENT&#187;, &#171;SHOW RELAYLOG EVENTS&#187; \u0442\u0440\u0435\u0431\u0443\u0435\u0442 \u043f\u0440\u0430\u0432 &#171;REPLICATION SLAVE ADMIN&#187; \u0432\u043c\u0435\u0441\u0442\u043e &#171;REPLICATION SLAVE&#187;.\n<li class=\"l\"> \u0414\u043e\u0431\u0430\u0432\u043b\u0435\u043d\u044b \u043a\u043e\u043d\u0441\u0442\u0440\u0443\u043a\u0446\u0438\u0438 &#171;<noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/insertreturning\/\">INSERT &#8230; RETURNING<\/a><\/noindex>&#187; ja &#171;<noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/replacereturning\/\">REPLACE &#8230; RETURNING<\/a><\/noindex>&#171;, \u0432\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u044e\u0449\u0438\u0435 \u0441\u043f\u0438\u0441\u043e\u043a \u0432\u0441\u0442\u0430\u0432\u043b\u0435\u043d\u043d\u044b\u0445\/\u0437\u0430\u043c\u0435\u043d\u0451\u043d\u043d\u044b\u0445 \u0441\u0442\u043e\u043a \u0432 \u0444\u043e\u0440\u043c\u0435, \u043a\u0430\u043a \u0435\u0441\u043b\u0438 \u0431\u044b \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u044f \u0432\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u043b\u0438\u0441\u044c \u043f\u0440\u0438 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0438 \u0432\u044b\u0440\u0430\u0436\u0435\u043d\u0438\u044f SELECT (\u043f\u043e \u0430\u043d\u0430\u043b\u043e\u0433\u0438\u0438 \u0441 &#171;DELETE &#8230; RETURNING&#187;).\n<p>   INSERT INTO t2 VALUES (1,&#8217;Dog&#8217;),(2,&#8217;Lion&#8217;),(3,&#8217;Tiger&#8217;),(4,&#8217;Leopard&#8217;)<br \/>\n   RETURNING id2,id2+id2,id2&#038;id2,id2||id2;<br \/>\n   +&#8212;&#8212;+&#8212;&#8212;&#8212;+&#8212;&#8212;&#8212;+&#8212;&#8212;&#8212;-+<br \/>\n   | id2 | id2+id2 | id2&#038;id2 | id2||id2 |<br \/>\n   +&#8212;&#8212;+&#8212;&#8212;&#8212;+&#8212;&#8212;&#8212;+&#8212;&#8212;&#8212;-+<br \/>\n   |   1 |       2 |       1 |        1 |<br \/>\n   |   2 |       4 |       2 |        1 |<br \/>\n   |   3 |       6 |       3 |        1 |<br \/>\n   |   4 |       8 |       4 |        1 |<br \/>\n   +&#8212;&#8212;+&#8212;&#8212;&#8212;+&#8212;&#8212;&#8212;+&#8212;&#8212;&#8212;-+<\/p>\n<li class=\"l\"> \u0414\u043e\u0431\u0430\u0432\u043b\u0435\u043d\u044b \u0432\u044b\u0440\u0430\u0436\u0435\u043d\u0438\u044f &#171;<noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/except\/\">EXCEPT ALL<\/a><\/noindex>&#187; ja &#171;<noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/intersect\/\">INTERSECT ALL<\/a><\/noindex>&#187; \u0434\u043b\u044f \u0438\u0441\u043a\u043b\u044e\u0447\u0435\u043d\u0438\u044f\/\u0434\u043e\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u044f \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442\u0430 \u043e\u043f\u0440\u0435\u0434\u0435\u043b\u0451\u043d\u043d\u044b\u043c \u043d\u0430\u0431\u043e\u0440\u043e\u043c \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0439.\n<li class=\"l\"> \u041f\u043e\u044f\u0432\u0438\u043b\u0430\u0441\u044c \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e\u0441\u0442\u044c \u0443\u043a\u0430\u0437\u0430\u043d\u0438\u044f \u043a\u043e\u043c\u043c\u0435\u043d\u0442\u0430\u0440\u0438\u0435\u0432 \u0432\u043d\u0443\u0442\u0440\u0438 \u0431\u043b\u043e\u043a\u043e\u0432 &#171;CREATE DATABASE&#187; \u0438 &#171;ALTER DATABASE&#187;.\n<li class=\"l\"> \u0414\u043e\u0431\u0430\u0432\u043b\u0435\u043d\u044b \u043a\u043e\u043d\u0441\u0442\u0440\u0443\u043a\u0446\u0438\u0438 \u0434\u043b\u044f \u043f\u0435\u0440\u0435\u0438\u043c\u0435\u043d\u043e\u0432\u0430\u043d\u0438\u044f \u0438\u043d\u0434\u0435\u043a\u0441\u043e\u0432 \u0438 \u0441\u0442\u043e\u043b\u0431\u0446\u043e\u0432 &#171;<noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/alter-table\/#rename-indexkey\">ALTER TABLE &#8230; RENAME INDEX \/ KEY<\/a><\/noindex>&#187; \u0438  &#171;<noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/alter-table\/#rename-column\">ALTER TABLE &#8230; RENAME COLUMN<\/a><\/noindex>&#171;.\n<li class=\"l\"> \u0412 \u043e\u043f\u0435\u0440\u0430\u0446\u0438\u0438 &#171;ALTER TABLE&#187; \u0438 &#171;RENAME TABLE&#187; \u0434\u043e\u0431\u0430\u0432\u043b\u0435\u043d\u0430  \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u043a\u0430 \u0443\u0441\u043b\u043e\u0432\u0438\u044f &#171;IF EXISTS&#187; \u0434\u043b\u044f \u0432\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u044f \u043e\u043f\u0435\u0440\u0430\u0446\u0438\u0438 \u0442\u043e\u043b\u044c\u043a\u043e \u043f\u0440\u0438 \u0441\u0443\u0449\u0435\u0441\u0442\u0432\u043e\u0432\u0430\u043d\u0438\u0438 \u0442\u0430\u0431\u043b\u0438\u0446\u044b;\n<li class=\"l\"> \u0414\u043b\u044f \u0438\u043d\u0434\u0435\u043a\u0441\u043e\u0432 \u0432 &#171;CREATE TABLE&#187; \u0440\u0435\u0430\u043b\u0438\u0437\u043e\u0432\u0430\u043d \u0430\u0442\u0440\u0438\u0431\u0443\u0442 &#171;<noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/create-table\/#visible-index-option\">VISIBLE<\/a><\/noindex>&#171;.\n<li class=\"l\"> \u0414\u043e\u0431\u0430\u0432\u043b\u0435\u043d\u043e \u0432\u044b\u0440\u0430\u0436\u0435\u043d\u0438\u0435 &#171;CYCLE&#187; \u0434\u043b\u044f \u0432\u044b\u044f\u0432\u043b\u0435\u043d\u0438\u044f \u0440\u0435\u043a\u0443\u0440\u0441\u0438\u0432\u043d\u044b\u0445 \u0446\u0438\u043a\u043b\u043e\u0432 <noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/common-table-expressions\/\">CTE<\/a><\/noindex>.\n<li class=\"l\"> Lisatud funktsioonid <noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/json_arrayagg\/\">JSON_ARRAYAGG<\/a><\/noindex> ja <noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/json_objectagg\/\">JSON_OBJECTAGG<\/a><\/noindex> tagastamiseks massiiv v\u00f5i JSON objekt m\u00e4\u00e4ratud veeru v\u00e4\u00e4rtustega.\n<li class=\"l\"> Lisatud on teenindustabelid (THREAD_POOL_GROUPS, THREAD_POOL_QUEUES, THREAD_POOL_STATS ja THREAD_POOL_WAITS) voogedastuseks (thread_pool).\n<li class=\"l\"> V\u00e4ljend ANALYZE on laienenud, n\u00e4idates aega, mis kulub WHERE ploki kontrollimiseks ja abitegevuste teostamiseks.\n<li class=\"l\"> \u0412 \u043e\u043f\u0442\u0438\u043c\u0438\u0437\u0430\u0442\u043e\u0440\u0435  \u043e\u0431\u0440\u0430\u0431\u043e\u0442\u043a\u0438 \u0434\u0438\u0430\u043f\u0430\u0437\u043e\u043d\u043e\u0432 \u0443\u0447\u0442\u0435\u043d\u044b \u043f\u0440\u0438\u0437\u043d\u0430\u043a\u0438 &#171;IS NOT NULL&#187;\n<li class=\"l\"> Ajutiste failide suurust, mida kasutatakse sortimise ajal koos t\u00fc\u00fcpi VARCHAR, CHAR ja BLOB-ga, on oluliselt v\u00e4hendatud.\n<li class=\"l\"> Uues <noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/binary-log\/\">binaarne logi<\/a><\/noindex>, \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0435\u043c\u044b\u0439 \u0434\u043b\u044f \u043e\u0440\u0433\u0430\u043d\u0438\u0437\u0430\u0446\u0438\u0438 \u0440\u0435\u043f\u043b\u0438\u043a\u0430\u0446\u0438\u0438, \u0434\u043e\u0431\u0430\u0432\u043b\u0435\u043d\u044b \u043d\u043e\u0432\u044b\u0435 \u043f\u043e\u043b\u044f \u0441 \u043c\u0435\u0442\u0430\u0434\u0430\u043d\u043d\u044b\u043c\u0438,  \u0432\u043a\u043b\u044e\u0447\u0430\u044f Primary Key, Column Name, Character Set \u0438 Geometry Type. \u0412 \u0443\u0442\u0438\u043b\u0438\u0442\u0435 mariadb-binlog \u0438 \u043a\u043e\u043c\u0430\u043d\u0434\u0430\u0445 &#171;SHOW BINLOG EVENTS&#187; \u0438 &#171;SHOW RELAYLOG EVENTS&#187; \u043e\u0431\u0435\u0441\u043f\u0435\u0447\u0435\u043d \u043f\u043e\u043a\u0430\u0437  \u0444\u043b\u0430\u0433\u043e\u0432 \u0440\u0435\u043f\u043b\u0438\u043a\u0430\u0446\u0438\u0438.\n<li class=\"l\"> Construc\u021bia <noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/drop-table\/\">DROP TABLE<\/a><\/noindex> n\u00fc\u00fcd usaldusv\u00e4\u00e4rselt <noindex><a rel=\"nofollow\" href=\"https:\/\/jira.mariadb.org\/browse\/MDEV-11412\">eemaldab<\/a><\/noindex> \u0442\u0430\u0431\u043b\u0438\u0446\u044b, \u043e\u0441\u0442\u0430\u044e\u0449\u0438\u0435\u0441\u044f \u0432 \u0434\u0432\u0438\u0436\u043a\u0435 \u0445\u0440\u0430\u043d\u0435\u043d\u0438\u044f, \u0434\u0430\u0436\u0435 \u043f\u0440\u0438 \u043e\u0442\u0441\u0443\u0442\u0441\u0442\u0432\u0438\u0438 \u0444\u0430\u0439\u043b\u043e\u0432 &#171;.frm&#187; \u0438\u043b\u0438 &#171;.par&#187;.\n<li class=\"l\"> On rakendatud riistvaraliselt kiirendatud versioon funktsioonist crc32() AMD64, ARMv8 ja POWER 8 CPU-de jaoks.\n<li class=\"l\"> M\u00f5ned vaikeparameetrid on muudetud. Parameeter innodb_encryption_threads on t\u00f5stetud 255-ni ja max_sort_length v\u00e4\u00e4rtus on suurendatud 4-lt 8-le.\n<li class=\"l\"> On esitatud mitmeid InnoDB mootorite j\u00f5udluse optimeerimisi.\n<li class=\"l\"> Galera s\u00fcnkroonse multi-master replikeerimise mehhanismi on lisatud t\u00e4ielik tugi  <noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/gtid\/\">GTID<\/a><\/noindex> (Globaalne tehingu ID), mis on k\u00f5igi klastrite s\u00f5lmede jaoks \u00fchised tehingu identifikaatorid.\n<li class=\"l\"> On toimunud \u00fcleminek uuele raamatukogu harule <noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/pcre\/\">PCRE2<\/a><\/noindex> (Perl \u00dchilduvad Regulaaravaldused), selle asemel klassikaline seeria PCRE 8.x.\n<li class=\"l\"> On ette pandud uued sidemed MariaDB ja MySQL andmebaasi \u00fchendamiseks Python ja C programmeerimiskeeltes: <noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/mariadb-connector-python-100-release-notes\/\">MariaDB Connector\/Python 1.0.0<\/a><\/noindex> ja  <noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/mariadb-connector-c-319-release-notes\/\">MariaDB Connector\/C 3.1.9<\/a><\/noindex>. Pythoni side vastab Python DB API 2.0-le, on kirjutatud C keeles ja kasutab serveriga \u00fchendamiseks Connector\/C teeki.\n<\/ul>\n<p><noindex><a rel=\"nofollow\" name=\"link\"><\/a><\/noindex><\/p>\n<p>Allikas: <a \ncontent=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=53225\">opennet.ru<\/a><\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u041f\u043e\u0441\u043b\u0435 \u0433\u043e\u0434\u0430 \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u043a\u0438 \u0438 \u0447\u0435\u0442\u044b\u0440\u0451\u0445 \u043f\u0440\u0435\u0434\u0432\u0430\u0440\u0438\u0442\u0435\u043b\u044c\u043d\u044b\u0445 \u0432\u044b\u043f\u0443\u0441\u043a\u043e\u0432 \u043f\u043e\u0434\u0433\u043e\u0442\u043e\u0432\u043b\u0435\u043d \u043f\u0435\u0440\u0432\u044b\u0439 \u0441\u0442\u0430\u0431\u0438\u043b\u044c\u043d\u044b\u0439 \u0440\u0435\u043b\u0438\u0437 \u043d\u043e\u0432\u043e\u0439 \u0432\u0435\u0442\u043a\u0438 \u0421\u0423\u0411\u0414 MariaDB 10.4, \u0432 \u0440\u0430\u043c\u043a\u0430\u0445 \u043a\u043e\u0442\u043e\u0440\u043e\u0439 \u0440\u0430\u0437\u0432\u0438\u0432\u0430\u0435\u0442\u0441\u044f \u043e\u0442\u0432\u0435\u0442\u0432\u043b\u0435\u043d\u0438\u0435 \u043e\u0442 MySQL, \u0441\u043e\u0445\u0440\u0430\u043d\u044f\u044e\u0449\u0435\u0435 \u043e\u0431\u0440\u0430\u0442\u043d\u0443\u044e \u0441\u043e\u0432\u043c\u0435\u0441\u0442\u0438\u043c\u043e\u0441\u0442\u044c \u0438 \u043e\u0442\u043b\u0438\u0447\u0430\u044e\u0449\u0435\u0435\u0441\u044f \u0438\u043d\u0442\u0435\u0433\u0440\u0430\u0446\u0438\u0435\u0439 \u0434\u043e\u043f\u043e\u043b\u043d\u0438\u0442\u0435\u043b\u044c\u043d\u044b\u0445 \u0434\u0432\u0438\u0436\u043a\u043e\u0432 \u0445\u0440\u0430\u043d\u0435\u043d\u0438\u044f \u0438 \u0440\u0430\u0441\u0448\u0438\u0440\u0435\u043d\u043d\u044b\u0445 \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e\u0441\u0442\u0435\u0439. \u041f\u043e\u0434\u0434\u0435\u0440\u0436\u043a\u0430 \u043d\u043e\u0432\u043e\u0439 \u0432\u0435\u0442\u043a\u0438 \u0431\u0443\u0434\u0435\u0442 \u043e\u0441\u0443\u0449\u0435\u0441\u0442\u0432\u043b\u044f\u0442\u044c\u0441\u044f 5 \u043b\u0435\u0442, \u0434\u043e \u0438\u044e\u043d\u044f 2025 \u0433\u043e\u0434\u0430. \u0420\u0430\u0437\u0432\u0438\u0442\u0438\u0435 MariaDB \u043a\u0443\u0440\u0438\u0440\u0443\u0435\u0442 \u043d\u0435\u0437\u0430\u0432\u0438\u0441\u0438\u043c\u0430\u044f \u043e\u0440\u0433\u0430\u043d\u0438\u0437\u0430\u0446\u0438\u044f MariaDB Foundation \u0432 \u0441\u043e\u043e\u0442\u0432\u0435\u0442\u0441\u0442\u0432\u0438\u0438 [&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-86434","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=\"\u041f\u043e\u0441\u043b\u0435 \u0433\u043e\u0434\u0430 \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u043a\u0438 \u0438 \u0447\u0435\u0442\u044b\u0440\u0451\u0445 \u043f\u0440\u0435\u0434\u0432\u0430\u0440\u0438\u0442\u0435\u043b\u044c\u043d\u044b\u0445 \u0432\u044b\u043f\u0443\u0441\u043a\u043e\u0432 \u043f\u043e\u0434\u0433\u043e\u0442\u043e\u0432\u043b\u0435\u043d \u043f\u0435\u0440\u0432\u044b\u0439 \u0441\u0442\u0430\u0431\u0438\u043b\u044c\u043d\u044b\u0439 \u0440\u0435\u043b\u0438\u0437 \u043d\u043e\u0432\u043e\u0439 \u0432\u0435\u0442\u043a\u0438 \u0421\u0423\u0411\u0414.\" \/>\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\/et\/blog\/news\/stabilnyj-vypusk-subd-mariadb-10-5\" \/>\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 10.5 | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u041f\u043e\u0441\u043b\u0435 \u0433\u043e\u0434\u0430 \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u043a\u0438 \u0438 \u0447\u0435\u0442\u044b\u0440\u0451\u0445 \u043f\u0440\u0435\u0434\u0432\u0430\u0440\u0438\u0442\u0435\u043b\u044c\u043d\u044b\u0445 \u0432\u044b\u043f\u0443\u0441\u043a\u043e\u0432 \u043f\u043e\u0434\u0433\u043e\u0442\u043e\u0432\u043b\u0435\u043d \u043f\u0435\u0440\u0432\u044b\u0439 \u0441\u0442\u0430\u0431\u0438\u043b\u044c\u043d\u044b\u0439 \u0440\u0435\u043b\u0438\u0437 \u043d\u043e\u0432\u043e\u0439 \u0432\u0435\u0442\u043a\u0438 \u0421\u0423\u0411\u0414.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/et\/blog\/news\/stabilnyj-vypusk-subd-mariadb-10-5\" \/>\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=\"2020-06-24T23:42:11+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2020-06-24T23:42:11+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\udd47Stabiilne v\u00e4ljaanne andmebaasist MariaDB 10.5 | ProHoster","description":"P\u00e4rast aastat arendust ja nelja eel\u00fclevaadet on valmis esimene stabiilne v\u00e4ljaanne uue andmebaasi haru jaoks.","canonical_url":"https:\/\/prohoster.info\/et\/blog\/news\/stabilnyj-vypusk-subd-mariadb-10-5","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 10.5 | ProHoster","og:description":"\u041f\u043e\u0441\u043b\u0435 \u0433\u043e\u0434\u0430 \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u043a\u0438 \u0438 \u0447\u0435\u0442\u044b\u0440\u0451\u0445 \u043f\u0440\u0435\u0434\u0432\u0430\u0440\u0438\u0442\u0435\u043b\u044c\u043d\u044b\u0445 \u0432\u044b\u043f\u0443\u0441\u043a\u043e\u0432 \u043f\u043e\u0434\u0433\u043e\u0442\u043e\u0432\u043b\u0435\u043d \u043f\u0435\u0440\u0432\u044b\u0439 \u0441\u0442\u0430\u0431\u0438\u043b\u044c\u043d\u044b\u0439 \u0440\u0435\u043b\u0438\u0437 \u043d\u043e\u0432\u043e\u0439 \u0432\u0435\u0442\u043a\u0438 \u0421\u0423\u0411\u0414.","og:url":"https:\/\/prohoster.info\/et\/blog\/news\/stabilnyj-vypusk-subd-mariadb-10-5","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":"2020-06-24T23:42:11+00:00","article:modified_time":"2020-06-24T23:42:11+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"86434","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":null,"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":null,"breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-02-28 14:15:25","updated":"2022-10-03 01:36:14","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\/86434","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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/comments?post=86434"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts\/86434\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/media?parent=86434"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/categories?post=86434"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/tags?post=86434"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}