MySQL 8.3.0 DBMS avanoa

Ua fausia e Oracle se lala fou o le MySQL 8.3 DBMS ma faʻasalalau se faʻafouga faʻasaʻo ile MySQL 8.0.36. MySQL Community Server 8.3.0 fausia ua saunia mo Linux tetele, FreeBSD, macOS ma Windows tufatufaga.

MySQL 8.3.0 o le faʻasalalauga lona tolu na faʻavaeina i lalo o le faʻataʻitaʻiga fou, lea e maua ai le i ai o ituaiga e lua o lala MySQL - "Innovation" ma le "LTS". O lala Innovation, e aofia ai MySQL 8.1, 8.2 ma 8.3, ua fautuaina mo i latou e fia maua avanoa i galuega fou muamua. O nei lala e fa'asalalauina i masina ta'i 3 ma e na'o le lagolagoina lava se'ia o'o ina fa'asalalau le isi fa'asalalauga tele (mo se fa'ata'ita'iga, ina ua mae'a fa'aalia le lala 8.3, na fa'agata le lagolago mo le lala 8.2). LTS lala e fautuaina mo faʻatinoga e manaʻomia ai le vaʻaia ma le faʻasaoina umi o amioga e le suia. O lala LTS o le a tatalaina i le ta'ilua tausaga ma o le a lagolagoina masani mo le 5 tausaga, e faaopoopo atu i ai e mafai ona e mauaina le isi 3 tausaga o le lagolago faaopoopo. O se faʻasalalauga LTS o MySQL 2024 o loʻo faʻamoemoeina i le tautotogo o le 8.4, a maeʻa ona fausia ai se lala fou o le Innovation 9.0.

Suiga tetele i MySQL 8.3:

  • 25 fa'aletonu ua fa'amautu, o le tasi (CVE-2023-5363, e a'afia ai OpenSSL) e mafai ona fa'aogaina mamao. O le mataupu pito sili ona ogaoga e fesoʻotaʻi ma le faʻaogaina o le Kerberos protocol ua tuʻuina atu i se tulaga ogaoga o le 8.8. Fa'aleaogaina fa'aletonu fa'atasi ma le mamafa tulaga 6.5 e a'afia ai le optimizer, UDF, DDL, DML, replication, privilege system, ma encryption tools.
  • I luga o le Linux platform, ua faaopoopo le lagolago mo le mold linker. Ina ia mafai ai, o le filifiliga "-DWITH_LD = mold | lld" ua saunia.
  • O manaʻoga mo le C ++ tulaga faʻapitoa e lagolagoina e le tuʻufaʻatasia ua siitia mai C ++ 17 i C ++ 20.
  • O le lagolago mo le faufale i fafo o le Boost C++ faletusi ua le toe fa'aauau - na'o faletusi o lo'o fausia i totonu o lo'o fa'aogaina nei pe a tu'ufa'atasia MySQL. Ua aveese e CMake le WITH_BOOST, DOWNLOAD_BOOST ma le DOWNLOAD_BOOST_TIMEOUT filifiliga fau.
  • Fausia le lagolago mo Visual Studio 2022 ua le toe fa'aauauina. O le vaega aupito maualalo o lo'o lagolagoina o le Clang toolkit ua si'itia mai le Clang 10 i le Clang 12.
  • MySQL Enterprise Edition ua faʻaopoopoina le lagolago mo le aoina o telefoni faʻatasi ma metrics e uiga i le faʻaogaina o le server i le OpenTelemetry format ma le tuʻuina atu o faʻamatalaga i se fesoʻotaʻiga fesoʻotaʻiga e lagolagoina lenei faatulagaga.
  • O le GTID (global transaction identifier) ​​​​format, faʻaaogaina i le taimi o le toe faia e iloa ai vaega o fefaʻatauaiga, ua faʻalauteleina. Fou GTID faatulagaga - "UUID: : NUMERA" (nai lo le "UUID:NUMBER"), o le TAG o se manoa faʻapitoa e mafai ai ona e tuʻuina atu igoa faʻapitoa i se vaega faʻapitoa o fefaʻatauaiga mo le faʻafaigofieina o gaioiga ma faʻavasega.
  • Fa'aopoopo ni suiga fou se lua "Deprecated_use_i_s_processlist_count" ma le "Deprecated_use_i_s_processlist_last_timestamp" e siaki ai le fa'aogaina o le laulau INFORMATION_SCHEMA.PROCESSLIST ua le toe fa'aaogaina.
  • O le fa'atulagaina o le suiga ole siosiomaga AUTHENTICATION_PAM_LOG e le toe fa'aalia ai upu fa'amaonia i fe'au fa'ata'ita'i (o le tau o le PAM_LOG_WITH_SECRET_INFO e mana'omia e ta'u ai se fa'aupuga).
  • Fa'aopoopo le laulau tp_connections fa'atasi ai ma fa'amatalaga e uiga i so'oga ta'itasi i totonu o le filo filo.
  • Fa'aopoopo le fesuiaiga o le faiga "explain_json_format_version" e filifili ai le JSON format version o lo'o fa'aogaina i fa'amatalaga "EXPLAIN FORMAT=JSON".
  • I totonu o le teuina o InnoDB, o le "--innodb" ma le "--skip-innodb" filifiliga, lea na faʻaumatia i le MySQL 5.6 faʻamalolo, ua aveesea. O le memcached plugin mo InnoDB, lea na faʻaumatia i MySQL 8.0.22, ua aveese.
  • Aveese nisi faʻasologa e fesoʻotaʻi ma faʻatonuga laina laina na faʻaaogaina i faʻasalalauga muamua: "--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". Le mafai ona fa'aoga le filifiliga IGNORE_SERVER_IDS ma le GTID replication mode (gtid_mode=ON) ua aveese.
  • Lagolago mo galuega C API ua le toe fa'aauauina: mysql_kill(), mysql_list_fields(), mysql_list_processes(), mysql_refresh(), mysql_reload(), mysql_shutdown(), mysql_ssl_set().
  • Le fa'aaliga "FLUSH HOSTS", lea na fa'agata i MySQL 8.0.23, ua fa'agata.

puna: opennet.ru

Faaopoopo i ai se faamatalaga