I-Oracle yenze isebe elitsha le-MySQL 8.3 DBMS kwaye yapapasha uhlaziyo lokulungisa kwi-MySQL 8.0.36. Ukwakhiwa kwe-MySQL Community Server 8.3.0 kulungiselelwe zonke ii-Linux ezinkulu, i-FreeBSD, i-macOS kunye nokuhanjiswa kweWindows.
I-MySQL 8.3.0 yinto yesithathu yokukhululwa eyenziwe phantsi kwemodeli entsha yokukhupha, ebonelela ngobukho beentlobo ezimbini zamasebe e-MySQL - "Innovation" kunye ne "LTS". Amasebe e-Innovation, aquka i-MySQL 8.1, 8.2 kunye ne-8.3, acetyiswa kwabo bafuna ukufikelela ekusebenzeni okutsha kwangaphambili. La masebe apapashwa rhoqo kwiinyanga ezi-3 kwaye axhaswa kuphela de kube kupapashwa ukukhululwa okukhulu okulandelayo (umzekelo, emva kokubonakala kwesebe le-8.3, ukuxhaswa kwesebe le-8.2 kwanqanyulwa). Amasebe e-LTS ayacetyiswa ukuba aphunyezwe afuna uqikelelo kunye nokuzingisa kwexesha elide lokuziphatha okungaguqukanga. Amasebe e-LTS aya kukhutshwa rhoqo emva kweminyaka emibini kwaye aya kuxhaswa ngokwesiqhelo iminyaka emi-5, ukongeza apho unokufumana eminye iminyaka emi-3 yenkxaso eyandisiweyo. Ukukhutshwa kwe-LTS ye-MySQL 2024 kulindeleke entwasahlobo ka-8.4, emva koko isebe elitsha le-Innovation 9.0 liya kwenziwa.
Utshintsho olukhulu kwi-MySQL 8.3:
- Ubuthathaka obungama-25 bulungisiwe, apho enye (CVE-2023-5363, echaphazela i-OpenSSL) inokusetyenziswa kude. Umcimbi onzima kakhulu onxulumene nokusetyenziswa kwe-Kerberos protocol unikwe inqanaba lobunzima be-8.8. Ubuthathaka obuncinci obunobunzima obunenqanaba lobunzima be-6.5 buchaphazela i-optimizer, i-UDF, i-DDL, i-DML, ukuphindaphinda, inkqubo yelungelo, kunye nezixhobo zokufihla.
- Kwiqonga le-Linux, inkxaso ye-mold linker yongeziwe. Ukuze usebenze, ukhetho "-DWITH_LD=mold|lld" lunikiwe.
- Iimfuno zomgangatho we-C ++ oxhaswa ngumqokeleli ziphakanyiswe ukusuka kwi-C ++ 17 ukuya kwi-C ++20.
- Inkxaso yokwakha ngamathala eencwadi e-Boost C++ yangaphandle iye yanqunyanyiswa - kuphela ngamathala eencwadi e-Boost eyakhelwe-ngaphakathi asetyenziswa ngoku xa kuqulunqwa iMySQL. I-CMake ilususile ukhetho lolwakhiwo lwe-WITH_BOOST, DOWNLOAD_BOOST kunye no-DOWNLOAD_BOOST_TIMEOUT.
- Inkxaso yolwakhiwo kwi-Visual Studio 2022 iye yanqunyanyiswa. Olona guqulelo luncinci lwenkxaso yeClang toolkit luphakanyiswe ukusuka kuClang 10 ukuya kuClang 12.
- I-MySQL Enterprise Edition yongeze inkxaso yokuqokelela i-telemetry kunye neemetrics malunga nokusebenza kweseva kwifomathi ye-OpenTelemetry kunye nokudlulisa idatha kwiprosesa yenethiwekhi exhasa le fomati.
- I-GTID (i-global transaction identifier) ifomathi, esetyenziswa ngexesha lokuphindaphinda ukuchonga amaqela entengiselwano, yandisiwe. Ifomati entsha ye-GTID ithi “UUID: :NUMBER" (endaweni ka "UUID:NUMBER"), apho iTAG ingumtya ongenasizathu okuvumela ukuba unikeze amagama awodwa kwiqela elithile lentengiselwano ukuze kube lula ukuqhubekeka kunye nokwahlulahlula.
- Kongezwe izinto ezimbini ezintsha eziguquguqukayo "Deprecated_use_i_s_processlist_count" kunye "Deprecated_use_i_s_processlist_last_timestamp" ukulandelela ukusetyenziswa kwetafile INFORMATION_SCHEMA.PROCESSLIST eyehliweyo.
- Ukucwangcisa i-AUTHENTICATION_PAM_LOG ukuguquguquka kwemeko-bume akusabangela ukuba amagama ayimfihlo aboniswe kwimiyalezo yoxilongo (ixabiso le-PAM_LOG_WITH_SECRET_INFO liyafuneka ukukhankanya igama eliyimfihlo).
- Itheyibhile eyongeziweyo ye-tp_connections ngolwazi malunga noqhagamshelwano ngalunye kwi-pool pool.
- Inguqu yenkqubo eyongeziweyo "explain_json_format_version" ukukhetha uhlobo lwefomathi ye-JSON esetyenziswe kwiingxelo ze-"EXPLAIN FORMAT=JSON".
- Kwisitoreji se-InnoDB, "--innodb" kunye "--skip-innodb" iinketho, eziye zatshitshiswa kwi-MySQL 5.6 yokukhululwa, zisusiwe. I-plugin ye-memcached ye-InnoDB, ekhutshwe kwi-MySQL 8.0.22, isusiwe.
- Isuse ezinye izicwangciso ezinxulumene nophindaphindo kunye nokhetho lomgca womyalelo oluyekisiweyo kukhupho lwangaphambili: "--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". Ukukwazi ukusebenzisa i-IGNORE_SERVER_IDS ukhetho nge-GTID yemo yokuphindaphinda (gtid_mode=ON) isusiwe.
- Inkxaso yemisebenzi ye-C API iye yanqunyanyiswa: mysql_kill (), mysql_list_fields (), mysql_list_processes (), mysql_refresh (), mysql_reload (), mysql_shutdown (), mysql_ssl_set ().
- Intetho ethi "FLUSH HOSTS", eyehlisiwe kwi-MySQL 8.0.23, iyekisiwe.
umthombo: opennet.ru