{"id":121458,"date":"2025-01-23T15:46:10","date_gmt":"2025-01-23T13:46:10","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/vypusk-subd-mysql-9-2-0"},"modified":"2025-01-23T15:46:10","modified_gmt":"2025-01-23T13:46:10","slug":"vypusk-subd-mysql-9-2-0","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sq\/blog\/novosti-interneta\/vypusk-subd-mysql-9-2-0","title":{"rendered":"L\u00ebshimi i DBMS MySQL 9.2.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.2.0. Nd\u00ebrtesat e MySQL Community Server 9.2.0 jan\u00eb p\u00ebrgatitur p\u00ebr t\u00eb gjitha distribucionet kryesore Linux, FreeBSD, macOS dhe Windows. N\u00eb kuad\u00ebr t\u00eb modelit t\u00eb ri t\u00eb formimit t\u00eb l\u00ebshimeve t\u00eb zbatuar n\u00eb vitin 2023, MySQL 9.2 \u00ebsht\u00eb klasifikuar n\u00eb deg\u00ebt 'Innovation', n\u00eb t\u00eb cilat do t\u00eb p\u00ebrfitohet edhe l\u00ebshimi i r\u00ebnd\u00ebsish\u00ebm pasues MySQL 9.3. 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, pas shfaqjes s\u00eb deg\u00ebs 9.2, mb\u00ebshtetja p\u00ebr deg\u00ebn 9.1 pezullohet). N\u00eb ver\u00eb planifikohet t\u00eb formohet nj\u00eb l\u00ebshim LTS, i rekomanduar p\u00ebr implementime q\u00eb kan\u00eb nevoj\u00eb p\u00ebr parashikueshm\u00ebri dhe ruajtje t\u00eb gjat\u00eb t\u00eb sjelljes s\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.2: <\/p>\n
\n
N\u00eb motorin MLE (Multilingual Engine Component), q\u00eb lejon p\u00ebrdorimin e kodit n\u00eb procedurat e ruajtura dhe funksionet n\u00eb gjuh\u00eb t\u00eb tjera p\u00ebrve\u00e7 SQL, \u00ebsht\u00eb shtuar mb\u00ebshtetje p\u00ebr bibliotekat e rip\u00ebrdorshme n\u00eb gjuh\u00ebn JavaScript. Funksionet nga k\u00ebto biblioteka mund t\u00eb thirren nga procedurat e ruajtura n\u00eb gjuh\u00ebn JavaScript, por duhet t\u00eb jen\u00eb t\u00eb sh\u00ebnuara qart\u00eb si t\u00eb importuara me fjal\u00ebn ky\u00e7e 'export'. P\u00ebr t\u00eb menaxhuar lidhjen e bibliotekave JavaScript jan\u00eb shtuar shprehje t\u00eb reja SQL 'CREATE LIBRARY' dhe 'DROP LIBRARY'. P\u00ebr t\u00eb par\u00eb list\u00ebn e bibliotekave t\u00eb disponueshme JavaScript \u00ebsht\u00eb shtuar shprehja 'SHOW CREATE LIBRARY'. Informacioni p\u00ebr bibliotekat JavaScript pasqyrohet n\u00eb tabel\u00ebn sistematike 'LIBRARIES', nd\u00ebrsa p\u00ebr procedurat e ruajtura q\u00eb p\u00ebrdorin k\u00ebto biblioteka n\u00eb tabel\u00ebn 'ROUTINE_LIBRARIES'. Lidhja e bibliotek\u00ebs n\u00eb nj\u00eb procedur\u00eb t\u00eb ruajtur realizohet p\u00ebrmes sh\u00ebnimit t\u00eb list\u00ebs s\u00eb bibliotekave n\u00eb shprehjen 'USING'.\n
\u00cbsht\u00eb shtuar API p\u00ebr qasje n\u00eb procedurat e ruajtura, funksionet dhe variablat e sesionit nga kodi n\u00eb gjuh\u00ebn JavaScript. P\u00ebr t'u referuar funksioneve MySQL \u00ebsht\u00eb shtuar metoda getFunction(), nd\u00ebrsa p\u00ebr procedurat e ruajtura \u2014 metoda getProcedure(), q\u00eb kthen objektin JavaScript Function, i cili mund t\u00eb ekzekutohet me argumente. Referimi n\u00eb variabla realizohet drejtp\u00ebrdrejt si pron\u00ebsi e objektit JavaScript Session. P\u00ebr m\u00eb tep\u00ebr, \u00ebsht\u00eb shtuar mund\u00ebsia e aksesit t\u00eb drejtp\u00ebrdrejt\u00eb n\u00eb funksionet e integruara rand(), sleep(), uuid() dhe isUUID(), t\u00eb cilat jan\u00eb t\u00eb ngjashme me funksionet e nj\u00ebjta SQL.\n
\u00cbsht\u00eb shtuar API p\u00ebr pun\u00ebn me transaksionet nga JavaScript, q\u00eb lejon ekzekutimin e shumic\u00ebs s\u00eb shprehjeve SQL p\u00ebr pun\u00ebn me transaksionet, si 'START TRANSACTION', 'COMMIT', 'ROLLBACK' dhe 'SET AUTOCOMMIT'.\n
U shtua mund\u00ebsia p\u00ebr t\u00eb p\u00ebrdorur llojet MySQL ENUM dhe SET n\u00eb argumentet e procedurave t\u00eb ruajtura, t\u00eb shkruara n\u00eb JavaScript.\n
\u00cbsht\u00eb shtuar privilegji CREATE_SPATIAL_REFERENCE_SYSTEM, me t\u00eb cilin mund t\u00eb menaxhohet mund\u00ebsia e krijimit dhe fshirjes s\u00eb definicioneve t\u00eb referenc\u00ebs hap\u00ebsinore t\u00eb t\u00eb dh\u00ebnave t\u00eb sistemeve informacionit gjeografik. Prania e k\u00ebtij privilegji ose e privilegjit SUPER tani \u00ebsht\u00eb e nevojshme p\u00ebr t\u00eb realizuar shprehjet 'CREATE SPATIAL REFERENCE SYSTEM', 'CREATE OR REPLACE SPATIAL REFERENCE SYSTEM' dhe 'DROP SPATIAL REFERENCE SYSTEM'.\n
N\u00eb daljen 'EXPLAIN FORMAT=JSON' \u00ebsht\u00eb shtuar informacion p\u00ebr versionin e formatit JSON. P\u00ebr t\u00eb caktuar versionin e formatit JSON duhet t\u00eb p\u00ebrdoret variabla explain_json_format_version ('SET explain_json_format_version=1|2').\n
Jan\u00eb shpallur t\u00eb vjetra: shprehja 'FLUSH PRIVILEGES', komandat 'mysqladmin flush-privileges' dhe 'mysqladmin reload', si dhe plugin'i 'version_tokens'.\n
Jan\u00eb eliminuar 32 vulnerabilitete, nga t\u00eb cilat 3 mund t\u00eb shfryt\u00ebzohen nga distanca. Dy problemet m\u00eb serioze kan\u00eb nivel rreziku 9.1 dhe jan\u00eb t\u00eb lidhura me vulnerabilitetet n\u00eb komponent\u00ebt Kerberos dhe Curl. Vulnerabilitetet m\u00eb pak t\u00eb rrezikshme prekin InnoDB, Thread Pooling, DDL, optimizuesin, parser-in dhe sistemin e autentifikimit. <\/ul>\n