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

MariaDB 10.6 tso tawm ruaj khov

Tom qab ib xyoos ntawm kev txhim kho thiab peb qhov kev tso tawm ua ntej, thawj qhov kev tso tawm ruaj khov ntawm cov ceg tshiab ntawm MariaDB 10.6 DBMS tau raug luam tawm, nyob rau hauv uas ib ceg ntawm MySQL tab tom tsim kho uas tswj kev rov qab sib raug zoo thiab txawv los ntawm kev sib koom ua ke ntawm cov tshuab cia ntxiv. thiab muaj peev xwm tshaj plaws. Kev txhawb nqa rau ceg tshiab yuav muab rau 5 xyoos, txog rau thaum Lub Xya Hli 2026.

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.

Kev txhim kho tseem ceeb hauv MariaDB 10.6:

  • Lub atomic execution ntawm cov kab lus "CREATE TABLE|VIEW|SEQUENCE|TRIGGER", "ALTER TABLE|SEQUENCE", "RENAME TABLE|TABLES", "DROP TABLE|VIEW|VIEW|TRIGGER|DATABASE" yog guaranteed (xws li cov lus qhia yog ua tiav tiav lossis txhua yam rov qab mus rau nws lub xeev qub). Nyob rau hauv rooj plaub ntawm "DROP TABLE" kev ua haujlwm uas tshem tawm ntau lub rooj ib zaug, atomicity tau ua kom ntseeg tau ntawm qib ntawm txhua tus neeg lub rooj. Lub hom phiaj ntawm qhov kev hloov pauv yog kom muaj kev ncaj ncees nyob rau hauv qhov xwm txheej ntawm lub server poob thaum lub sijhawm ua haujlwm. Yav dhau los, tom qab kev sib tsoo, cov ntxhuav thiab cov ntaub ntawv ib ntus tuaj yeem nyob twj ywm, synchronization ntawm cov ntxhuav hauv cov tshuab cia thiab frm cov ntaub ntawv tuaj yeem cuam tshuam, thiab cov rooj sib tham yuav nyob twj ywm unrenamed thaum ob peb lub rooj tau hloov npe ib zaug. Kev ncaj ncees yog ua kom ntseeg tau los ntawm kev tswj hwm lub xeev cov ntaub ntawv rov qab, txoj hauv kev uas tuaj yeem txiav txim siab los ntawm kev xaiv tshiab "-log-ddl-recovery=file" (ddl-recovery.log los ntawm lub neej ntawd).
  • Qhov "SELECT ... OFFSET ... FETCH" kev tsim kho uas tau teev tseg hauv SQL 2008 tus qauv tau ua tiav, tso cai rau koj los tso saib qee cov kab pib los ntawm kev teev tseg offset, nrog lub peev xwm los siv "Nrog TIES" parameter rau txuas lwm tus nqi tom ntej. Piv txwv li, cov lus hais tias "SELECT i FROM t1 ORDER BY i ASC OFFSET 1 ROWS FETCH FIRST 3 ROWS WITH TIES" txawv ntawm kev tsim kho "SELECT i FROM t1 ORDER BY i ASC LIMIT 3 OFFSET 1" los ntawm kev tso tawm ib qho ntxiv hauv tus Tsov tus tw. (xws li 3 4 kab yuav luam tawm).
  • Rau lub cav InnoDB, "SELECT ... SKIP LOCKED" syntax tau ua tiav, uas tso cai rau koj tshem tawm cov kab uas lub xauv tsis tuaj yeem teeb tsa ("LOCK IN SHARE MODE" lossis "FOR UPDATE").
  • Kev muaj peev xwm tsis quav ntsej cov indexes tau ua tiav (hauv MySQL 8, qhov haujlwm no hu ua "invisible indexes"). Kos qhov ntsuas qhov ntsuas kom tsis quav ntsej yog ua tiav siv tus chij IGNORED hauv ALTER TABLE nqe lus, tom qab ntawd qhov ntsuas tseem pom thiab hloov kho, tab sis tsis yog siv los ntawm tus optimizer.
  • Ntxiv JSON_TABLE() muaj nuj nqi los hloov JSON cov ntaub ntawv rau hauv daim ntawv sib txheeb. Piv txwv li, ib daim ntawv JSON tuaj yeem hloov pauv tau siv rau hauv cov ntsiab lus ntawm lub rooj, uas tuaj yeem teev nyob rau hauv ib qho FROM block hauv SELECT nqe lus.
  • Txhim kho kev sib raug zoo nrog Oracle DBMS: Ntxiv kev txhawb nqa rau cov lus qhia tsis qhia npe hauv FROM thaiv. Kev tsim kho MINUS tau ua tiav (sib npaug rau EXCEPT). Ntxiv ADD_MONTHS(), TO_CHAR(), SYS_GUID() thiab ROWNUM() ua haujlwm.
  • Hauv lub cav InnoDB, ntxig rau hauv cov ntxhuav khoob tau nrawm dua. COMPRESSED txoj hlua hom yog teem rau hom nyeem nkaus xwb los ntawm lub neej ntawd. SYS_TABLESPACES scheme hloov SYS_DATAFILES thiab qhia ncaj qha rau lub xeev hauv cov ntaub ntawv kaw lus. Lazy sau kev txhawb nqa yog muab rau lub rooj zaum ib ntus. Kev them nyiaj yug rau lub qub checksum algorithm, uas tau khaws cia rau kev sib raug zoo nrog MariaDB 5.5, tau raug txiav lawm.
  • Nyob rau hauv lub replication system, qhov luaj li cas ntawm tus master_host parameter tus nqi tau nce los ntawm 60 mus rau 255 cim, thiab master_user mus rau 128. Lub binlog_expire_logs_seconds sib txawv tau ntxiv rau configure lub sij hawm tas sij hawm ntawm binary log nyob rau hauv vib nas this (yav tas los, lub sij hawm pib dua yog txiav txim tsuas yog nyob rau hauv cov hnub dhau los ntawm lub expire_logs_days variable).
  • Galera synchronous multi-master replication mechanism siv qhov sib txawv ntawm wsrep_mode los teeb tsa WSREP (Sau Teem REPlication) API tsis txwv. Tso cai hloov dua siab tshiab ntawm Galera los ntawm kev sib txuas lus tsis tau nkag mus rau TLS yam tsis tau tso tseg pawg.
  • Lub sys-schema schema tau raug coj los siv, uas muaj cov kev sib sau ntawm kev pom, kev ua haujlwm thiab cov txheej txheem rau kev txheeb xyuas cov haujlwm database.
  • Ntxiv cov ntawv pabcuam rau kev txheeb xyuas kev ua haujlwm rov ua dua.
  • INFORMATION_SCHEMA.KEYWORDS thiab INFORMATION_SCHEMA.SQL_FUNCTIONS views tau ntxiv rau cov ntaub ntawv teev lus, tso tawm cov npe ntawm cov ntsiab lus muaj thiab cov haujlwm.
  • TokuDB thiab CassandraSE repositories tau raug tshem tawm.
  • Lub utf8 encoding tau raug txav los ntawm plaub-byte sawv cev utf8mb4 (U + 0000..U + 10FFFF) mus rau peb-byte utf8mb3 (nrog rau Unicode ntau U + 0000..U + FFFF).
  • Ntxiv kev txhawb nqa rau lub qhov (socket activation) hauv systemd.
  • Lub GSSAPI plugin tau ntxiv kev txhawb nqa rau Active Directory pawg npe thiab SIDs.
  • Ntxiv kos rau muaj cov ntaub ntawv teeb tsa $MARIADB_HOME/my.cnf ntxiv rau $MYSQL_HOME/my.cnf.
  • Cov kab ke tshiab hloov pauv binlog_expire_logs_seconds, innodb_deadlock_report, innodb_read_only_compressed, wsrep_mode thiab Innodb_buffer_pool_pages_lru_freed tau ua tiav.

Tau qhov twg los: opennet.ru

Ntxiv ib saib