MariaDB 12.2.2 yaburitswa, ichiiratidza seyokutanga kuburitswa kwakasimba kwebazi re12.2. MariaDB 12.2, yakasarudzwa serongedzo yekuburitswa, inoenderera mberi nekuvandudzwa zvishoma nezvishoma kwekushanda kwayo uye inotsiva MariaDB 12.1. MariaDB 12.3.1, iyo inotarisirwa kuburitswa kwebazi reLTS riri kuuya, yakaburitswa panguva imwe chete, iine kuisirwa kwebinlog itsva. MariaDB 12.2 ichachengetwa kusvika kuburitswa kwe12.3.2.
Iyo MariaDB purojekiti iri kugadzira forogo kubva kuMySQL inochengetedza kuenderana kumashure uye inoratidzira kubatanidzwa kwemamwe mainjini ekuchengetedza uye kugona kwepamberi. Kubudirira kweMariaDB kunotariswa neiyo yakazvimirira yeMariaDB Foundation, ichitevera yakavhurika uye iri pachena nzira yekuvandudza iyo yakazvimirira kune yega vatengesi. MariaDB inopihwa sechinzvimbo cheMySQL mune dzakawanda Linux kugoverwa (RHEL, SUSE, Fedora, openSUSE, Slackware, OpenMandriva, ROSA, Arch Linux, Debian) uye yakaitwa mumapurojekiti makuru seWikipedia, Google Cloud SQL uye Nimbuzz.
Shanduko mubazi reMariaDB 12.2 dzinosanganisira:
- MuOracle DBMS compatibility mode, mabasa eTO_NUMBER (kushandura tambo kuita nhamba) uye TRUNC (kupfupisa zuva, semuenzaniso, kuita awa, zuva, mwedzi, kana gore) anoiswa.
- Pakuita mabasa ekubatanidza tafura (JOIN), kugadziriswa kwakaitwa kunofunga nezvekusiyana kwemitsara mumibvunzo ine chirevo che "GROUP BY" kuti pave nekufanotaura kwakarurama kwehuwandu hwemitsara inobuda (out_rows) uye kushandiswa kwakakodzera kweindekisi.
- Sarudzo itsva dzekugadzirisa optimizer dzawedzerwa: ROWID_FILTER/NO_ROWID_FILTER uye INDEX_MERGE/NO_INDEX_MERGE, pamwe nekukwanisa kudoma mazita emabhuroko mumibvunzo (sarudzo dzekugadzirisa dzinogona kushandiswa zvakasarudzika kuzvikamu zvemibvunzo nekuzvitarisa nemazita ekuti "select#N", apo N iri nhamba yemabhuroko). Semuenzaniso: "select /+ JOIN_ORDER(@"select#2" makumi maviri,gumi) */ …."
- Zvirambidzo padanho rekuvaka ma nesting mumabasa ekushanda neJSON zvabviswa (muganho weJSON_DEPTH_LIMIT, waimbova ne value ye32, wabviswa).
- Yakawedzera tafura yeTRIGGERED_UPDATE_COLUMNS ku INFORMATION_SCHEMA schema (INFORMATION_SCHEMA.TRIGGERED_UPDATE_COLUMNS) kuratidza makoramu anochinjwa kana trigger yatanga.
- Tafura yePARAMETERS iri mu INFORMATION_SCHEMA schema inoshandisa koramu yePARAMETER_DEFAULT ine ma default values e stored procedure parameters.
- Rutsigiro rwekuyedza rwechirevo che "CREATE GLOBAL TEMPORARY TABLE" chekugadzira matafura epasi rose enguva pfupi rwaitwa. Matafura aya enguva pfupi anodonhedzwa mushure mekunge chikamu chapera uye anoonekwa nevashandisi vese, asi ane data rakanangana nemushandisi wega wega.
- Rutsigiro rwakavandudzwa rwekukopana pakati pematafura ane maumbirwo akasiyana rwunopihwa mukuyedza mode.
Source: opennet.ru
