{"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\/news\/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\u00ebrsa nd\u00ebrtimet e MySQL Community Server 9.2.0 jan\u00eb p\u00ebrgatitur p\u00ebr t\u00eb gjith\u00eb distribucione kryesore Linux, FreeBSD, macOS dhe Windows. Nd\u00ebrsa u aplikua nj\u00eb modeli i ri p\u00ebr formimin e versioneve n\u00eb vitin 2023, MySQL 9.2 \u00ebsht\u00eb klasifikuar n\u00eb deg\u00ebt \u00abInnovation\u00bb, deri n\u00eb t\u00eb cilat do t\u00eb p\u00ebrfshihet gjithashtu versioni tjet\u00ebr i r\u00ebnd\u00ebsish\u00ebm MySQL 9.3. Deg\u00ebt e Innovation rekomandohen p\u00ebr ata q\u00eb duan t\u00eb ken\u00eb akses m\u00eb her\u00ebt n\u00eb funksionalitete t\u00eb reja, publikohen \u00e7do 3 muaj dhe mb\u00ebshteten vet\u00ebm deri n\u00eb publikimin e versionit tjet\u00ebr t\u00eb r\u00ebnd\u00ebsish\u00ebm (p\u00ebr shembull, mb\u00ebshtetja p\u00ebr deg\u00ebn 9.1 \u00ebsht\u00eb ndalur pas shfaqjes s\u00eb deg\u00ebs 9.2). N\u00eb ver\u00eb planifikohet t\u00eb formohet nj\u00eb version LTS, i rekomanduar p\u00ebr implementime q\u00eb k\u00ebrkojn\u00eb parashikueshm\u00ebri dhe ruajtje t\u00eb sjelljes s\u00eb q\u00ebndrueshme 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 \u2014 MySQL 10.0. <\/p>\n
Ndryshimet kryesore n\u00eb MySQL 9.2: <\/p>\n
\n
N\u00eb motorin MLE (Multilingual Engine Component), i cili lejon t\u00eb p\u00ebrdoren procedura t\u00eb ruajtura dhe funksione me kod n\u00eb gjuh\u00eb t\u00eb ndryshme nga 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 shenohen qart\u00eb si t\u00eb eksportuara me fjal\u00ebn ky\u00e7e \u00abexport\u00bb. P\u00ebr menaxhimin e lidhjes s\u00eb bibliotekave JavaScript jan\u00eb shtuar shprehje t\u00eb reja SQL \u00abCREATE LIBRARY\u00bb dhe \u00abDROP LIBRARY\u00bb. P\u00ebr t\u00eb par\u00eb list\u00ebn e bibliotekave JavaScript t\u00eb disponueshme \u00ebsht\u00eb shtuar shprehja \u00abSHOW CREATE LIBRARY\u00bb. Informacioni mbi bibliotekat JavaScript reflektohet n\u00eb tabel\u00ebn sistematike \u00abLIBRARIES\u00bb, nd\u00ebrsa p\u00ebr procedurat e ruajtura q\u00eb p\u00ebrdorin k\u00ebto biblioteka n\u00eb tabel\u00ebn \u00abROUTINE_LIBRARIES\u00bb. Lidhja e bibliotek\u00ebs n\u00eb nj\u00eb procedur\u00eb t\u00eb ruajtur b\u00ebhet p\u00ebrmes specifikimit t\u00eb list\u00ebs s\u00eb bibliotekave n\u00eb shprehjen \u00abUSING\u00bb.\n
Shtuar API p\u00ebr aksesin n\u00eb procedurat e ruajtura, funksionet dhe variablat e sesionit nga kodi n\u00eb gjuh\u00ebn JavaScript. P\u00ebr t\u00eb thirrur funksionet 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. Qasja n\u00eb variablat b\u00ebhet drejtp\u00ebrdrejt si pasuri t\u00eb objektit JavaScript Session. Shtuar gjithashtu mund\u00ebsia e qasjes direkte n\u00eb funksionet e nd\u00ebrtuara rand(), sleep(), uuid() dhe isUUID(), t\u00eb cilat jan\u00eb n\u00eb p\u00ebrputhje me funksionet SQL me t\u00eb nj\u00ebtin em\u00ebr.\n
\u00cbsht\u00eb shtuar API p\u00ebr pun\u00ebn me transaksionet nga JavaScript, e cila lejon ekzekutimin e veprimeve t\u00eb shumic\u00ebs s\u00eb shprehjeve SQL p\u00ebr pun\u00ebn me transaksionet, t\u00eb tilla si «START TRANSACTION», «COMMIT», «ROLLBACK» dhe «SET AUTOCOMMIT».\n
\u00cbsht\u00eb shtuar mund\u00ebsia e p\u00ebrdorimit t\u00eb tipeve 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 an\u00eb t\u00eb t\u00eb cilit mund t\u00eb menaxhohet mund\u00ebsia e krijimit dhe fshirjes s\u00eb definicioneve t\u00eb sistemit hap\u00ebsinor p\u00ebr lidhjen e t\u00eb dh\u00ebnave t\u00eb sistemeve gjeoinformative. Prania e k\u00ebtij privilegji apo privilegji SUPER tani \u00ebsht\u00eb e domosdoshme p\u00ebr ekzekutimin e shprehjeve «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 mbi versionin e formatit JSON. P\u00ebr t\u00eb vendosur versionin e formatit JSON duhet t\u00eb p\u00ebrdoret variabla explain_json_format_version («SET explain_json_format_version=1|2»).\n
Jan\u00eb eliminuar 32 vulnerabilitete, prej t\u00eb cilave 3 mund t\u00eb shfryt\u00ebzohen nga distanca. Dy problemet m\u00eb serioze kan\u00eb nivel rreziku 9.1 dhe lidhen me vulnerabilitetet n\u00eb komponent\u00ebt Kerberos dhe Curl. Vulnerabilitetet m\u00eb pak t\u00eb rrezikshme prekin InnoDB, Thread Pooling, DDL, optimizuesin, parserin dhe sistemin e autentifikimit. <\/ul>\n