ProHoster > Блог > wararka internetka > MySQL 8.3.0 DBMS waa la heli karaa

MySQL 8.3.0 DBMS waa la heli karaa

Oracle wuxuu sameeyay laan cusub oo MySQL 8.3 DBMS ah wuxuuna daabacay cusbooneysiinta sixitaanka MySQL 8.0.36. MySQL Community Server 8.3.0 dhismooyin ayaa loo diyaariyey dhammaan Linux waaweyn, FreeBSD, macOS iyo qaybinta Windows.

MySQL 8.3.0 waa sii dayntii saddexaad ee lagu sameeyay qaabka cusub ee sii deynta, kaas oo bixiya joogitaanka laba nooc oo laamood MySQL ah - "Innovation" iyo "LTS". Laamaha hal-abuurka, oo ay ku jiraan MySQL 8.1, 8.2 iyo 8.3, ayaa lagula talinayaa kuwa doonaya inay hore u helaan hawl cusub. Laamahaan waxaa la daabacaa 3-dii biloodba mar waxaana la taageeraa oo kaliya ilaa laga soo saaro sii deynta weyn ee soo socota (tusaale ahaan, ka dib muuqaalka laanta 8.3, taageerada laanta 8.2 waa la joojiyay). Laamaha LTS waxa lagula taliyaa fulinta u baahan saadaalinta iyo ku adkaysiga muddada dheer ee dhaqanka aan isbeddelin. Laamaha LTS ayaa la sii deyn doonaa labadii sanaba mar waxaana si caadi ah loo taageeri doonaa 5 sano, taas oo ay kuu dheer tahay inaad heli karto 3 sano oo kale oo taageero ah. Siidaynta LTS ee MySQL 2024 ayaa la filayaa guga 8.4, markaas ka dib laan cusub oo cusub oo 9.0 ah ayaa la samayn doonaa.

Isbeddellada waaweyn ee MySQL 8.3:

  • 25 dayacan ayaa la hagaajiyay, kuwaas oo mid ka mid ah (CVE-2023-5363, saameeya OpenSSL) laga faa'iidaysan karo meel fog. Arrinta ugu daran ee la xiriirta isticmaalka borotokoolka Kerberos waxaa loo qoondeeyay heerka darnaanta 8.8. Nuglaanta yar ee daran ee leh heerka darnaanta 6.5 waxay saamaysaa hagaajinta, UDF, DDL, DML, ku celcelinta, nidaamka mudnaanta, iyo qalabka sirta.
  • Goobta Linux, taageerada isku xirka caaryada ayaa lagu daray. Si loo suurtogeliyo, doorashada "-DWITH_LD=mold|ld" ayaa la bixiyay.
  • Shuruudaha heerka C++ ee uu taageeray isku-dubariduhu waxa laga soo kiciyey C++17 ilaa C++20.
  • Taageerada dhisitaanka maktabadaha Kordhinta C++ ee dibadda waa la joojiyay - kaliya maktabadaha Kobcinta ee ku dhex jira ayaa hadda la isticmaalaa marka la ururinayo MySQL. CMake waxay meesha ka saartay WITH_BOOST, DOWNLOAD_BOOST iyo DOWNLOAD_BOOST_TIMEOUT xulashooyinka dhisida.
  • Taageerada dhisitaanka Visual Studio 2022 waa la joojiyay. Nooca ugu yar ee la taageeray ee qalabka Clang ayaa laga soo qaaday Clang 10 ilaa Clang 12.
  • MySQL Enterprise Edition waxa ay ku dartay taageerada ururinta telemetry oo leh cabbiro ku saabsan hawlgalka adeegaha ee qaabka OpenTelemetry iyo u wareejinta xogta processor-ka shabakad taageera qaabkan.
  • Qaabka GTID (aqoonsiga macaamil ganacsi ee caalamiga ah), oo loo isticmaalo inta lagu guda jiro ku-noqoshada si loo aqoonsado kooxaha wax kala iibsiga, waa la ballaariyay. Qaabka cusub ee GTID waa “UUID: : NUMBER" (halkii "UUID: NUMBER"), halkaas oo TAG uu yahay xarig gardarro ah oo kuu ogolaanaya inaad magacyo gaar ah u dhiibto koox gaar ah oo macaamil ganacsi ah si ay u sahlanaato habaynta iyo falanqaynta.
  • Waxaa lagu daray laba doorsoomayaal cusub "Deprecated_use_i_s_processlist_count" iyo "Deprecated_use_i_s_processlist_last_timestamp" si ay ula socdaan isticmaalka miiska INFORMATION_SCHEMA.PROCESSLIST.
  • Dejinta AUTHENTICATION_PAM_LOG doorsoome deegaan ma keenayso furaha sirta ah in lagu soo bandhigo fariimaha ogaanshaha (qiimaha PAM_LOG_WITH_SECRET_INFO ayaa loo baahan yahay si loo xuso erayga sirta ah).
  • Miiska tp_connections oo lagu daray macluumaad ku saabsan xiriir kasta oo ku jira barkada dunta.
  • Doorsoomiyaha nidaamka lagu daray "explain_json_format_version" si loo doorto nooca qaabka JSON ee loo isticmaalo "EXPLAIN FORMAT=JSON" weedhaha.
  • Kaydinta InnoDB, "--innodb" iyo "--skip-innodb", oo laga saaray MySQL 5.6, waa laga saaray. Plugin memcached ee InnoDB, kaas oo laga saaray MySQL 8.0.22, waa laga saaray.
  • Meesha laga saaray qaar ka mid ah habaynta la xidhiidha ku-noqoshada iyo xulashooyinka khadka taliska ee laga saaray siidaynta hore: "--slave-rows-search-algorithms", "--relay-log-info-file", "-relay-log-info-repository" ", "-master-info-file", "-master-info-repository", "log_bin_use_v1_events", "transaction_write_set_extraction", "group_replication_ip_whitelist", "group_replication_primary_member". Kartida isticmaalka IGNORE_SERVER_IDS ikhtiyaarka leh GTID qaabka ku celcelinta (gtid_mode=ON) waa laga saaray.
  • Taageerada hawlaha API C waa la joojiyay: mysql_kill (), mysql_list_fields (), mysql_list_processes (), mysql_refresh (), mysql_reload (), mysql_shutdown (), mysql_ssl_set ().
  • Odhaahda "FLUSH HOSTS", kaas oo laga saaray MySQL 8.0.23, waa la joojiyay.

Source: opennet.ru

Add a comment