ProHoster > Π‘Π»ΠΎΠ³ > xov xwm hauv internet > MariaDB 10.7 tso tawm ruaj khov

MariaDB 10.7 tso tawm ruaj khov

Tom qab 6 lub hlis ntawm txoj kev loj hlob, thawj qhov ruaj khov tso tawm ntawm ceg tshiab ntawm DBMS MariaDB 10.7 (10.7.2) tau tshaj tawm, nyob rau hauv uas ib ceg ntawm MySQL tab tom tsim uas tswj kev rov qab sib raug zoo thiab txawv los ntawm kev sib koom ua ke ntawm kev khaws cia ntxiv. engines thiab advanced muaj peev xwm. MariaDB txoj kev loj hlob yog saib xyuas los ntawm MariaDB Foundation ywj pheej, ua raws li txoj kev loj hlob qhib thiab pob tshab uas yog ywj siab ntawm tus neeg muag khoom. MariaDB tau muab los ua kev hloov pauv rau MySQL hauv ntau qhov kev faib tawm Linux (RHEL, SUSE, Fedora, openSUSE, Slackware, OpenMandriva, ROSA, Arch Linux, Debian) thiab tau ua tiav hauv cov haujlwm loj xws li Wikipedia, Google Cloud SQL thiab Nimbuzz.

Nyob rau tib lub sijhawm, thawj qhov kev sim tso tawm ntawm cov ceg loj tom ntej ntawm MariaDB 10.8.1 thiab kho qhov hloov tshiab 10.6.6, 10.5.14, 10.4.23, 10.3.33 thiab 10.2.42 raug tso tawm. Tso tawm 10.7.2 yog thawj zaug tom qab qhov project hloov mus rau cov qauv kev tso tawm tshiab, uas txhais tau tias txo qis hauv kev txhawb nqa los ntawm 5 xyoo mus rau 1 xyoo thiab kev hloov pauv mus rau kev tsim cov kev tshaj tawm tseem ceeb tsis yog ib xyoos ib zaug, tab sis ib zaug hauv peb lub hlis twg. .

Kev txhim kho tseem ceeb hauv MariaDB 10.7:

  • Ntxiv cov ntaub ntawv UUID tshiab tsim los khaws 128-ntsis Cim Cim Cim.
  • Cov haujlwm tshiab tau raug thov rau kev ua cov ntaub ntawv hauv JSON hom: JSON_EQUALS() rau kev sib piv tus kheej ntawm ob JSON cov ntaub ntawv thiab JSON_NORMALIZE() rau nqa JSON cov khoom rau hauv ib daim ntawv uas tsim nyog rau kev ua haujlwm sib piv (tshem cov yuam sij thiab tshem tawm qhov chaw).
  • Ntxiv cov NATURAL_SORT_KEY() muaj nuj nqi rau kev txheeb cov hlua coj mus rau hauv tus account cov txiaj ntsig digital (piv txwv li, txoj hlua "v10" tom qab kev txheeb xyuas yuav tshwm sim tom qab txoj hlua "v9").
  • Ntxiv cov SFORMAT() muaj nuj nqi rau arbitrary formatting ntawm cov hlua - cov tswv yim yog ib txoj hlua nrog formatting commands thiab ib daim ntawv teev cov nqi rau kev hloov (piv txwv li, 'SFORMAT("Cov lus teb yog {}.", 42)').
  • Txhim kho kev qhia yuam kev hauv INSERT cov lus nug uas ntxiv cov ntaub ntawv rau ntau kab (GET DIAGNOSTICS hais kom ua tam sim no qhia txog ROW_NUMBER cov cuab yeej qhia txog kab zauv nrog qhov yuam kev).
  • Ib tug tshiab lo lus zais xyuas plugin, password_reuse_check, yog suav nrog, uas tso cai rau koj txwv tsis pub rov qab siv cov passwords los ntawm ib tug neeg siv (xyuas tias tus password tshiab tsis phim cov passwords siv thaum lub sij hawm teev los ntawm tus password_reuse_check_interval parameter).
  • Ntxiv kev txhawb nqa rau cov kab lus "ALTER TABLE ... CONVERT PARTITION .. TO TABLE" thiab "ALTER TABLE ... CONVERT TABLE ... PARTITION" rau kev hloov pauv ib qho kev faib rau hauv lub rooj thiab vice versa.
  • Qhov kev xaiv "--as-of" tau ntxiv rau mariadb-khoom siv hluav taws xob los pov tseg cov pob tseg sib xws rau ib lub xeev tshwj xeeb ntawm lub rooj sib tham.
  • Rau MariaDB Galera Cluster, cov xeev tshiab "tos kom ua tiav nyob rau hauv kev sib cais", "tos TOI DDL", "tos tswj ntws" thiab "tseem ntawv pov thawj" yog siv hauv PROCESSLIST.
  • Ib tug tshiab parameter "reorder" tau ntxiv rau qhov optimizer. Rau cov hlua ntau-byte, qhov ua tau zoo ntawm cov cim lub ntsiab lus-paub qhov sib txuam hauv ASCII ntau yam haujlwm tau raug txhim kho.
  • InnoDB cia tau txhim kho kev ua tau zoo rau batch insert operations, presorting, thiab index building.
  • 5 qhov tsis zoo tau raug kho, cov ntsiab lus tseem tsis tau tshaj tawm: CVE-2022-24052, CVE-2022-24051, CVE-2022-24050, CVE-2022-24048, CVE-2021-46659.
  • Ntawm cov kev hloov pauv hauv qhov kev sim tso tawm ntawm MariaDB 10.8.1, peb tuaj yeem nco ntsoov qhov kev siv ntawm indexes txheeb hauv nqe lus nug, uas tuaj yeem txhim kho qhov kev ua tau zoo ntawm ORDER BY kev ua haujlwm thaum nqa rov qab. Ntxiv IN, OUT, INOUT thiab IN OUT specifiers rau khaws cia ua haujlwm. Nyob rau hauv InnoDB, tus naj npawb ntawm kev sau ntawv ua haujlwm thaum nkag mus ua haujlwm rollback (redo) tau raug txo.

Tau qhov twg los: opennet.ru

Ntxiv ib saib