ProHoster > Блог > ozi ịntanetị > MariaDB 12.0 dị ugbu a

MariaDB 12.0 dị ugbu a

A tọhapụrụ MariaDB 12.0.2, na-akanye ya dị ka ntọhapụ izizi nke alaka 12.0. Alaka MariaDB 12.0 bụ nkewa dị ka ntọhapụ na-atụgharị, na-aga n'ihu mmepe nke ọrụ nke nta nke nta, ma dochie alaka MariaDB 11.8. MariaDB 12.1.1, nke nwere ọkwa nke onye ntọhapụ, ka ebipụtara n'otu oge ahụ. A ga-akwado alaka MariaDB 12.0 ruo mgbe ewepụtara ntọhapụ 12.1.2.

Ọrụ MariaDB na-emepụta ndụdụ sitere na MySQL nke na-ejigide ndakọrịta azụ azụ ma gosipụta ntinye nke igwe nchekwa ndị ọ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.

Mgbanwe na ngalaba MariaDB 12.0 gụnyere:

  • Agbakwunyere nkwado maka igodo SSL echekwara na paswọọdụ. Paswọọdụ iji mepee Asambodo SSL enwere ike ịtọlite ​​ya site na mgbanwe ssl_passphrase ma ọ bụ aka mgbe ị na-amalite sava ahụ.
  • Agbakwunyere okwu a "SET SESSION AUTHORIZATION" ime ihe omume n'okpuru onye ọrụ dị iche mgbe ị na-edozi ihe ùgwù kwesịrị ekwesị (enwere ike iwere okwu ahụ dị ka ihe analog nke "sudo" maka DBMS).
  • agbakwunyere nkwado maka SHA-2 hashes na file_key_management.so ngwa mgbakwunye.
  • Nkwado agbakwunyere maka mgbanwe cursor adịghị ike nke ụdị SYS_REFCURSOR akọwapụtagoro, na-enye ohere iweghachi cursor site na usoro echekwara (na paramita OUT) ma ọ bụ site na ọrụ (na nkwupụta nlọghachi). agbakwunyere mgbanwe sistemụ "max_open_cursors" iji kpachie ọnụọgụ kachasị nke cursors mepere emepe n'otu oge.
  • Ụdị TO_CHAR na-akwado usoro FM (Fill Mode) ugbu a iji zere ndochi ọzọ. Dịka ọmụmaatụ, ajụjụ a "Họrọ CONCAT('/', TO_CHAR('2020-01-06 10:11:12','FMDAY'),'/');" ga-alaghachi "/Monday/" kama "/Monday /".
  • Emelitela ngwa mariadb-check na okwu CHECK TABLE iji kwado tebụl site na injin SEQUENCE.
  • Optimizer ugbu a na-akwado nhọrọ (ntụgharị uche) na-emetụta nrụpụta atụmatụ njikarịcha: QB_NAME, NO_RANGE_OPTIMIZATION, NO_ICP, MRR, NO_MRR, BKA, NO_BKA, BNL, NO_BNL, SEMIJOIN, SUBQUERY, JOIN_FIXED_INPREFIN, JOIN_FIXED_ORDER, JOIN. JOIN_SUFFIX na MAX_EXECUTION_TIME. A na-edochi nhọrọ ndị ahụ n'ime ajụjụ ahụ n'ụdị dakọtara na MySQL, dịka ọmụmaatụ: Họrọ /*+ BKA(t1) NO_BKA(t2) */ * SITE t1 INNER JOIN t2 WHERE…; Họrọ /*+ MAX_EXECUTION_TIME(1000) */ * SITE t1 INCER JỌỌỌ t2 Ebe…;
  • Nkwado agbakwunyere maka ọrụ GIS ọhụrụ (Sistemụ Ozi Geographic): ST_Validate, MBRCoveredBy, ST_Simplif, ST_GeoHash, ST_LatFromGeoHash, ST_LongFromGeoHash, ST_PointFromGeoHash, ST_IsValid, ST_Collect.
  • Nkwado agbakwunyere maka ihe na-ebute ọkụ n'ọtụtụ mmemme. Nkwupụta CREATE TRIGGER nwere ike depụta mmemme dakọtara ya site na iji syntax "{ omume [ OR ... ]}".
  • Ngwa mgbakwunye Audit na-echekwa ozi gbasara ọdụ ụgbọ mmiri netwọkụ maka njikọ na-abata na ndekọ nyocha (na mbụ bụ naanị onye ọbịa ka egosipụtara).
  • Utility mariadb nwere nhọrọ "-script-dir" iji kọwapụta ndekọ ọchụchọ ọzọ maka scripts nke iwu SOURCE na-arụ.
  • E wepụrụ mgbanwe ndị ewepụrụ na mbụ big_tables, big_page_size, na storage_engine.

isi: opennet.ru

Tinye a comment