Lilemo tse 10 ka mor'a ho thehoa ha lekala la 10.x, MariaDB 11.0.0 e ile ea lokolloa, e ileng ea fana ka lintlafatso tse 'maloa tsa bohlokoa le liphetoho tse ileng tsa senya ho lumellana. Lekala hajoale le boemong ba tokollo ea alpha mme le tla be le loketse ts'ebeliso ea tlhahiso kamora ho tsitsisa. Lekala le latelang le leholo la MariaDB 12, le nang le liphetoho tse amanang le khefu, le lebeletsoe pele ho lilemo tse 10 ho tloha joale (ka 2032).
Morero oa MariaDB o ntse o nts'etsapele fereko ho tsoa ho MySQL, ho boloka ho lumellana ha morao neng kapa neng ha ho khonahala mme o kenyelletsa ho kopanngoa ha lienjineri tse ling tsa polokelo le bokhoni bo tsoetseng pele. Nts'etsopele ea MariaDB e tsamaisoa ke Mokhatlo o ikemetseng oa MariaDB, ho latela ts'ebetso e bulehileng le e hlakileng ea nts'etsopele e ikemetseng ho barekisi ka bomong. MariaDB DBMS e fanoe sebakeng sa MySQL ho li-distributions tse ngata tsa Linux (RHEL, SUSE, Fedora, openSUSE, Slackware, OpenMandriva, ROSA, Arch Linux, Debian) 'me e kentsoe tšebetsong mererong e meholo joalo ka Wikipedia, Google Cloud SQL le Nimbuzz.
Ntlafatso e ka sehloohong lekaleng la MariaDB 11 ke phetoho ea optimizer ea lipotso ho ea ho mofuta o mocha oa boima (mohlala oa litšenyehelo), o fanang ka polelo e nepahetseng haholoanyane ea boima ba moralo o mong le o mong oa potso. Le hoja mohlala o mocha o ka fokotsa mathata a mang a ts'ebetso, e ka 'na ea se ke ea e-ba e nepahetseng maemong ohle' me e ka fokotsa lipotso tse ling, kahoo basebelisi ba khothalletsoa ho kenya letsoho litekong le ho tsebisa baetsi ba lihlahisoa haeba mathata a hlaha.
Moetso o fetileng o ne o le motle ho fumaneng index ea boleng bo holimo, empa o bile le mathata ka ts'ebeliso ea lisebelisoa tsa litafole, li-index, kapa ts'ebetso ea ho lata marang-rang. Moetsong o mocha, drawback ena e felisoa ka ho fetola boima ba ts'ebetso ka mochini oa polokelo. Ha re lekola ts'ebetso bakeng sa ts'ebetso e itšetlehileng ka lebelo la disk, joalo ka litlhahlobo tse latellanang tsa ho ngola, joale re nka hore data e bolokiloe ho SSD e fanang ka lebelo la ho bala la 400MB motsotsoana. Ho feta moo, litekanyo tse ling tsa boima ba optimizer li ile tsa hlophisoa, tseo, ka mohlala, li ileng tsa etsa hore ho khonehe ho sebelisa bokhoni ba ho sebelisa li-index bakeng sa ts'ebetso ea "ORDER BY/GROUP BY" ho li-subqueries le ho potlakisa mosebetsi ka litafole tse nyane haholo.
Hoa hlokomeleha hore mofuta o mocha oa boima o tla u lumella ho khetha moralo o nepahetseng haholoanyane oa ho etsa lipotso maemong a latelang:
- Ha u sebelisa lipotso tse fetang litafole tse peli.
- Ha o na le li-index tse nang le palo e kholo ea boleng bo ts'oanang.
- Ha u sebelisa mekhahlelo e koahelang ho feta 10% ea tafole.
- Ha u e-na le lipotso tse thata tseo ho tsona ho sa sebelisoeng likholomo kaofela.
- Ha ho sebelisoa lipotso tse amanang le lienjineri tse fapaneng tsa polokelo (mohlala, ha potso e le 'ngoe e fihlella litafole ho lienjine tsa InnoDB le Memory).
- Ha o sebelisa FORCE INDEX ho ntlafatsa moralo oa lipotso.
- Ha moralo oa lipotso o senyeha ha o sebelisa "ANALYZE TABLE".
- Ha potso e pharalla palo e kholo ea litafole tse nkiloeng (palo e kholo ea LIKHETHO tse khethiloeng).
- Ha u sebelisa ORDER BY kapa GROUP BY lipolelo tse oelang tlas'a li-index.
Litaba tse kholo tsa khokahano lekaleng la MariaDB 11:
- Litokelo tsa SUPER ha li sa u lumella ho etsa liketso tse nang le litokelo tse behiloeng ka thoko. Mohlala, ho fetola sebopeho sa li-logo tsa binary, o tla hloka litokelo tsa BINLOG ADMIN.
- E tlositse ts'ebetsong ea buffer ea phetoho ho InnoDB.
- Innodb_flush_method le innodb_file_per_table li tlositsoe.
- Tšehetso ea lebitso la Mysql* e tlositsoe.
- Ho beha explicit_defaults_for_timestamp ho 0 ho tlositsoe.
- Lihokelo tsa matšoao li kenyellelitsoe ka har'a sephutheloana se arohaneng bakeng sa ho lumellana le MySQL.
- Boleng ba kamehla ba parameter ea innodb_undo_tablespaces bo fetotsoe ho 3.
Source: opennet.ru