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 hlahisa fereko ea MySQL, e bolokang ho lumellana ha morao moo ho khonehang 'me e na le kopanyo ea lienjine tse ling tsa polokelo le likarolo tse tsoetseng pele. Nts'etsopele ea MariaDB e hlokometsoe ke Mokhatlo o ikemetseng oa MariaDB, o latelang ts'ebetso ea nts'etsopele e bulehileng le e bonaletsang e sa itšetlehang ka barekisi ka bomong. MariaDB e romelloa e le sebaka sa MySQL kabong tse ngata. Linux (RHEL, SUSE, Fedora, openSUSE, Slackware, OpenMandriva, ROSA, Arch Linux, Debian) mme e se e kentswe tshebetsong mererong e meholo jwalo 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
