ProHoster > Π‘Π»ΠΎΠ³ > xov xwm hauv internet > MySQL 8.3.0 DBMS muaj

MySQL 8.3.0 DBMS muaj

Oracle tau tsim ib ceg tshiab ntawm MySQL 8.3 DBMS thiab luam tawm qhov hloov kho tshiab rau MySQL 8.0.36. MySQL Community Server 8.3.0 tsim yog npaj rau txhua qhov loj Linux, FreeBSD, macOS thiab Windows faib.

MySQL 8.3.0 yog qhov thib peb tso tawm raws li tus qauv tso tawm tshiab, uas muab rau muaj ob hom MySQL ceg - "Innovation" thiab "LTS". Cov ceg tsim kho tshiab, uas suav nrog MySQL 8.1, 8.2 thiab 8.3, tau pom zoo rau cov neeg uas xav nkag mus rau kev ua haujlwm tshiab ua ntej. Cov ceg ntoo no tau tshaj tawm txhua 3 lub hlis thiab tau txais kev txhawb nqa tsuas yog kom txog thaum qhov kev tso tawm loj tom ntej no tau tshaj tawm (piv txwv li, tom qab lub ntsej muag ntawm 8.3 ceg, kev txhawb nqa rau 8.2 ceg tau txiav tawm). LTS ceg tau pom zoo rau kev siv uas xav tau kev kwv yees thiab kev khaws cia ntev ntawm tus cwj pwm tsis hloov. LTS ceg yuav raug tso tawm txhua ob xyoos thiab yuav tau txais kev txhawb nqa ib txwm rau 5 xyoos, ntxiv rau qhov koj tuaj yeem tau txais lwm 3 xyoos ntawm kev txhawb nqa txuas ntxiv. Ib qho LTS tso tawm ntawm MySQL 2024 yuav tsum nyob rau lub caij nplooj ntoo hlav xyoo 8.4, tom qab ntawd yuav tsim ib ceg tshiab Innovation 9.0.

Cov kev hloov loj hauv MySQL 8.3:

  • 25 qhov tsis zoo tau raug kho, ntawm qhov twg ib qho (CVE-2023-5363, cuam tshuam rau OpenSSL) tuaj yeem siv tau nyob deb. Qhov teeb meem loj tshaj plaws uas cuam tshuam txog kev siv Kerberos raws tu qauv yog muab qhov hnyav ntawm 8.8. Tsawg qhov tsis zoo nrog qhov hnyav 6.5 cuam tshuam rau qhov optimizer, UDF, DDL, DML, replication, txoj cai, thiab cov cuab yeej encryption.
  • Ntawm Linux platform, kev txhawb nqa rau pwm linker tau ntxiv. Txhawm rau pab nws, qhov kev xaiv "-DWITH_LD = mold|lld" yog muab.
  • Cov kev cai rau C ++ tus qauv txhawb nqa los ntawm lub compiler tau raug tsa los ntawm C ++ 17 rau C ++ 20.
  • Kev them nyiaj yug rau lub tsev nrog lwm Boost C ++ cov tsev qiv ntawv tau raug txiav tawm - tsuas yog cov tsev qiv ntawv Boost built-in tam sim no siv thaum sau MySQL. CMake tau tshem tawm WITH_BOOST, DOWNLOAD_BOOST thiab DOWNLOAD_BOOST_TIMEOUT tsim kev xaiv.
  • Tsim kev txhawb nqa rau Visual Studio 2022 tau raug txiav tawm. Qhov tsawg kawg nkaus txhawb nqa ntawm Clang toolkit tau raug tsa los ntawm Clang 10 mus rau Clang 12.
  • MySQL Enterprise Edition tau ntxiv kev txhawb nqa rau kev sau telemetry nrog kev ntsuas txog kev ua haujlwm server hauv OpenTelemetry hom thiab hloov cov ntaub ntawv mus rau lub network processor uas txhawb nqa hom ntawv no.
  • Daim ntawv GTID (tus neeg txheeb xyuas kev lag luam thoob ntiaj teb) ​​tus qauv, siv thaum lub sijhawm rov ua dua los txheeb xyuas pawg kev lag luam, tau nthuav dav. Tshiab GTID hom - "UUID: : NUMBER" (es tsis yog "UUID: NUMBER"), qhov twg TAG yog ib txoj hlua arbitrary uas tso cai rau koj los muab cov npe tshwj xeeb rau ib pab pawg tshwj xeeb ntawm kev ua lag luam kom yooj yim ua thiab parsing.
  • Ntxiv ob qhov hloov pauv tshiab "Deprecated_use_i_s_processlist_count" thiab "Deprecated_use_i_s_processlist_last_timestamp" txhawm rau taug qab kev siv cov lus tsis txaus siab INFORMATION_SCHEMA.PROCESSLIST.
  • Kev teeb tsa AUTHENTICATION_PAM_LOG ib puag ncig hloov pauv tsis ua rau cov passwords tso tawm hauv cov lus kuaj mob ntxiv lawm (tus nqi PAM_LOG_WITH_SECRET_INFO yuav tsum hais txog tus password).
  • Ntxiv tp_connections rooj nrog cov ntaub ntawv hais txog txhua qhov kev sib txuas hauv cov xov pas dej.
  • Ntxiv cov kab ke sib txawv "explain_json_format_version" los xaiv JSON hom qauv siv hauv "EXPLAIN FORMAT = JSON" nqe lus.
  • Hauv InnoDB cia, cov kev xaiv "--innodb" thiab "--skip-innodb", uas tau deprecated hauv MySQL 5.6 tso tawm, tau raug tshem tawm. Lub memcached plugin rau InnoDB, uas tau deprecated hauv MySQL 8.0.22, tau raug tshem tawm.
  • Tshem tawm qee qhov kev teeb tsa ntsig txog kev rov ua dua thiab cov kev xaiv kab hais kom ua uas tau tso tseg hauv kev tshaj tawm dhau los: "--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". Lub peev xwm los siv IGNORE_SERVER_IDS kev xaiv nrog GTID replication hom (gtid_mode=ON) tau raug tshem tawm.
  • Kev them nyiaj yug rau C API cov haujlwm tau raug txiav tawm: mysql_kill(), mysql_list_fields(), mysql_list_processes(), mysql_refresh(), mysql_reload(), mysql_shutdown(), mysql_ssl_set().
  • Qhov "FLUSH HOSTS" qhia, uas tau tso tseg hauv MySQL 8.0.23, tau raug txiav lawm.

Tau qhov twg los: opennet.ru

Ntxiv ib saib