I-Oracle idale igatsha elisha le-MySQL 9.2.0 DBMS. Ukwakhiwa kwe-MySQL Community Server 9.2.0 kulungiselelwe zonke i-Linux, i-FreeBSD, i-macOS ne-Windows ukusatshalaliswa okukhulu. Njengengxenye yemodeli entsha yokukhishwa eyethulwa ngo-2023, i-MySQL 9.2 ihlukaniswa njengegatsha “Lokusungula”, elizophinde lifake ukukhishwa okubalulekile okulandelayo, i-MySQL 9.3. Amagatsha okusungula anconyiwe kulabo abafuna ukufinyelela kusenesikhathi ekusebenzeni okusha, ashicilelwa njalo ezinyangeni ezi-3 futhi asekelwa kuphela kuze kube ukushicilelwa kokukhishwa okubalulekile okulandelayo (ngokwesibonelo, ngemva kokuvela kwegatsha le-9.2, ukusekelwa kwegatsha le-9.1 kuye kwamiswa. ). Ehlobo bahlela ukudala ukukhishwa kwe-LTS, okunconyelwe ukusetshenziswa okudinga ukubikezelwa kanye nokulondolozwa kwesikhathi eside kokuziphatha okungashintshiwe. Kulandela igatsha le-LTS, kuzokwakhiwa igatsha elisha le-Innovation - MySQL 10.0.
Izinguquko ezinkulu ku-MySQL 9.2:
- Injini ye-MLE (Multlingual Engine Component), ekuvumela ukuthi usebenzise ikhodi kwezinye izilimi ngaphandle kwe-SQL ezinqubweni nemisebenzi egciniwe, yengeze ukusekelwa kwemitapo yolwazi esebenziseka kabusha ku-JavaScript. Imisebenzi evela kulabhulali enjalo ingabizwa ngezinqubo ezigciniwe ze-JavaScript, kodwa kufanele imakwe ngokusobala njengengangeniseka kusetshenziswa igama elingukhiye elithi "thekelisa". Ukuze ulawule ukuxhunywa kwemitapo yolwazi ye-JavaScript, izitatimende ezintsha ze-SQL “CREATE LIBRARY” kanye nokuthi “DROP LIBRARY” zengeziwe. Inkulumo ethi “SHOW CREATE LIBRARY” yengezwe ukuze kubukwe uhlu lwemitapo yolwazi ye-JavaScript etholakalayo. Ulwazi olumayelana nemitapo yolwazi ye-JavaScript luboniswa kuthebula lesistimu elithi “LIBRARIES”, futhi ulwazi olumayelana nezinqubo ezigciniwe ezisebenzisa amalabhulali anjalo luboniswa kuthebula elithi “ROUTINE_LIBRARIES”. Ukufaka umtapo wolwazi ngenqubo egciniwe kwenziwa ngokucacisa uhlu lwemitapo yolwazi kusisho esithi “UKUSEBENZISA”.
- Kwengezwe i-API yokufinyelela izinqubo ezigciniwe, imisebenzi nokuguquguquka kweseshini kusuka kukhodi ye-JavaScript. Indlela ye-getFunction() yengeziwe ukuze ufinyelele imisebenzi ye-MySQL, futhi indlela ye-getProcedure() yengezwe ezinqubweni ezigciniwe, ezibuyisela into Yomsebenzi we-JavaScript engaqhutshwa ngokuphikisana. Okuguquguqukayo kufinyelelwa ngokuqondile njengezici zento ye-JavaScript Session. Ukwengeza, ikhono lokufinyelela ngokuqondile imisebenzi eyakhelwe ngaphakathi rand(), sleep(), uuid() kanye ne-isUUID(), efana nemisebenzi ye-SQL yegama elifanayo, yengeziwe.
- Kwengezwe i-API yokusebenza ngokuthengiselana okuvela ku-JavaScript, okukuvumela ukuthi wenze izenzo zezinkulumo eziningi ze-SQL zokusebenza ngokuthengiselana, njengokuthi "QALA UKUHLELA", "COMMIT", "ROLLBACK" kanye "SET AUTOCOMMIT".
- Kwengezwe amandla okusebenzisa i-MySQL ENUM nezinhlobo ze-SET kuma-agumenti kuzinqubo ezigciniwe ezibhalwe ku-JavaScript
- Ilungelo le-CREATE_SPATIAL_REFERENCE_SYSTEM lingeziwe, ongakwazi ngalo ukulawula ikhono lokudala nokususa izincazelo zereferensi yendawo yedatha yesistimu yolwazi lwendawo. Leli lungelo noma ELIPHEZULU manje liyadingeka ukuze kusetshenziswe UHLELO LOKUNIKEZWA KWESPATIAL, UKUDALA NOMA UBUYISE UHLELO LWESIKHATHI LWESIKHATHI, NOKWELANA izitatimende zoHLELO LWESIBONELO.
- Kwengezwe ulwazi lwenguqulo yefomethi ye-JSON kokuphumayo kokuthi "CHAZA IFOMU=JSON". Ukuze usethe inguqulo yefomethi ye-JSON, sebenzisa i- explain_json_format_version variable (“SET explain_json_format_version=1|2”).
- Kwehlisiwe: "FLUSH PRIVILEGES", "mysqladmin flush-privileges" kanye nemiyalelo ethi "mysqladmin reload", "version_tokens" plugin.
- Igama elingukhiye le-BINLOG linqanyuliwe.
- Ubuthakathaka obungu-32 bulungisiwe, obu-3 babo bungasetshenziswa ukude. Izinkinga ezimbili ezibucayi kakhulu zinezinga lokuqina elingu-9.1 futhi zihlobene nokuba sengozini ezicini ze-Kerberos ne-Curl. Ubungozi obuncane kakhulu buthinta i-InnoDB, i-Thread Pooling, i-DDL, i-optimizer, i-parser kanye nesistimu yokuqinisekisa.
Source: opennet.ru
