An riga an saki MariaDB 11 kuma waɗannan sune labaran sa

Shekaru 10 bayan kafa reshen 10.x. a ƙarshe an fitar da sabon sigar da reshe na MariaDB 11.0.0, cewa yana kawo gyare-gyare masu mahimmanci da yawa kuma yana karya canje-canjen dacewa.

MariaDB 11 an riga an sake shi kuma waɗannan labarai ne kuma zai kasance a shirye don amfani da samarwa bayan daidaitawa. Babban reshe na gaba na MariaDB 12, wanda ya ƙunshi canje-canjen da ke karya daidaituwa, ana tsammanin zai kasance ba da jimawa ba fiye da shekaru 10 (a cikin 2032).

Ga waɗanda ba su san aikin MariaDB ba, ya kamata ku san hakan yana haɓaka cokali mai yatsa na MySQL wanda ke kula da dacewa da bayas a duk inda zai yiwu kuma an bambanta ta hanyar haɗin ƙarin injunan ajiya da abubuwan ci gaba.

Ci gaban MariaDB Gidauniyar MariaDB mai zaman kanta ce ke kulawa, bin buɗaɗɗen tsari na ci gaba mai zaman kansa na kowane dillalai. MariaDB yana jigilar kayayyaki maimakon MySQL akan yawancin rarrabawar Linux.

Babban sabon fasalin MariaDB 11

A cikin wannan sabon saki na MariaDB 11 ɗayan manyan ci gaba a cikin reshe shine fassarar mai inganta tambaya zuwa sabon samfurin nauyi (samfurin farashi), wanda yana ba da ingantaccen hasashen ma'aunin kowane shirin aiwatar da tambaya. Duk da yake sabon samfurin yana cire wasu ƙullun aikin, maiyuwa bazai zama mafi kyau ba a duk yanayin yanayi kuma wasu tambayoyin na iya raguwa, don haka ana ƙarfafa masu amfani su shiga gwaji da sanar da masu haɓakawa idan akwai matsala.

Samfurin da ke sama yayi aiki da kyau don nemo mafi kyawun fihirisar, amma yana da matsala tare da aiwatar da sikanin tebur, sikanin fihirisa, ko duban kewayo. A cikin sabon samfurin, an kawar da wannan rashin amfani ta hanyar canza ma'aunin nauyin aiki tare da injin ajiya.

kimanta aikin don aikace-aikacen faifan diski kamar jerin sikanin rubutu, yanzu sun ɗauka cewa ana adana bayanan akan SSD mai ƙarfin karantawa na 400 MB dakika daya. Bugu da ƙari, an tsaftace wasu sigogi masu nauyi na mai ingantawa, wanda, alal misali, ya ba da damar aiwatar da yuwuwar yin amfani da fihirisa don ayyukan "ORDER BY/GROUP BY" a cikin ƙananan hukumomi da kuma hanzarta aiki tare da ƙananan tebur.

Wani sabon abu da ya fito fili shi ne cewa sabon samfurin ma'aunin nauyi zai ba da damar zabar mafi kyawun tsarin aiwatar da tambaya a cikin yanayi masu zuwa:

• Lokacin amfani da tambayoyin da suka wuce teburi 2.
• Lokacin da fihirisa ke ɗauke da adadi masu yawa iri ɗaya.
• Lokacin amfani da jeri wanda ke rufe fiye da 10% na tebur.
• Lokacin da kuke da hadaddun tambayoyin inda ba duk ginshiƙan da aka yi amfani da su ba ne.
• Lokacin amfani da tambayoyin da suka ƙunshi injunan ajiya daban-daban (misali, lokacin da tambaya ta ƙunshi damar shiga tebur a cikin InnoDB da injunan Ƙwaƙwalwar ajiya).
• Ta amfani da FORCE INDEX don inganta shirin tambaya.
• Lokacin da aka rage girman shirin tambaya a yanayin amfani da "ANALYZE TABLE".
• Lokacin da tambayar ta zarce ɗimbin ra'ayoyi (yawan adadin Zaɓuɓɓukan gida).
• Lokacin amfani da ORDER BY ko GROUP BY sassan da suka dace da fihirisa.

A bangaren karya daidaituwa A cikin wannan sabon sigar na MariaDB 11, an ambaci hutu masu zuwa da za mu samu a wannan sabon reshe:

• Haƙƙin SUPER baya ƙyale ka ka aiwatar da ayyuka waɗanda ke akwai gata daban daban. Misali, canza tsarin rajistan ayyukan binary zai buƙaci haƙƙin BINLOG ADMINISTRATOR.
• An cire aiwatar da buffer canji a cikin InnoDB.
• Hanyar innodb_flush_da aka soke da innodb_file_per_table.
• An soke tallafin sunayen mysql*.
• Saitin da aka soke a bayyane_defaults_for_timestamp zuwa 0.
• An matsar da hanyoyin haɗin kai zuwa wani fakitin daban don dacewa da MySQL.
• An canza darajar sigar innodb_undo_tablespaces daga tsoho zuwa 3.

Finalmente idan kuna sha'awar ƙarin sani game da shi game da wannan sabon sakin, zaku iya duba cikakkun bayanai a cikin bin hanyar haɗi.