ืคึผืจืึธื”ืึธืกื˜ืขืจ > ื‘ืœืึธื’ > ืื™ื ื˜ืขืจื ืขื˜ ื ื™ื™ึทืขืก > MySQL 8.3.0 DBMS ื‘ื ื™ืžืฆื

MySQL 8.3.0 DBMS ื‘ื ื™ืžืฆื

ืึธืจืึทืงืœืข ื”ืื˜ ื’ืขื’ืจื™ื ื“ืขื˜ ืึท ื ื™ื™ึทืข ืฆื•ื•ื™ื™ึทื’ ืคื•ืŸ ื“ื™ MySQL 8.3 DBMS ืื•ืŸ ืืจื•ื™ืก ืึท ืงืขืจืขืงื˜ื™ื•ื• ื“ืขืจื”ื™ื™ึทื ื˜ื™ืงืŸ ืฆื• MySQL 8.0.36. MySQL Community Server 8.3.0 ื‘ื•ื™ืขืŸ ืื™ื– ืฆื•ื’ืขื’ืจื™ื™ื˜ ืคึฟืึทืจ ืึทืœืข ื”ื•ื™ืคึผื˜ ืœื™ื ื•ืงืก, ืคืจืขืขื‘ืกื“, ืžืึทืงืึธืก ืื•ืŸ Windows ื“ื™ืกื˜ืจื™ื‘ื™ื•ืฉืึทื ื–.

MySQL 8.3.0 ืื™ื– ื“ื™ ื“ืจื™ื˜ ืžืขืœื“ื•ื ื’ ื’ืขื’ืจื™ื ื“ืขื˜ ืื•ื ื˜ืขืจ ื“ื™ ื ื™ื™ึทืข ืžืขืœื“ื•ื ื’ ืžืึธื“ืขืœ, ื•ื•ืึธืก ื’ื™ื˜ ื“ื™ ื‘ื™ื™ึทื–ื™ื™ึทืŸ ืคื•ืŸ ืฆื•ื•ื™ื™ ื˜ื™ื™ืคึผืก ืคื•ืŸ MySQL ืฆื•ื•ื™ื™ื’ืŸ - "ื™ื ื ืึธื•ื•ืึทื˜ื™ืึธืŸ" ืื•ืŸ "LTS". ื“ื™ ื™ื ื ืึธื•ื•ืึทื˜ื™ืึธืŸ ืฆื•ื•ื™ื™ื’ืŸ, ื•ื•ืึธืก ืึทืจื™ื™ึทื ื ืขืžืขืŸ MySQL 8.1, 8.2 ืื•ืŸ 8.3, ื–ืขื ืขืŸ ืจืขืงืึทืžืขื ื“ื™ื“ ืคึฟืึทืจ ื™ืขื ืข ื•ื•ืึธืก ื•ื•ื™ืœืŸ ืฆื• ื‘ืึทืงื•ืžืขืŸ ืึทืงืกืขืก ืฆื• ื ื™ื™ึทืข ืคืึทื ื’ืงืฉืึทื ืึทืœื™ื˜ื™ ืคืจื™ืขืจ. ื“ื™ ืฆื•ื•ื™ื™ื’ืŸ ื–ืขื ืขืŸ ืืจื•ื™ืก ื™ืขื“ืขืจ 3 ื—ื“ืฉื™ื ืื•ืŸ ื–ืขื ืขืŸ ื’ืขืฉื˜ื™ืฆื˜ ื‘ืœื•ื™ื– ื‘ื™ื– ื“ืขืจ ื•ื•ื™ื™ึทื˜ืขืจ ื”ื•ื™ืคึผื˜ ืžืขืœื“ื•ื ื’ ืื™ื– ืืจื•ื™ืก (ืœืžืฉืœ, ื ืึธืš ื“ื™ ืื•ื™ืกื–ืขืŸ ืคื•ืŸ ื“ื™ 8.3 ืฆื•ื•ื™ื™ึทื’, ืฉื˜ื™ืฆืŸ ืคึฟืึทืจ ื“ื™ 8.2 ืฆื•ื•ื™ื™ึทื’ ืื™ื– ืึธืคึผื’ืขืฉื˜ืขืœื˜). LTS ืฆื•ื•ื™ื™ื’ืŸ ื–ืขื ืขืŸ ืจืขืงืึทืžืขื ื“ื™ื“ ืคึฟืึทืจ ื™ืžืคึผืœืึทืžืึทื ืฅ ื•ื•ืึธืก ื“ืึทืจืคืŸ ืคึผืจื™ื“ื™ืงื˜ืึทื‘ื™ืœื™ื˜ื™ ืื•ืŸ ืœืึทื ื’-ื˜ืขืจืžื™ืŸ ืคึผืขืจืกื™ืกื˜ืึทื ืก ืคื•ืŸ ืึทื ื˜ืฉื™ื™ื ื“ื–ืฉื“ ื ืึทื˜ื•ืจ. LTS ืฆื•ื•ื™ื™ื’ืŸ ื•ื•ืขื˜ ื–ื™ื™ืŸ ื‘ืืคืจื™ื™ื˜ ื™ืขื“ืขืจ ืฆื•ื•ื™ื™ ื™ืึธืจ ืื•ืŸ ื•ื•ืขื˜ ื–ื™ื™ืŸ ื’ืขืฉื˜ื™ืฆื˜ ื ืึธืจืžืึทืœื™ ืคึฟืึทืจ 5 ื™ืืจ, ืื™ืŸ ืึทื“ื™ืฉืึทืŸ ืฆื• ื•ื•ืึธืก ืื™ืจ ืงืขื ืขืŸ ื‘ืึทืงื•ืžืขืŸ ื ืึธืš 3 ื™ืึธืจ ืคื•ืŸ ืขืงืกื˜ืขื ื“ืขื“ ืฉื˜ื™ืฆืŸ. ืึทืŸ LTS ืžืขืœื“ื•ื ื’ ืคื•ืŸ MySQL 2024 ืื™ื– ื’ืขืจื™ื›ื˜ ืื™ืŸ ืคืจื™ืœื™ื ื’ ืคื•ืŸ 8.4, ื ืึธืš ื•ื•ืึธืก ืึท ื ื™ื™ึท ื™ื ื ืึธื•ื•ืึทื˜ื™ืึธืŸ ืฆื•ื•ื™ื™ึทื’ 9.0 ื•ื•ืขื˜ ื–ื™ื™ืŸ ื’ืขืฉืืคืŸ.

ื”ื•ื™ืคึผื˜ ืขื ื“ืขืจื•ื ื’ืขืŸ ืื™ืŸ MySQL 8.3:

  • 25 ื•ื•ืึทืœื ืขืจืึทื‘ื™ืœื™ื˜ื™ื– ื–ืขื ืขืŸ ืคืึทืจืคืขืกื˜ื™ืงื˜, ืคื•ืŸ ื•ื•ืึธืก ืื™ื™ื ืขืจ (CVE-2023-5363, ืึทืคืขืงื˜ื™ื ื’ OpenSSL) ืงืขื ืขืŸ ื–ื™ื™ืŸ ืจื™ืžืึธื•ื˜ืœื™ ืขืงืกืคึผืœื•ื™ื˜ืึทื“. ื“ื™ ืžืขืจืกื˜ ืฉื˜ืจืขื ื’ ืคึผืจืึธื‘ืœืขื ืžื™ื˜ ื“ื™ ื ื•ืฆืŸ ืคื•ืŸ ื“ื™ Kerberos ืคึผืจืึธื˜ืึธืงืึธืœ ืื™ื– ืึทืกื™ื™ื ื“ ืึท ืฉื˜ืจืขื ื’ืงื™ื™ึทื˜ ืžื“ืจื’ื” ืคื•ืŸ 8.8. ื•ื•ื™ื™ื ื™ืงืขืจ ืฉื˜ืจืขื ื’ ื•ื•ืึทืœื ืขืจืึทื‘ื™ืœื™ื˜ื™ื– ืžื™ื˜ ืฉื˜ืจืขื ื’ืงื™ื™ึทื˜ ืžื“ืจื’ื” 6.5 ื•ื•ื™ืจืงืŸ ื“ื™ ืึธืคึผื˜ื™ืžื™ื–ืขืจ, UDF, DDL, DML, ืจืขืคึผืœืึทืงื™ื™ืฉืึทืŸ, ืคึผืจื™ื•ื•ื™ืœืขื’ื™ืข ืกื™ืกื˜ืขื ืื•ืŸ ืขื ืงืจื™ืคึผืฉืึทืŸ ืžื›ืฉื™ืจื™ื.
  • ืื•ื™ืฃ ื“ื™ ืœื™ื ื•ืงืก ืคึผืœืึทื˜ืคืึธืจืžืข, ืฉื˜ื™ืฆืŸ ืคึฟืึทืจ ื“ื™ ืคื•ืจืขื ืœื™ื ืงืขืจ ืื™ื– ืฆื•ื’ืขื’ืขื‘ืŸ. ืฆื• ื’ืขื‘ืŸ ืขืก, ื“ื™ ืึธืคึผืฆื™ืข "-DWITH_LD=mold|lld" ืื™ื– ืฆื•ื’ืขืฉื˜ืขืœื˜.
  • ื“ื™ ืจืขืงื•ื•ื™ืจืขืžืขื ืฅ ืคึฟืึทืจ ื“ื™ C ++ ื ืึธืจืžืึทืœ ื’ืขืฉื˜ื™ืฆื˜ ื“ื•ืจืš ื“ื™ ืงืึทืžืคึผื™ื™ืœืขืจ ื–ืขื ืขืŸ ืื•ื™ืคื’ืขืฉื˜ืื ืขืŸ ืคื•ืŸ C ++ 17 ืฆื• C ++ 20.
  • ืฉื˜ื™ืฆืŸ ืคึฟืึทืจ ื‘ื ื™ืŸ ืžื™ื˜ ืคื•ื ื“ืจื•ื™ืกื ื“ื™ืง ื‘ืึธืึธืกื˜ C ++ ืœื™ื™ื‘ืจืขืจื™ื– ืื™ื– ืึธืคึผื’ืขืฉื˜ืขืœื˜ - ื‘ืœื•ื™ื– ื“ื™ ื’ืขื‘ื•ื™ื˜-ืื™ืŸ ื‘ืึธืึธืกื˜ ืœื™ื™ื‘ืจืขืจื™ื– ื–ืขื ืขืŸ ืื™ืฆื˜ ื’ืขื ื™ืฆื˜ ื•ื•ืขืŸ ืงืึทืžืคึผื™ื™ืœื™ื ื’ MySQL. CMake ื”ืื˜ ืึทื•ื•ืขืงื’ืขื ื•ืžืขืŸ ื“ื™ WITH_BOOST, DOWNLOAD_BOOST ืื•ืŸ DOWNLOAD_BOOST_TIMEOUT ื‘ื•ื™ืขืŸ ืึธืคึผืฆื™ืขืก.
  • ืฉื˜ื™ืฆืŸ ืคึฟืึทืจ ื‘ื ื™ืŸ ืื™ืŸ ื•ื•ื™ืกื•ืึทืœ ืกื˜ื•ื“ื™ืึธ 2022 ืื™ื– ืึธืคึผื’ืขืฉื˜ืขืœื˜.
  • MySQL Enterprise Edition ื”ืื˜ ืฆื•ื’ืขืœื™ื™ื’ื˜ ืฉื˜ื™ืฆืŸ ืคึฟืึทืจ ืงืึทืœืขืงื˜ื™ื ื’ ื˜ืขืœืขืžืขื˜ืจื™ ืžื™ื˜ ืžืขื˜ืจื™ืงืก ื•ื•ืขื’ืŸ ืกืขืจื•ื•ืขืจ ืึธืคึผืขืจืึทืฆื™ืข ืื™ืŸ ื“ื™ OpenTelemetry ืคึฟืึธืจืžืึทื˜ ืื•ืŸ ื˜ืจืึทื ืกืคืขืจื™ื ื’ ื“ืึทื˜ืŸ ืฆื• ืึท ื ืขืฅ ืคึผืจืึทืกืขืกืขืจ ื•ื•ืึธืก ืฉื˜ื™ืฆื˜ ื“ืขื ืคึฟืึธืจืžืึทื˜.
  • ื“ื™ GTID (ื’ืœืื‘ืืœืข ื˜ืจืึทื ืกืึทืงื˜ื™ืึธืŸ ื™ื“ืขื ื˜ื™ืคื™ืขืจ) ืคึฟืึธืจืžืึทื˜, ื’ืขื ื™ืฆื˜ ื‘ืขืฉืึทืก ืจืขืคึผืœืึทืงื™ื™ืฉืึทืŸ ืฆื• ื™ื“ืขื ื˜ื™ืคื™ืฆื™ืจืŸ ื˜ืจืึทื ืกืึทืงื˜ื™ืึธืŸ ื’ืจื•ืคึผืขืก, ืื™ื– ื™ืงืกืคึผืึทื ื“ื™ื“. ื“ื™ ื ื™ื™ึทืข GTID ืคึฟืึธืจืžืึทื˜ ืื™ื– "UUID: : NUMBER" (ืึทื ืฉื˜ืึธื˜ ืคื•ืŸ "UUID: NUMBER"), ื•ื•ื• TAG ืื™ื– ืึทืŸ ืึทืจื‘ื™ื˜ืจืึทืจื™ืฉ ืฉื˜ืจื™ืงืœ ื•ื•ืึธืก ืึทืœืึทื•ื– ืื™ืจ ืฆื• ื‘ืึทืฉื˜ื™ืžืขืŸ ื™ื™ื ืฆื™ืง ื ืขืžืขืŸ ืฆื• ืึท ืกืคึผืขืฆื™ืคื™ืฉ ื’ืจื•ืคึผืข ืคื•ืŸ โ€‹โ€‹ื˜ืจืึทื ื–ืึทืงืฉืึทื ื– ืคึฟืึทืจ ื’ืจื™ื ื’ืขืจ ืคึผืจืึทืกืขืกื™ื ื’ ืื•ืŸ ืคึผืึทืจืกื™ื ื’.
  • ืฆื•ื’ืขืœื™ื™ื’ื˜ ืฆื•ื•ื™ื™ ื ื™ื™ึทืข ื•ื•ืขืจื™ืึทื‘ืึทืœื– "Deprecated_use_i_s_processlist_count" ืื•ืŸ "Deprecated_use_i_s_processlist_last_timestamp" ืฆื• ืฉืคึผื•ืจ ื‘ืึทื ื™ืฅ ืคื•ืŸ ื“ื™ ื“ื™ืคึผืจื™ืฉื™ื™ื™ื˜ื™ื“ INFORMATION_SCHEMA.PROCESSLIST ื˜ื™ืฉ.
  • ื‘ืึทืฉื˜ืขื˜ื™ืงืŸ ื“ื™ AUTHENTICATION_PAM_LOG ืกื•ื•ื™ื•ื•ืข ื‘ื™ื™ึทื˜ืขื•ื•ื“ื™ืง ื ื™ื˜ ืžืขืจ ื– ืคึผืึทืกื•ื•ืขืจื“ื– ืฆื• ื–ื™ื™ืŸ ื’ืขื•ื•ื™ื–ืŸ ืื™ืŸ ื“ื™ืึทื’ื ืึธืกื˜ื™ืง ืึทืจื˜ื™ืงืœืขืŸ (ื“ื™ ื•ื•ืขืจื˜ ืคื•ืŸ PAM_LOG_WITH_SECRET_INFO ืื™ื– ืคืืจืœืื ื’ื˜ ืฆื• ื“ืขืจืžืึธื ืขืŸ ืึท ืคึผืึทืจืึธืœ).
  • ืฆื•ื’ืขื’ืขื‘ืŸ tp_connections ื˜ื™ืฉ ืžื™ื˜ ืื™ื ืคึฟืึธืจืžืึทืฆื™ืข ื•ื•ืขื’ืŸ ื™ืขื“ืขืจ ืงืฉืจ ืื™ืŸ ื“ื™ ืคืึธื“ืขื ื‘ืขืงืŸ.
  • ืฆื•ื’ืขืœื™ื™ื’ื˜ ืกื™ืกื˜ืขื ื‘ื™ื™ึทื˜ืขื•ื•ื“ื™ืง "explain_json_format_version" ืฆื• ืื•ื™ืกืงืœื™ื™ึทื‘ืŸ ื“ื™ JSON ืคึฟืึธืจืžืึทื˜ ื•ื•ืขืจืกื™ืข ื’ืขื ื™ืฆื˜ ืื™ืŸ "EXPLAIN FORMAT = JSON" ืกื˜ื™ื™ื˜ืžืึทื ืฅ.
  • ืื™ืŸ InnoDB ืกื˜ืึธืจื™ื“ื–ืฉ, ื“ื™ "--innodb" ืื•ืŸ "--skip-innodb" ืึธืคึผืฆื™ืขืก, ื•ื•ืึธืก ื–ืขื ืขืŸ ื“ื™ืคึผืจื™ืฉื™ื™ื™ื˜ื™ื“ ืื™ืŸ ื“ื™ MySQL 5.6 ืžืขืœื“ื•ื ื’, ื–ืขื ืขืŸ ืึทื•ื•ืขืงื’ืขื ื•ืžืขืŸ. ื“ื™ ืžืขืžืงืึทื˜ืฉืขื“ ืคึผืœื•ื’ื™ืŸ ืคึฟืึทืจ InnoDB, ื•ื•ืึธืก ืื™ื– ื’ืขื•ื•ืขืŸ ื“ื™ืคึผืจื™ืฉื™ื™ื™ื˜ื™ื“ ืื™ืŸ MySQL 8.0.22, ืื™ื– ืึทื•ื•ืขืงื’ืขื ื•ืžืขืŸ.
  • ืึทื•ื•ืขืงื’ืขื ื•ืžืขืŸ ืขื˜ืœืขื›ืข ืจืขืคึผืœืึทืงื™ื™ืฉืึทืŸ ืคึฟืึทืจื‘ื•ื ื“ืขื ืข ืกืขื˜ื˜ื™ื ื’ืก ืื•ืŸ ื‘ืึทืคึฟืขืœืŸ ืฉื•ืจื” ืึธืคึผืฆื™ืขืก ื•ื•ืึธืก ื–ืขื ืขืŸ ื“ื™ืคึผืจื™ืฉื™ื™ื™ื˜ื™ื“ ืื™ืŸ ืคืจื™ืขืจื“ื™ืงืŸ ืจื™ืœื™ืกื™ื–: "--slave-rows-search-algorithms", "--relay-log-info-file", "-relay-log-info-repository" ", "-ืžืึทืกื˜ืขืจ-ืื™ื ืคึฟืึธืจืžืึทืฆื™ืข-ื˜ืขืงืข", "-ืžืึทืกื˜ืขืจ-ืื™ื ืคึฟืึธืจืžืึทืฆื™ืข-ืจื™ืคึผืึทื–ืึทื˜ืึธืจื™", "ืœืึธื’_ื‘ื™ืŸ_ื ื•ืฆืข_ื•ื•1_ืขื•ื•ืขื ื˜ืก", "ื˜ืจืึทื ืกืึทืงื˜ื™ืึธืŸ_ืฉืจื™ื™ื‘ืŸ_ืกืขื˜_ืขืงืกื˜ืจืึทืงื˜ื™ืึธืŸ", "ื’ืจื•ืคึผืข_ืจืขืคึผืœื™ืงืึทื˜ื™ืึธืŸ_ื™ืคึผ_ื•ื•ื™ื™ื˜ืขืœื™ืกื˜", "ื’ืจื•ืคึผืข_ืจืขืคึผืœื™ืงืึทื˜ื™ืึธืŸ_ืคึผืจื™ืžืขืจื™_ืžื™ื˜ื’ืœื™ื“". ื“ื™ ืคื™ื™ื™ืงื™ื™ื˜ ืฆื• ื ื•ืฆืŸ ื“ื™ IGNORE_SERVER_IDS ืึธืคึผืฆื™ืข ืžื™ื˜ GTID ืจืขืคึผืœืึทืงื™ื™ืฉืึทืŸ ืžืึธื“ืข (gtid_mode = ON) ืื™ื– ืึทื•ื•ืขืงื’ืขื ื•ืžืขืŸ.
  • ืฉื˜ื™ืฆืŸ ืคึฟืึทืจ C API ืคืึทื ื’ืงืฉืึทื ื– ืื™ื– ืึธืคึผื’ืขืฉื˜ืขืœื˜: mysql_kill(), mysql_list_fields(), mysql_list_processes(), mysql_refresh(), mysql_reload(), mysql_shutdown(), mysql_ssl_set().
  • ื“ืขืจ ืื•ื™ืกื“ืจื•ืง "FLUSH HOSTS", ื•ื•ืึธืก ืื™ื– ื’ืขื•ื•ืขืŸ ื“ื™ืคึผืจื™ืฉื™ื™ื™ื˜ื™ื“ ืื™ืŸ MySQL 8.0.23, ืื™ื– ื“ื™ืกืงืึทื ื˜ื™ื ื™ื•ื“.

ืžืงื•ืจ: opennet.ru

ืœื™ื™ื’ืŸ ืึท ื‘ืึทืžืขืจืงื•ื ื’