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.
Chirongwa cheMariaDB chinogadzira forogo yeMySQL inochengetedza kufambirana kwedata uye ine kubatanidzwa kwemamwe mainjini ekuchengetera zvinhu uye maficha epamusoro. Kugadzira MariaDB kunotungamirwa neMariaDB Foundation yakazvimiririra, ichitevera maitiro ekugadzira akavhurika uye akajeka asina vatengesi vega vega. MariaDB inotumirwa senzvimbo yeMySQL muzvikamu zvakawanda. Linux (RHEL, SUSE, Fedora, openSUSE, Slackware, OpenMandriva, ROSA, Arch Linux, Debian) uye yakaitwa mumapurojekiti makuru akadai seWikipedia, Google Cloud SQL neNimbuzz.
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
