MariaDB 11 yakatoburitswa uye idzi ndidzo nhau dzayo

Makore gumi mushure mekuvambwa kwebazi re10.x, pakupedzisira shanduro itsva uye bazi reMariaDB 11.0.0 rakabudiswaque inounza akati wandei akakosha ekuvandudza uye inoputsa kuenderana shanduko.

MariaDB 11 yakatoburitswa uye idzi ndidzo nhau dzayo uye ichave yakagadzirira kushandiswa kwekugadzira mushure mekudzikamiswa. Bazi rinotevera rakakosha reMariaDB 12, rine shanduko dzinoenderana nekutyora, rinotarisirwa kunge risati rapfuura makore gumi (muna 10).

Kune avo vasingazive nezve MariaDB chirongwa, iwe unofanirwa kuziva izvozvo inogadzira forogo yeMySQL inochengetedza kuenderana kumashures pese pazvinogoneka uye inosiyaniswa nekubatanidzwa kweakawedzerwa ekuchengetedza enjini uye epamberi maficha.

Kuvandudzwa kweMariaDB inotariswa neyakazvimirira MariaDB hwaro, zvichitevera chirongwa chakavhurika uye chakajeka chekusimudzira chakazvimirira pane vatengesi vega. MariaDB ngarava panzvimbo yeMySQL pane dzakawanda Linux kugovera.

Main nyowani maficha eMariaDB 11

Mukuburitswa kutsva uku kweMariaDB 11 imwe yekuvandudza kwakakosha mubazi ndeye query optimizer dudziro kune imwe itsva uremu modhi (mutengo wemuenzaniso), iyo inopa kufanotaura kwakanyatso kujeka kwezviyero zvemubvunzo wega wega wekuita chirongwa. Kunyange iyo modhi nyowani ichibvisa mamwe mabhodhoro ekuita, inogona kunge isiri iyo yakakwana mune ese mamiriro uye mimwe mibvunzo inogona kudzikira, saka vashandisi vanokurudzirwa kutora chikamu mukuyedza uye kuzivisa vanogadzira kana paine nyaya.

Iyo modhi iri pamusoro yakashanda zvakanaka kuwana iyo yakanyanya kunaka index, asi yaive nenyaya nekushanda kwematafura scans, index scans, kana range lookups. Mumuenzaniso mutsva, kukanganisa uku kunobviswa nekushandura huremu hwekushanda nejini yekuchengetedza.

maitiro ekuongorora kune disk-yakanyanya mashandiro akadai sequential kunyora scans, ikozvino vanofungidzira kuti data yakachengetwa paSSD ine kuverenga kwe400 MB pasekondi. Pamusoro pezvo, mamwe maparamendi ehuremu eoptimizer akakwenenzverwa, izvo, semuenzaniso, zvakaita kuti zvikwanise kuita mukana wekushandisa ma indexes e "ORDER BY/GROUP BY" mashandiro muma subqueries uye kukurumidzira basa nematafura madiki.

Chimwe chitsva chinomira pachena ndechekuti iyo nyowani yekuremedza modhi inobvumira kusarudza yakanyanya kunaka yemubvunzo hurongwa mune anotevera mamiriro:

• Paunenge uchishandisa mibvunzo inodarika matafura maviri.
• Kana paine ma indices ane nhamba huru yemakoshero akafanana.
• Paunenge uchishandisa mitsara inovhara kupfuura 10% yetafura.
• Paunenge uine mibvunzo yakaoma uko asiri ese makoramu anoshandiswa akaiswa indexed.
• Paunenge uchishandisa mibvunzo inosanganisira akasiyana mainjini ekuchengetera (semuenzaniso, kana mubvunzo uine kuwana matafura muInnoDB uye Memory injini).
• Nekushandisa FORCE INDEX kuvandudza chirongwa chemubvunzo.
• Kana chirongwa chemubvunzo chadzikiswa panyaya yekushandisa "ANALYZE TABLE".
• Kana muvhunzo uchitambanudzira nhamba huru yemaonero (nhamba huru yeSelects nested).
• Paunenge uchishandisa ORDER BY kana GROUP BY clauses dzinoenderana ne indexes.

Kune chikamu che kugarisana break Muiyi vhezheni itsva yeMariaDB 11, mabreak anotevera atichawana mubazi idzva iri anotaurwa:

• Kodzero dzeSUPER hadzichakubvumidzi kuita zviito izvo zvinopihwa zvakapatsanurwa maropafadzo aripo. Semuenzaniso, kushandura fomati yemabhinari matanda kunoda BINLOG ADMINISTRATOR kodzero.
• Yakabvisa shanduko yebuffer kuita muInnoDB.
• Yakarambwa innodb_flush_method uye innodb_file_per_table.
• Tsigiro yemazita emysql* yakabviswa.
• Yakarambwa kuseta explicit_defaults_for_timestamp kusvika 0.
• Symbolic links dzakaendeswa kune imwe pasuru yekuenderana neMySQL.
• Kukosha kweiyo innodb_undo_tablespaces parameter yakashandurwa kubva payakagadzika kuenda ku3.

Finalmente kana iwe uchifarira kuziva zvakawanda nezvazvo nezve kuburitswa kutsva uku, unogona kutarisa ruzivo mu inotevera chinongedzo.