MariaDB 10.11 kwụsiri ike

Ntọhapụ izizi nke ngalaba ọhụrụ nke DBMS MariaDB 10.11 (10.11.2) ka ebipụtala, n'ime nke a na-emepụta alaka MySQL nke na-ejigide ndakọrịta azụ ma bụrụ nke dị iche site na ntinye nke igwe nchekwa ọzọ na ike dị elu. MariaDB Foundation nọọrọ onwe ya na-ahụ maka mmepe MariaDB, na-agbaso usoro mmepe mepere emepe nke na-anọghị na ndị na-ere ahịa n'otu n'otu. A na-enye MariaDB ka ọ bụrụ nnọchi MySQL n'ọtụtụ nkesa Linux (RHEL, SUSE, Fedora, openSUSE, Slackware, OpenMandriva, ROSA, Arch Linux, Debian) ma etinyere ya na nnukwu ọrụ dị ka Wikipedia, Google Cloud SQL na Nimbuzz.

N'otu oge ahụ, ngalaba 11.0 nọ na ọkwa ule alfa, nke na-atụpụta nkwalite dị ukwuu na mgbanwe na-emebi ndakọrịta. A na-ekewa ngalaba MariaDB 10.11 dị ka ntọhapụ nkwado ogologo oge ma a ga-akwado ya na MariaDB 11.x ruo February 2028.

Nkwalite isi na MariaDB 10.11:

  • Emejuputala ọrụ "GRANT ... TO PUBLIC", nke ị nwere ike inye ụfọdụ ndị ọrụ niile na sava ozugbo.
  • Ekewala ikike SUPER na “READ ONLY ADMIN” - ohere “SUPER” ugbu a anaghị ekpuchi ikike “READ ONLY ADMIN” (ikike ide, ọ bụrụgodị na edobere usoro ọgụgụ naanị).
  • Ụdị nleba anya "ANALYZE FORMAT=JSON" na-enye ihe nleba anya oge nke njikarịcha ajụjụ nọrọ.
  • Edere nsogbu arụmọrụ ndị mere mgbe ị na-agụ site na tebụl nwere parampat atụmatụ nchekwa, yana mgbe ị na-enyocha tebụl nke ọma yana paramita na usoro maka atụmatụ nchekwa.
  • Utlọ ọrụ mariadb-dump agbakwunyela nkwado maka ịchekwa na iweghachi data akụkọ ihe mere eme site na tebụl mbipute.
  • Agbakwunyere ntọala system_versioning_insert_history iji jikwaa ikike ịme mgbanwe na ụdị data gara aga na tebụl mbipute.
  • Ekwenyere ka ịgbanwee innodb_write_io_threads na innodb_read_io_threads ntọala na ofufe na-enweghị ịmalitegharị ihe nkesa ahụ.
  • N'elu ikpo okwu Windows, ndị nchịkwa Windows nwere ike ịbanye dị ka mgbọrọgwụ na MariaDB na-abanyeghị paswọọdụ.
  • Aha mgbanwe log_slow_min_examined_row_limit (min_examined_row_limit), log_slow_query (slow_query_log), log_slow_query_file (slow_query_log_file) na log_slow_query_time (ogologo_query_time) ka ahagharịrị aha.

isi: opennet.ru

Tinye a comment