Kua tukuna e Oracle tētahi peka hou o te pūnaha whakahaere pātengi raraunga MySQL 9.1.0. Kei te wātea ngā hanganga MySQL Community Server 9.1.0 mō ngā tohatoha Linux nui katoa, FreeBSD, macOS, me Windows. Hei wāhanga o te tauira tuku hou i whakaurua i te tau kua hipa, kua tohaina a MySQL 9.1 ki ngā peka "Auahatanga", ka uru atu hoki ki roto ko te tuku nui e whai ake nei, ko MySQL 9.2. E taunakihia ana ngā peka Auahatanga mō te hunga e hiahia ana ki te urunga wawe ki ngā mahi hou. Ka whakaputaina ēnei i ia toru marama, ā, ka tautokona kia tae noa ki te tuku nui e whai ake nei (hei tauira, i muri i te tukunga o te peka 9.1, kua mutu te tautoko mō te peka 9.0). Kua whakaritea he tukunga LTS mō te raumati e whai ake nei, e taunakihia ana mō ngā whakatinanatanga e hiahia ana kia matapaetia me te pumau mō te wā roa. Whai muri i te peka LTS, ka tukuna he peka Auahatanga hou—MySQL 10.0.
Nga huringa nui i roto i te MySQL 9.1:
- Kei te tautokona inaianei e te mahi CREATE VIEW te kīanga IF NOT EXISTS, e āhei ai koe ki te waihanga i tētahi tirohanga mēnā kāore anō kia tīariari tētahi tirohanga me te ingoa kua tohua, ā, ka karohia hoki te whakahoki mai i tētahi hapa mēnā kua waihangatia kētia te tirohanga.
- Kua mutu te utaina o ngā whakaoho i ngā wā e mahi ana te pānui-anake. I mua, i utaina ngā whakaoho i ngā wā katoa e uru atu ai ki tētahi ripanga, ā, i hua ake ai te whakapaunga mahara me te kawenga CPU i ngā wā kāore i whakamahia ngā whakaoho (hei tauira, i te wā e whakahaere ana i ngā patai SELECT). I roto i te MySQL 9.1, ka wehea te tukatuka me te utaina o ngā whakaoho kia rua ngā wāhanga: te pānui i ngā raraunga whakaoho me te wetewete me te whakahaere i te whakaoho. Ko ngā raraunga i whiwhihia i te wāhanga tuatahi ka rongoatia kotahi, kātahi ka tohaina puta noa i ngā tauira whakaoho maha. Ka mahia te wetewete me te whakahaere i ngā whakaoho mō ngā tauākī anake e whakarerekē ana i ngā raraunga. Hei tāpiri, hei whakaiti i te whakapaunga mahara, kua whakakapia te tohatoha pūmau o ngā arai mō te whakahaere hapa i roto i ngā whakaoho e te tohatoha mahara hihiri i runga i te kaupapa e hiahiatia ana.
- Kua whakawhānuihia te putanga EXPLAIN kia uru atu ai ngā mōhiohio e pā ana ki te whakamahinga o ngā pānui maha-awhe me te whakamahinga o te rautaki haurua-hono, e tukatuka ana i ngā rarangi mai i te ripanga kotahi anake i te wā o ngā mahi JOIN.
- Kua whakaritea te whakahaerenga atomika o ngā mahi "CREATE DATABASE" me te "DROP DATABASE" hei tiaki i ngā hapa mēnā ka puta he whakamutu rerekē, he hapa pūnaha kōnae rānei i roto i ēnei mahi. Hei tauira, i mua, ko te whakamutu rerekē o te "CREATE DATABASE" ka hua ake he hanganga rokiroki pātengi raraunga kāore i oti, kāore e mahi, me te hiahia kia wawao ā-ringa hei horoi.
- Kei te wātea inaianei te tautoko mō te momo VECTOR i roto i ngā tukanga JavaScript kua rongoatia. Ka taea te tuku raraunga o tēnei momo i roto i ngā tawhā whakauru me ngā tawhā whakahoki.
- Kua tāpirihia te āheinga ki te manatoko ina hono atu ki tētahi DBMS mā te whakamahi i te kawa OpenID Connect.
- E rua tekau mā whitu ngā ngoikoretanga kua whakatikahia, ko te mea tino kino rawa atu (CVE-2024-5535) kua tohua ki te taumata kino (9.1 i roto i te 10). Ka taea te whakamahi i te ngoikoretanga mai i tawhiti me te kore manatoko. Ko te take o te raruraru he pānui i waho o ngā rohe i roto i te whare pukapuka OpenSSL, ā, ka arahi ki te tukinga, ki te turuturu mahara rānei i roto i te urupare i muri i te hono atu ki. tūmau me te tohu i ngā tawhā kawa hē.
Source: opennet.ru
