Makore gumi mushure mekuvambwa kwebazi re10.x, MariaDB 10 yakaburitswa, iyo yakapa kuvandudzwa kwakakosha uye shanduko dzakatyora kugarisana. Bazi parizvino riri mumhando yekuburitsa alpha uye richange rakagadzirira kushandiswa kwekugadzira mushure mekudzikamiswa. Bazi guru rinotevera reMariaDB 11.0.0, rine shanduko dzinoita kuenderana, rinotarisirwa kwete pamberi pemakore gumi kubva zvino (muna 12).
Iyo MariaDB purojekiti iri kugadzira forogo kubva kuMySQL, ichichengetedza kuenderana kumashure pese pazvinogoneka 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. Iyo MariaDB DBMS inopihwa pachinzvimbo cheMySQL mune dzakawanda Linux kugoverwa (RHEL, SUSE, Fedora, openSUSE, Slackware, OpenMandriva, ROSA, Arch Linux, Debian) uye yakaitwa mumapurojekiti makuru akadai seWikipedia, Google Cloud SQL uye Nimbuzz.
Kuvandudzwa kwakakosha mubazi reMariaDB 11 ishanduko yemubvunzo wekusimudzira kune huremu huremu modhi (mubhadharo modhi), iyo inopa kufanotaura kwakaringana kwehuremu hwechirongwa chemubvunzo wega wega. Kunyange iyo modhi nyowani ichigona kudzoreredza mamwe mabhodhoro ekuita, inogona kunge isiri yakakwana mune ese mamiriro uye inogona kunonoka mimwe mibvunzo, saka vashandisi vanokurudzirwa kutora chikamu mukuyedza uye kuzivisa vanogadzira kana matambudziko amuka.
Iyo yapfuura modhi yaive yakanaka pakutsvaga iyo yakakwana indekisi, asi yaive nematambudziko nekushanda kwematafura scans, index scans, kana rengedzo yekutora mashandiro. Mumuenzaniso mutsva, iyi drawback inobviswa nekushandura huremu hwekushanda nejini yekuchengetedza. Kana tichiongorora mashandiro edhisiki-inotsamira mashandiro, senge sequential kunyora scans, isu zvino tafunga kuti iyo data inochengetwa paSSD inopa kuverenga kumhanya kwe400MB pasekondi. Pamusoro pezvo, mamwe maparamendi ehuremu eiyo optimizer akagadziridzwa, ayo, semuenzaniso, akaita kuti zvikwanise kushandisa kugona kushandisa indexes ye "ORDER BY/GROUP BY" mashandiro mune subqueries uye nekumhanyisa basa nematafura madiki.
Zvinocherechedzwa kuti huremu hutsva modhi ichakubvumidza iwe kuti usarudze yakanyatso kurongeka yemubvunzo hurongwa mune anotevera mamiriro:
- Paunenge uchishandisa mibvunzo inodarika matafura maviri.
- Paunenge uine indexes ine nhamba huru yezvakafanana zvakakosha.
- Paunenge uchishandisa mitsara inovhara kupfuura 10% yetafura.
- Kana uine mibvunzo yakaoma iyo isiri makoramu ese anoshandiswa akaiswa indexed.
- Kana mibvunzo ichishandiswa inosanganisira injini dzekuchengetera dzakasiyana (semuenzaniso, kana mubvunzo mumwe ukawana matafura muInnoDB uye Memory injini).
- Paunenge uchishandisa FORCE INDEX kuvandudza chirongwa chemubvunzo.
- Kana chirongwa chemubvunzo chinodzikira kana uchishandisa "ANALYZE TABLE".
- Kana iyo query ichitambanudzira nhamba huru yematafura akatorwa (nhamba hombe yeSelects nested).
- Paunenge uchishandisa ORDER BY kana GROUP BY mazwi anowira pasi pe indexes.
Makuru ekuenderana nyaya muMariaDB 11 bazi:
- Kodzero dzeSUPER hadzichakubvumidzi kuita zviito izvo zvinopihwa zvakapatsanurwa maropafadzo aripo. Semuenzaniso, kuti uchinje fomati yemabhinari matanda, iwe unozoda BINLOG ADMIN kodzero.
- Yakabvisa shanduko yebuffer kuita muInnoDB.
- Innodb_flush_method uye innodb_file_per_table zvakarambwa.
- Mysql* zita rutsigiro rwakadzimwa.
- Kuseta explicit_defaults_for_timestamp ku0 kwaraswa.
- Symbolic links inosanganisirwa mune yakaparadzana pasuru yekuenderana neMySQL.
- Iko kukosha kweiyo innodb_undo_tablespaces parameter yakashandurwa kuita 3.
Source: opennet.ru