{"id":123615,"date":"2025-04-20T09:05:07","date_gmt":"2025-04-20T07:05:07","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/vypusk-subd-mysql-9-3-0"},"modified":"2025-04-20T09:05:07","modified_gmt":"2025-04-20T07:05:07","slug":"vypusk-subd-mysql-9-3-0","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sq\/blog\/novosti-interneta\/vypusk-subd-mysql-9-3-0","title":{"rendered":"L\u00ebshimi i DB-s\u00eb MySQL 9.3.0","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"
Compania Oracle ka formuar nj\u00eb deg\u00eb t\u00eb re t\u00eb DBMS MySQL 9.3.0. Nd\u00ebrtime t\u00eb MySQL Community Server 9.3.0 jan\u00eb p\u00ebrgatitur p\u00ebr t\u00eb gjitha distribucionet kryesore t\u00eb Linux, FreeBSD, macOS dhe Windows. N\u00eb p\u00ebrputhje me modelin e ri t\u00eb l\u00ebshimeve t\u00eb vendosur n\u00eb vitin 2023, MySQL 9.3 \u00ebsht\u00eb klasifikuar si deg\u00eb 'Innovation'. Deg\u00ebt e Innovation rekomandohen p\u00ebr ata q\u00eb duan t\u00eb ken\u00eb qasje m\u00eb her\u00ebt n\u00eb funksionalitete t\u00eb reja, 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, mb\u00ebshtetja p\u00ebr deg\u00ebn 9.2 do t\u00eb ndaloj\u00eb pas shfaqjes s\u00eb deg\u00ebs 9.3). N\u00eb ver\u00eb planifikohet krijimi i l\u00ebshimit LTS 9.4, i rekomanduar p\u00ebr implementime q\u00eb k\u00ebrkojn\u00eb parashikueshm\u00ebri dhe nj\u00eb q\u00ebndrim t\u00eb gjat\u00eb n\u00eb sjellje t\u00eb pandryshuar. Pas deg\u00ebs LTS do t\u00eb formohet nj\u00eb deg\u00eb e re Innovation \u2014 MySQL 10.0. <\/p>\n
Ndryshimet kryesore n\u00eb MySQL 9.3: <\/p>\n
\n
N\u00eb utilitarin mysqldump \u00ebsht\u00eb shtuar opsioni '--users' p\u00ebr t\u00eb krijuar dump-logjik me informacion rreth t\u00eb gjitha llogarive, q\u00eb del p\u00ebrmes shprehjeve SQL 'CREATE USER' dhe 'GRANT'. P\u00ebr t\u00eb shtuar shprehjen 'DROP USER' para 'CREATE USER' \u00ebsht\u00eb parashikuar opsioni '--add-drop-user', dhe p\u00ebr pasqyrimin selektiv n\u00eb dump t\u00eb p\u00ebrdoruesve t\u00eb ve\u00e7ant\u00eb \u2014 opsionet '--include-user=user@host' dhe '--exclude-user=user@host', q\u00eb mund t\u00eb specifikohen disa her\u00eb.\n
N\u00eb motorin MLE (Multilingual Engine Component), q\u00eb lejon p\u00ebrdorimin e kodeve n\u00eb gjuh\u00eb t\u00eb ndryshme nga SQL n\u00eb procedurat e ruajtura dhe funksionet, \u00ebsht\u00eb p\u00ebrmir\u00ebsuar mb\u00ebshtetje p\u00ebr JavaScript. P\u00ebr procedurat e ruajtura n\u00eb gjuh\u00ebn JavaScript \u00ebsht\u00eb realizuar tipi 'DECIMAL', i cili mund t\u00eb p\u00ebrdoret p\u00ebr argumentet hyr\u00ebse dhe kthimore. P\u00ebr siguri, tipi DECIMAL i MySQL t\u00eb konvertohet n\u00eb tipin 'String' t\u00eb JavaScript, por ky sjellje mund t\u00eb tejkalohet me komand\u00ebn 'SELECT mle_set_session_state('{'decimal_type': 'Number'}')', pas s\u00eb cil\u00ebs do t\u00eb p\u00ebrdoret tipi 'Number' i JavaScript. Mb\u00ebshtetet konvertimi n\u00eb tipin DECIMAL t\u00eb vlerave me tipet Boolean, Number, String dhe BigInt t\u00eb JavaScript.\n
N\u00eb procedurat e ruajtura n\u00eb JavaScript \u00ebsht\u00eb shtuar mb\u00ebshtetje p\u00ebr vendosjen e parametrave t\u00eb lokalizimit, duke p\u00ebrdorur JavaScript API Intl. P\u00ebr shembull, p\u00ebr t\u00eb p\u00ebrcaktuar lokalitetin e tanish\u00ebm mund t\u00eb p\u00ebrdoren pron\u00ebsit\u00eb 'Intl.DateTimeFormat().resolvedOptions().locale', nd\u00ebrsa p\u00ebr t\u00eb tejkaluar lokalitetin \u2014 metoda 'toLocaleString()'.\n
Jan\u00eb zgjeruar mund\u00ebsit\u00eb p\u00ebr menaxhimin e librarive JavaScript: p\u00ebr t\u00eb ndryshuar list\u00ebn e librarive t\u00eb importuara tani mund t\u00eb p\u00ebrdoren shprehjet 'ALTER PROCEDURE' dhe 'ALTER FUNCTION'. \u00ebsht\u00eb shtuar mund\u00ebsia e p\u00ebrdorimit t\u00eb shprehjes 'ALTER LIBRARY' p\u00ebr t\u00eb shtuar, hequr ose ndryshuar komentarin SQL p\u00ebr bibliotek\u00ebn. P\u00ebr t\u00eb marr\u00eb informacion mbi bibliotek\u00ebn \u00ebsht\u00eb realizuar shprehja 'SHOW LIBRARY STATUS'.\n
\u00ebsht\u00eb shtuar mb\u00ebshtetje p\u00ebr ngarkimin dinamik t\u00eb librarive JavaScript. P\u00ebr importin dinamik t\u00eb bibliotek\u00ebs duhet t\u00eb p\u00ebrdoret fjal\u00ebky\u00e7i 'await', p\u00ebr shembull 'let module = await import('\/db1\/lib_${object_type}')'.\n
Jan\u00eb zgjeruar optimizimet e k\u00ebrkesave q\u00eb p\u00ebrdorin operator\u00eb krahasues. P\u00ebrve\u00e7 mb\u00ebshtetjes s\u00eb operator\u00ebve '=ANY' dhe 'ALL' p\u00ebr optimizimin e n\u00ebnk\u00ebrkesave, n\u00eb versionin e ri \u00ebsht\u00eb shtuar mb\u00ebshtetje p\u00ebr operator\u00ebt '>ANY', '>=ANY', '<ANY', 'ALL', '>=ALL', '<ALL' dhe '<=ALL'.\n
P\u00ebrdorimi i pluginit 'version_tokens' \u00ebsht\u00eb hequr, i cili m\u00eb par\u00eb ishte shpallur i vjetruar.\n
Ndalohet vendosja e vler\u00ebs 0 n\u00eb variabl\u00ebn sistemike replica_parallel_workers.\n
Jan\u00eb eliminuar 28 vulnerabilitete, 26 prej t\u00eb cilave mund t\u00eb shfryt\u00ebzohen n\u00eb distanc\u00eb n\u00ebse ka qasje p\u00ebr t\u00eb d\u00ebrguar k\u00ebrkesa n\u00eb DBMS. Gjithashtu, gjasht\u00eb problemet m\u00eb serioze kan\u00eb nivelin e rrezikshm\u00ebris\u00eb 6.5 dhe lidhen me vulnerabilitetet n\u00eb motorin InnoDB, parserin dhe optimizuesin. Vulnerabilitete m\u00eb pak t\u00eb rrezikshme prekin mysqldump, InnoDB, optimizuesin, DDL, UDF, parserin dhe sistemin e replikimit. <\/ul>\n