ProHoster > Блог > ozi ịntanetị > MariaDB 10.6 kwụsiri ike

MariaDB 10.6 kwụsiri ike

Mgbe otu afọ nke mmepe na mwepụta mmalite atọ gasịrị, ebipụtara ntọhapụ mbụ nke ngalaba ọhụrụ nke MariaDB 10.6 DBMS, n'ime nke a na-emepụta alaka MySQL nke na-ejigide ndakọrịta azụ azụ ma bụrụ nke dị iche site na ntinye nke igwe nchekwa ọzọ. na ikike dị elu. A ga-enye nkwado maka alaka ọhụrụ ahụ ruo afọ 5, ruo July 2026.

MariaDB Foundation nọọrọ onwe ya na-ahụ maka mmepe MariaDB, na-agbaso usoro mmepe mepere emepe na nke doro anya 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.

Nkwalite isi na MariaDB 10.6:

  • A na-eme n'aka na mmezu nke atomic nke okwu ndị a bụ "CREATE TABLE| VIEW| SEQUENCE|TRIGER", "ALTER TABLE|SEQUENCE", "RENAME TABLE|TABLES", " DROP TABLE | Nlele | Nlele | TRIGGER | DATABASE " (ma ọ bụ na okwu ahụ bụ. Emechara kpamkpam ma ọ bụ na-eweghachi ihe niile n'ọnọdụ mbụ ya). N'ihe banyere ọrụ "DROP TABLE" na-ehichapụ ọtụtụ tebụl n'otu oge, a na-ahụta atomity na ọkwa nke tebụl ọ bụla. Ebumnuche nke mgbanwe a bụ iji hụ na iguzosi ike n'ezi ihe na ihe nkesa nkesa n'oge ọrụ. Na mbụ, mgbe mkpọka gasịrị, tebụl na-adịru nwa oge na faịlụ nwere ike ịdịgide, mmekọrịta nke tebụl na engines nchekwa na faịlụ frm nwere ike imebi, na tebụl nke ọ bụla nwere ike ịnọgide na-edegharị aha mgbe ọtụtụ tebụl na-edegharị aha ozugbo. A na-ahụta iguzosi ike n'ezi ihe site na idowe ndekọ mgbake steeti, ụzọ nke enwere ike ikpebi site na nhọrọ ọhụrụ "-log-ddl-recovery=file" (ddl-recovery.log na ndabara).
  • Emejuputala ihe owuwu "Họrọ ... OFFSET ... FETCH" akọwapụtara na ọkọlọtọ SQL 2008, na-enye gị ohere igosipụta ọnụọgụ ụfọdụ nke ahịrị na-amalite site na nkwụsị nke akọwapụtara, yana ikike iji paramita "WITH TIES". tinye uru ọzọ na-esote. Dịka ọmụmaatụ, okwu a bụ "Họrọ i FROM t1 ORDER BY i ASC OFFSET 1 ROWS FETCH FIRST 3 ROWS WITH TIES" dị iche na ihe owuwu "Họrọ i FROM t1 ORDER BY i ASC LIMIT 3 OFFSET 1" site n'iwepụta otu ihe ọzọ na ọdụ. (kama ahịrị 3 ga-apụta).
  • Maka injin InnoDB, emejuputala syntax "SELECT ... SKIP LOCKED", nke na-enye gị ohere iwepụ ahịrị nke enweghị ike ịtọ mkpọchi maka ("LOCK IN SHARE MODE" ma ọ bụ "KA emelitere").
  • Emejuputala ikike ileghara indexes anya (na MySQL 8, a na-akpọ ọrụ a "ntụgharị uche na-adịghị ahụ anya"). A na-eme akara ndeksi ka ileghara anya site na iji ọkọlọtọ IGNORED na nkwupụta ALTER TABLE, emesia ndeksi ahụ ka na-ahụ anya ma na-emelite ya, mana ọ naghị eji ngwa ngwa.
  • Agbakwunyere ọrụ JSON_TABLE() iji tọghata data JSON ka ọ bụrụ ụdị mmekọrịta. Dịka ọmụmaatụ, enwere ike ịgbanwe akwụkwọ JSON maka iji ya mee ihe na gburugburu tebụl, nke enwere ike ịkọwapụta n'ime ngọngọ FROM na nkwupụta SELECT.
  • Ndakọrịta emelitere na Oracle DBMS: agbakwunyere nkwado maka subjury na-amaghị aha n'ime FROM ngọngọ. Emejuputala ihe owuwu MINUS (nke dabara na EXCEPT). Agbakwunyere ADD_MONTHS(), TO_CHAR(), SYS_GUID() na ROWNUM() ọrụ.
  • N'ime injin InnoDB, etinyela n'ime tebụl tọgbọ chakoo ngwa ngwa. Ụdị eriri COMPRESSED ka edobere ka ọ bụrụ naanị usoro ọgụgụ na ndabara. Atụmatụ SYS_TABLESPACES nọchiri SYS_DATAFILES wee gosipụta steeti ozugbo na sistemụ faịlụ. A na-enye nkwado ide umengwụ maka ohere tebụl nwa oge. Nkwado maka algọridim checksum ochie, nke edobere maka ndakọrịta na MariaDB 5.5, akwụsịla.
  • N'ime usoro mmegharị ahụ, abawanyela nha nke uru paramita master_host site na mkpụrụedemede 60 ruo 255, yana master_user gaa na 128. Agbakwunyere mgbanwe binlog_expire_logs_seconds iji hazie oge ngafe nke ndekọ ọnụọgụ abụọ na sekọnd (na mbụ, oge nrụpụta ahụ bụ. Achọpụtara naanị n'ime ụbọchị site na mgbanwe expire_logs_days).
  • Usoro mmegharị ọtụtụ nna ukwu Galera na-emejuputa wsrep_mode mgbanwe iji hazie paramita API WSREP (Write Set RePlication). Ntugharị Galera anabatara site na nkwukọrịta ezoro ezo gaa na TLS na-akwụsịghị ụyọkọ ahụ.
  • Emejuputala atụmatụ sys-schema, nke nwere nchịkọta echiche, ọrụ na usoro maka nyocha ọrụ nchekwa data.
  • Tebụl ọrụ agbakwunyere maka nyocha arụmọrụ mmegharị.
  • Agbakwunyela echiche INFORMATION_SCHEMA.KEYWORDS na INFORMATION_SCHEMA.SQL_FUNCTIONS na tebụl ozi, na-egosipụta ndepụta okwu na ọrụ dịnụ.
  • Ewepụla ebe nchekwa TokuDB na CassandraSE.
  • Ebugharịla utf8 encoding site na ihe nnochite anya utf8mb4 nke anọ (U+0000..U+10FFFF) gaa na utf8mb3-byte atọ (na-ekpuchi oke Unicode U+0000..U+FFFF).
  • Nkwado agbakwunyere maka ịgbalite oghere na sistemu.
  • Ngwa mgbakwunye GSSAPI agbakwunyela nkwado maka aha otu ndekọ aha na SID.
  • agbakwunyere nlele maka ọnụnọ nhazi faịlụ $MARIADB_HOME/my.cnf na mgbakwunye na $MYSQL_HOME/my.cnf.
  • Emejuputala mgbanwe sistemụ ọhụrụ binlog_expire_logs_seconds, innodb_deadlock_report, innodb_read_only_compressed, wsrep_mode na Innodb_buffer_pool_pages_lru_freed.

isi: opennet.ru

Tinye a comment