{"id":120215,"date":"2024-10-17T19:09:08","date_gmt":"2024-10-17T17:09:08","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/vypusk-subd-mysql-9-1-0"},"modified":"2024-10-17T19:09:08","modified_gmt":"2024-10-17T17:09:08","slug":"vypusk-subd-mysql-9-1-0","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sq\/blog\/news\/vypusk-subd-mysql-9-1-0","title":{"rendered":"Dalja e DBMS MySQL 9.1.0","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"
Kompania Oracle ka formuar nj\u00eb deg\u00eb t\u00eb re t\u00eb DBMS MySQL 9.1.0. Nd\u00ebrmarrjet MySQL Community Server 9.1.0 jan\u00eb p\u00ebrgatitur p\u00ebr t\u00eb gjith\u00eb distribucionet kryesore t\u00eb Linux, FreeBSD, macOS dhe Windows. N\u00eb kuad\u00ebr t\u00eb modelit t\u00eb ri t\u00eb lansimit t\u00eb p\u00ebrvijuar vitin e kaluar, MySQL 9.1 \u00ebsht\u00eb klasifikuar n\u00eb deg\u00ebt \"Innovation\", n\u00eb t\u00eb cilat do t\u00eb p\u00ebrfshihet gjithashtu l\u00ebshimi i r\u00ebnd\u00ebsish\u00ebm i ardhsh\u00ebm MySQL 9.2. Deg\u00ebt Innovation rekomandohen p\u00ebr ata q\u00eb d\u00ebshirojn\u00eb t\u00eb ken\u00eb qasje m\u00eb her\u00ebt n\u00eb funksionalitetin e ri, publikohen \u00e7do 3 muaj dhe mb\u00ebshteten vet\u00ebm deri n\u00eb publikimin e l\u00ebshimit t\u00eb ardhsh\u00ebm t\u00eb r\u00ebnd\u00ebsish\u00ebm (p\u00ebr shembull, pas shfaqjes s\u00eb deg\u00ebs 9.1, mb\u00ebshtetja e deg\u00ebs 9.0 \u00ebsht\u00eb nd\u00ebrprer\u00eb). N\u00eb ver\u00ebn e vitit t\u00eb ardhsh\u00ebm planifikohet formimi i l\u00ebshimit LTS, i rekomanduar p\u00ebr zbatime q\u00eb k\u00ebrkojn\u00eb parashikueshm\u00ebri dhe ruajtjen e q\u00ebndrueshm\u00ebris\u00eb s\u00eb sjelljes p\u00ebr nj\u00eb periudh\u00eb t\u00eb gjat\u00eb. Pas deg\u00ebs LTS do t\u00eb formohet nj\u00eb deg\u00eb e re Innovation - MySQL 10.0. <\/p>\n
Ndryshimet kryesore n\u00eb MySQL 9.1: <\/p>\n
\n
Operacionit \"CREATE VIEW\" i \u00ebsht\u00eb shtuar mb\u00ebshtetje p\u00ebr shprehjen \"IF NOT EXISTS\", q\u00eb lejon krijimin e nj\u00eb pamjeje vet\u00ebm n\u00ebse nj\u00eb pamje me emrin e dh\u00ebn\u00eb nuk ekziston ende dhe shmang kthimin e nj\u00eb gabimi n\u00ebse pamja \u00ebsht\u00eb krijuar tashm\u00eb.\n
\u00cbsht\u00eb ndalur ngarkimi i trigger-\u00ebve gjat\u00eb ekzekutimit t\u00eb operacioneve q\u00eb lidhen vet\u00ebm me leximin. M\u00eb par\u00eb, trigger-\u00ebt ngarkoheshin n\u00eb \u00e7do qasje te tabela, gj\u00eb q\u00eb sillte konsum memorieje dhe ngarkes\u00eb n\u00eb CPU n\u00eb situata kur trigger-\u00ebt nuk p\u00ebrdoreshin (p\u00ebr shembull, gjat\u00eb ekzekutimit t\u00eb pyetjeve SELECT). N\u00eb MySQL 9.1, p\u00ebrpunimi dhe ngarkimi i trigger-\u00ebve jan\u00eb ndar\u00eb n\u00eb dy faza: leximi i metadata-ve t\u00eb trigger-it dhe analizimi + ekzekutimi i trigger-it. T\u00eb dh\u00ebnat e marra n\u00eb faz\u00ebn e par\u00eb ruhen nj\u00eb her\u00eb dhe m\u00eb pas p\u00ebrdoren bashk\u00ebrisht n\u00eb instanca t\u00eb ndryshme t\u00eb trigger-it. Analizimi dhe ekzekutimi i trigger-it kryhet vet\u00ebm p\u00ebr shprehje q\u00eb sjellin ndryshim t\u00eb t\u00eb dh\u00ebnave. P\u00ebrve\u00e7 k\u00ebsaj, p\u00ebr t\u00eb ulur konsumin e memories, n\u00eb vend t\u00eb alokimit statik t\u00eb buffer-\u00ebve p\u00ebr trajtimin e gabimeve n\u00eb trigger-\u00eb, \u00ebsht\u00eb b\u00ebr\u00eb kalimi n\u00eb alokim dinamik t\u00eb memories sipas nevoj\u00ebs.\n
Doli n\u00eb shfaqje nj\u00eb zgjerim i operacionit \"EXPLAIN\", n\u00eb t\u00eb cilin tani shfaqen informacionet mbi p\u00ebrdorimin e leximit me shum\u00eb diapazone (multi-range) dhe aplikimin e strategjis\u00eb s\u00eb bashkimit t\u00eb pjessh\u00ebm (semijoin), n\u00eb t\u00eb cil\u00ebn n\u00eb operacionet JOIN p\u00ebrpunohen rreshtat vet\u00ebm nga nj\u00eb tabel\u00eb.\n
Sigurohet ekzekutimi atomik i operacioneve \"CREATE DATABASE\" dhe \"DROP DATABASE\" p\u00ebr mbrojtje nga d\u00ebshtimet n\u00eb rast t\u00eb nd\u00ebrprerjes apo t\u00eb shfaqjes s\u00eb gabimeve n\u00eb nivelin e sistemit t\u00eb skedar\u00ebve gjat\u00eb ekzekutimit t\u00eb k\u00ebtyre operacioneve. P\u00ebr shembull, m\u00eb par\u00eb gjat\u00eb nd\u00ebrprerjes s\u00eb \"CREATE DATABASE\" mund t\u00eb formohej nj\u00eb struktur\u00eb e paplot\u00eb dhe jo-funksionale e magazin\u00ebs s\u00eb DB, p\u00ebr pastrimin e s\u00eb cil\u00ebs k\u00ebrkohej nd\u00ebrhyrje manuale.\n
N\u00eb procedurat e ruajtura t\u00eb shkruara n\u00eb JavaScript \u00ebsht\u00eb shtuar mb\u00ebshtetja p\u00ebr tipin VECTOR. T\u00eb dh\u00ebnat me k\u00ebt\u00eb tip tani mund t\u00eb kalohen p\u00ebrmes parametrave hyr\u00ebs dhe atyre t\u00eb kthimit.\n
\u00cbsht\u00eb shtuar mund\u00ebsia e autentikimit gjat\u00eb lidhjes me DBMS duke p\u00ebrdorur protokollin OpenID Connect.\n
Jan\u00eb eliminuar 27 cenueshm\u00ebri, m\u00eb seriozja prej t\u00eb cilave (CVE-2024-5535) \u00ebsht\u00eb klasifikuar me nivel kritik rreziku (9.1 nga 10). Cenueshm\u00ebria mund t\u00eb shfryt\u00ebzohet nga distanca pa kaluar autentikimin. Problemi shkaktohet nga leximi i t\u00eb dh\u00ebnave jasht\u00eb zon\u00ebs s\u00eb buffer-it t\u00eb alokuar n\u00eb bibliotek\u00ebn OpenSSL dhe \u00e7on n\u00eb p\u00ebrfundim avarie ose rrjedhje t\u00eb p\u00ebrmbajtjes s\u00eb memories n\u00eb p\u00ebrgjigje pas lidhjes me server<\/a> me specifikimin e parametrave t\u00eb pasakt\u00eb t\u00eb protokollit. <\/ul>\n