Oracle ya ƙirƙiri sabon reshe na MySQL 9.1.0 DBMS. MySQL Community Server 9.1.0 yana gina ginin don duk manyan Linux, FreeBSD, macOS da rarrabawar Windows. A matsayin wani ɓangare na sabon samfurin sakin da aka gabatar a bara, MySQL 9.1 an ware shi azaman reshe na "Innovation", wanda kuma zai haɗa da babban saki na gaba, MySQL 9.2. Ana ba da shawarar rassan innovation ga waɗanda ke son samun damar zuwa sabon aiki da wuri, ana buga su kowane watanni 3 kuma ana tallafawa kawai har sai an buga babban sakin na gaba (alal misali, bayan bayyanar reshe na 9.1, an dakatar da tallafi ga reshen 9.0. ). Lokacin rani na gaba suna shirin ƙirƙirar sakin LTS, wanda aka ba da shawarar don aiwatarwa waɗanda ke buƙatar tsinkaya da adana dogon lokaci na halayen da ba su canza ba. Bayan reshen LTS, za a kafa sabon reshen Innovation - MySQL 10.0.
Babban canje-canje a cikin MySQL 9.1:
- An ƙara goyon bayan kalmar "IF BA EXISTS" a cikin aikin "CREATE VIEW", wanda ke ba ku damar tsara ƙirƙirar ra'ayi kawai idan ra'ayi tare da sunan da aka ƙayyade ba ya wanzu kuma ku guje wa mayar da kuskure idan ra'ayi an riga an halicce shi.
- Dakatar da abubuwan motsa jiki lokacin yin ayyukan karantawa kawai. A baya can, ana ɗora abubuwan faɗakarwa a duk lokacin da aka shiga tebur, ɓata ƙwaƙwalwar ajiya da ƙirƙirar nauyin CPU a cikin yanayin da ba a amfani da abubuwan jan hankali (misali, lokacin aiwatar da tambayoyin SELECT). A cikin MySQL 9.1, sarrafawa da ɗora abubuwan faɗakarwa sun kasu kashi biyu: karanta metadata game da faɗakarwa da rarrabawa + aiwatar da faɗakarwa. Bayanan da aka samu a mataki na farko ana adana su sau ɗaya sannan a raba su a wurare daban-daban. Ana karkatar da faɗakarwa kuma ana aiwatar da shi don maganganun da ke canza bayanai kawai. Bugu da kari, don rage yawan amfani da ƙwaƙwalwar ajiya, maimakon a keɓance maɓalli don sarrafa kurakurai a cikin abubuwan faɗakarwa, mun canza zuwa ƙayyadaddun ƙwaƙwalwar ajiya mai ƙarfi kamar yadda ake buƙata.
- An faɗaɗa fitowar aikin EXPLAIN don nuna bayanai game da amfani da karatu mai yawa da kuma amfani da dabarun haɗin gwiwa, wanda JOIN ayyukan ke aiwatar da layuka daga tebur ɗaya kawai.
- Ana aiwatar da aiwatar da tsarin atomatik na ayyukan "CREATE DATABASE" da "DROP DATABASE" don kare kariya daga lalacewa a yayin da ya faru ko kuskure a matakin tsarin fayil yayin aiwatar da waɗannan ayyukan. Misali, a baya, lokacin da “CREATE DATABASE” ta fado, ana iya ƙirƙirar tsarin ma'ajin bayanan da bai cika aiki ba, wanda ke buƙatar sa hannun hannu don tsaftacewa.
- Hanyoyin da aka adana da aka rubuta a cikin JavaScript suna ba da tallafi ga nau'in VECTOR. Ana iya shigar da bayanai tare da takamaiman nau'in yanzu a cikin shigarwa da sigogin dawowa.
- An ƙara ikon tantancewa lokacin haɗi zuwa DBMS ta amfani da ka'idar Haɗin OpenID.
- An gyara raunin da ya shafi guda ashirin da bakwai, mafi tsanani daga cikinsu (CVE-2024-5535) an sanya shi matakin tsanani (9.1 cikin 10). Ana iya amfani da raunin daga nesa ba tare da tantancewa ba. Matsalar ta samo asali ne daga karantawar da ba ta da iyaka a cikin ɗakin karatu na OpenSSL kuma tana haifar da faɗuwa ko zubewar ƙwaƙwalwa a cikin martanin bayan haɗawa zuwa uwar garken tare da nuna kuskuren sigogin yarjejeniya.
source: budenet.ru
