ProHoster > Ibhulogi > iindaba ze-intanethi > Ukukhutshwa okuzinzileyo kwe-MariaDB DBMS 10.6

Ukukhutshwa okuzinzileyo kwe-MariaDB DBMS 10.6

Emva konyaka wophuhliso kunye nokukhutshwa kokuqala okuthathu, ukukhululwa kokuqala okuzinzile kwesebe elitsha le-MariaDB 10.6 DBMS kuye kwapapashwa, apho isebe le-MySQL liphuhliswa eligcina ukuhambelana ngasemva kwaye lihlukaniswe ngokudityaniswa kweenjini zokugcina ezongezelelweyo. kunye nezakhono eziphambili. Inkxaso yesebe elitsha iya kunikezelwa kangangeminyaka emi-5, de kube nguJulayi 2026.

Uphuhliso lwe-MariaDB lujongwa yi-MariaDB Foundation ezimeleyo, ilandela inkqubo yophuhliso evulelekileyo necacileyo ezimeleyo kubathengisi ngabanye. I-MariaDB inikezelwa njengokutshintshwa kwe-MySQL kwiindawo ezininzi ze-Linux (RHEL, SUSE, Fedora, openSUSE, Slackware, OpenMandriva, ROSA, Arch Linux, Debian) kwaye iphunyezwe kwiiprojekthi ezinkulu ezifana ne-Wikipedia, i-Google Cloud SQL kunye ne-Nimbuzz.

Uphuculo oluphambili kwi-MariaDB 10.6:

  • Ukusetyenziswa kwe-athom yamagama athi “YEKA ITAFILE|BONA|NGQESHO igqitywe ngokupheleleyo okanye yonke into ibuyiselwe kwimo yayo yokuqala). Kwimeko ye "DROP TABLE" imisebenzi ecima iitafile ezininzi ngexesha elinye, i-atomicity iqinisekiswa kwinqanaba letafile nganye. Injongo yotshintsho kukuqinisekisa ingqibelelo xa kwenzeka ukuphazamiseka kweseva ngexesha lomsebenzi. Ngaphambili, emva kokuphahlazeka, iitafile zexeshana kunye neefayile zingahlala, ukulungelelaniswa kweetafile kwiinjini zokugcina kunye neefayile ze-frm zingaphazamiseka, kwaye iitafile zodwa zingahlala zingaqanjwanga xa iitafile ezininzi zibizwa kwakhona ngokukhawuleza. Imfezeko iqinisekiswa ngokugcina ilog yokubuyisela imeko, indlela enokumiselwa ngokhetho olutsha “—log-ddl-recovery=file” (ddl-recovery.log ngokungagqibekanga).
  • Ulwakhiwo "KHETHA ... OFFSET ... FETCH" oluchazwe kumgangatho weSQL 2008 luphunyeziwe, okukuvumela ukuba ubonise inani elithile lemigca eqala kwi-offset ekhankanyiweyo, kunye nokukwazi ukusebenzisa iparameter "NGAMAQHAYA". ncamathela elinye ixabiso elilandelayo. Umzekelo, ibinzana elithi "KHETHA i KUSUKA t1 ORDER BY i ASC OFFSET 1 ROWS LANDA IMIQESHO YOKUQALA EMI-3 NGEZIQINISEKISO" yahlukile kulwakhiwo "KHETHA i KUSUKA t1 ORDER BY i ASC LIMIT 3 OFFSET 1" ngokukhupha enye into emsileni. (endaweni yemigca emi-3 4 iya kuprintwa).
  • Kwi-injini ye-InnoDB, i-"KHETHA ... SKIP LOCKED" i-syntax iphunyeziwe, ekuvumela ukuba ungabandakanyi imigca apho isitshixo singenakho ukusetwa ("SHIXA KWIMODI YOKWABELANA" okanye "UKUHLAZIYA").
  • Ukukwazi ukungazihoyi izalathisi kuphunyeziwe (kwi-MySQL 8, lo msebenzi ubizwa ngokuba yi "invisible indexes"). Ukumakisha isalathisi sokungahoywa kwenziwa ngokusebenzisa i-IGNORED iflegi kwi-ALTER TABLE statement, emva koko isalathisi sihlala sibonakala kwaye sihlaziywa, kodwa asisetyenziswa ngu-optimizer.
  • Yongeziwe JSON_TABLE () umsebenzi ukuguqula idatha ye-JSON ibe yifomu yobudlelwane. Umzekelo, uxwebhu lwe-JSON lunokuguqulwa lusetyenziswe kumxholo wetafile, enokuthi icaciswe ngaphakathi kwe-FROM block kwi-SELECT statement.
  • Ukuphucula ukuhambelana ne-Oracle DBMS: Inkxaso eyongeziweyo yee-subqueries ezingaziwa ngaphakathi kwe-FROM block. Ulwakhiwo lweMINUS luye lwaphunyezwa (olulingana NOKUPHILA). Yongezwe ADD_MONTHS(), TO_CHAR(), SYS_GUID() kunye ROWNUM() imisebenzi.
  • Kwi-injini ye-InnoDB, ukufakwa kwiitafile ezingenanto kuye kwakhawuleziswa. Ifomati yomtya CONPRESSED isetelwe kwindlela yokufunda-kuphela ngokungagqibekanga. Inkqubo ye-SYS_TABLESPACES ithathelwe indawo SYS_DATAFILES kwaye ibonakalisa ngokuthe ngqo imeko kwinkqubo yefayile. Inkxaso yokubhala eyonqenayo ibonelelwa kwindawo yetafile yethutyana. Inkxaso ye-algorithm ye-checksum endala, egcinwe ukuhambelana noMariaDB 5.5, iyekile.
  • Kwinkqubo yokuphindaphinda, ubungakanani bexabiso leparameter ye master_host bonyusiwe ukusuka kuma-60 ukuya kuma-255 oonobumba, kwaye master_user ukuya kwi-128. I-binlog_expire_logs_seconds variables yongezwe ukuqwalasela ixesha lokuphelelwa kwelog yokubini kwimizuzwana (ngaphambili, ixesha lokusetha kwakhona beliyi- kugqitywe kuphela ngeentsuku nge-expire_logs_days variables).
  • I-Galera synchronous multi-master replication mechanism iphumeza ukuguquguquka kwe-wsrep_mode ukumisela i-WSREP (Bhala i-REPlication) iiparamitha ze-API. Ivumele iGalera ukuba itshintshe kunxibelelwano olungafihlwanga ukuya kwi-TLS ngaphandle kokumisa iqela.
  • I-sys-schema schema iphunyeziwe, equlethe ingqokelela yeembono, imisebenzi kunye neenkqubo zokuhlalutya imisebenzi yogcino-lwazi.
  • Iitheyibhile zenkonzo ezongeziweyo zokuhlalutya ukusebenza kophindaphindo.
  • Iimbono ze-INFORMATION_SCHEMA.KEYWORDS kunye ne-INFORMATION_SCHEMA.SQL_FUNCTIONS zongezwe kwiseti yeetheyibhile zolwazi, ebonisa uluhlu lwamagama angundoqo akhoyo kunye nemisebenzi.
  • I-TokuDB kunye neCassandraSE yokugcina isusiwe.
  • I-encoding ye-utf8 ikhutshiwe ukusuka kumelo we-byte ezine utf8mb4 (U+0000..U+10FFFF) ukuya kwi-threebyte utf8mb3 (igubungela uluhlu lwe-Unicode U+0000..U+FFFF).
  • Inkxaso eyongeziweyo yokuvula i-socket kwi-systemd.
  • I-plugin ye-GSSAPI yongeze inkxaso yamagama eqela le-Active Directory kunye nee-SID.
  • Itshekhi eyongeziweyo yobukho befayile yoqwalaselo $MARIADB_HOME/my.cnf ukongeza kwi $MYSQL_HOME/my.cnf.
  • Iinguqu zenkqubo entsha binlog_expire_logs_seconds, innodb_deadlock_report, innodb_read_only_compressed, wsrep_mode kunye ne-Innodb_buffer_pool_pages_lru_freed ziphunyeziwe.

umthombo: opennet.ru

Yongeza izimvo