MySQL 8.3.0 DBMS dị

Oracle etolitela alaka ọhụrụ nke MySQL 8.3 DBMS wee bipụta mmelite mmezi na MySQL 8.0.36. A na-akwado MySQL Community Server 8.3.0 maka nkesa Linux, FreeBSD, macOS na Windows.

MySQL 8.3.0 bụ ntọhapụ nke atọ hibere n'okpuru ụdị ntọhapụ ọhụrụ, nke na-enye maka ọnụnọ nke ụdị abụọ nke alaka MySQL - "Innovation" na "LTS". Alaka Innovation, nke gụnyere MySQL 8.1, 8.2 na 8.3, ka akwadoro maka ndị chọrọ ịnweta ọrụ ọhụrụ na mbụ. A na-ebipụta alaka ndị a kwa ọnwa 3 ma na-akwado naanị ruo mgbe ebipụtara isi mmalite ọzọ (dịka ọmụmaatụ, mgbe mpụtachara alaka 8.3, nkwado maka alaka 8.2 kwụsịrị). A na-atụ aro alaka LTS maka mmejuputa iwu chọrọ amụma amụma na nchekwa ogologo oge nke omume agbanweghị agbanwe. A ga-ahapụ alaka LTS kwa afọ abụọ ma a ga-akwado ya maka afọ 5, na mgbakwunye na nke ị nwere ike nweta afọ 3 ọzọ nke nkwado ogologo oge. A na-atụ anya mwepụta LTS nke MySQL 2024 n'oge opupu ihe ubi nke 8.4, emesia a ga-emepụta alaka ọhụrụ 9.0 Innovation.

Nnukwu mgbanwe na MySQL 8.3:

  • Edozila adịghị ike 25, nke otu (CVE-2023-5363, na-emetụta OpenSSL) nwere ike irigbu ya ozugbo. Esemokwu kacha njọ metụtara ojiji nke usoro Kerberos ka ekenyela ogo ogo 8.8. Ọdịmma na-adịchaghị njọ nwere ọkwa dị njọ 6.5 na-emetụta njikarịcha, UDF, DDL, DML, mmegharị, sistemu ihe ùgwù na ngwaọrụ nzuzo.
  • N'elu ikpo okwu Linux, agbakwunyela nkwado maka onye na-ejikọta ebu. Iji mee ya, a na-enye nhọrọ "-DWITH_LD=mold|ld".
  • Ihe ndị a chọrọ maka ọkọlọtọ C++ nke ndị nchịkọta na-akwado site na C++17 ruo C++20.
  • Akwụsịla nkwado maka iji ụlọ akwụkwọ Boost C++ wuo - naanị ọba akwụkwọ Boost arụnyere n'ime ka a na-eji ugbu a mgbe ị na-achịkọta MySQL. CMake ewepụla WITH_BOOST, DOWNLOAD_BOOST na DOWNLOAD_BOOST_TIMEOUT nhọrọ nrụpụta.
  • Akwụsịla nkwado nrụpụta maka Visual Studio 2022. Ebulila ụdị ngwa ngwa Clang kacha akwadoro site na Clang 10 ruo Clang 12.
  • MySQL Enterprise Edition agbakwunyela nkwado maka ịnakọta telemetry nwere metrik gbasara ọrụ sava n'ụdị OpenTelemetry yana ịnyefe data na nhazi netwọkụ na-akwado usoro a.
  • Ụdị GTID (ihe nchọpụta azụmahịa zuru ụwa ọnụ), nke a na-eji n'oge mmegharị iji chọpụta otu azụmahịa, gbasaa. Ụdị GTID ọhụrụ - "UUID: : NUMBER" (kama "UUID: NUMBER"), ebe TAG bụ eriri aka ike na-enye gị ohere ikenye aha pụrụ iche n'otu ụdị azụmahịa maka nhazi na ntule dị mfe.
  • Agbakwunyere mgbanwe ọhụrụ abụọ "Deprecated_use_i_s_processlist_count" na "Deprecated_use_i_s_processlist_last_timestamp" iji soro ojiji nke tebụl INFORMATION_SCHEMA.PROCESSLIST kwụsịrị.
  • Ịtọ ntọala AUTHENTICATION_PAM_LOG gburugburu anaghịzi eme ka egosipụta okwuntughe na ozi nyocha (uru PAM_LOG_WITH_SECRET_INFO ka achọrọ iji kwupụta paswọọdụ).
  • Agbakwunyere tp_connections table nwere ozi gbasara njikọ ọ bụla na ọdọ mmiri eri.
  • agbakwunyere mgbanwe usoro "explain_json_format_version" iji họrọ ụdị usoro JSON ejiri na nkwupụta "EXPLAIN FORMAT=JSON".
  • Na nchekwa InnoDB, ewepụla "--innodb" na "--skip-innodb" nhọrọ, nke ewepụrụ na ntọhapụ MySQL 5.6. Ewepụla ngwa mgbakwunye memcached maka InnoDB, nke ewepụrụ na MySQL 8.0.22.
  • Wepụrụ ụfọdụ ntọala emetụtara mmegharị ahụ yana nhọrọ ahịrị iwu ndị kwụsịrị na mwepụta ndị gara aga: "--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". Ewepụla ikike iji nhọrọ IGNORE_SERVER_IDS nwere ụdị mmegharị GTID (gtid_mode=ON).
  • Akwụsịla nkwado maka ọrụ C API: mysql_kill(), mysql_list_fields(), mysql_list_processes(), mysql_refresh(), mysql_reload(), mysql_shutdown(), mysql_ssl_set().
  • Okwu "FLUSH HOSTS" akwụsịla na MySQL 8.0.23.

isi: opennet.ru

Tinye a comment