{"id":139704,"date":"2025-07-23T11:11:54","date_gmt":"2025-07-23T09:11:54","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/vypusk-subd-mysql-9-4-0"},"modified":"2025-07-23T11:11:54","modified_gmt":"2025-07-23T09:11:54","slug":"vypusk-subd-mysql-9-4-0","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sq\/blog\/news\/vypusk-subd-mysql-9-4-0","title":{"rendered":"L\u00ebshimi i DBMS MySQL 9.4.0","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"
Kompania Oracle ka formuar nj\u00eb deg\u00eb t\u00eb re t\u00eb SGBD MySQL 9.4. Nd\u00ebrtimet MySQL Community Server 9.4 jan\u00eb p\u00ebrgatitur p\u00ebr t\u00eb gjith\u00eb distribucioni kryesor t\u00eb Linux, FreeBSD, macOS dhe Windows. N\u00eb p\u00ebrputhje me modelin e miratuar p\u00ebr formimin e l\u00ebshimeve n\u00eb vitin 2023, MySQL 9.4 i takon deg\u00ebve \"Innovation\". Deg\u00ebt Innovation rekomandohen p\u00ebr ata q\u00eb d\u00ebshirojn\u00eb 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 l\u00ebshimit t\u00eb ardhsh\u00ebm t\u00eb r\u00ebnd\u00ebsish\u00ebm (p\u00ebr shembull, mb\u00ebshtetja p\u00ebr deg\u00ebn 9.3 do t\u00eb ndaloj\u00eb pas shp\u00ebrthimit t\u00eb deg\u00ebs 9.4). N\u00eb vjesht\u00eb pritet t\u00eb formohet l\u00ebshimi LTS 9.5, i rekomanduar p\u00ebr implementime q\u00eb k\u00ebrkojn\u00eb parashikueshm\u00ebri dhe ruajtje t\u00eb 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.4: <\/p>\n
\n
N\u00eb procedurat e ruajtura, t\u00eb shkruara n\u00eb gjuh\u00ebn JavaScript, \u00ebsht\u00eb implementuar mb\u00ebshtetje p\u00ebr tipin BIT. Vlerat me tipin BIT q\u00eb jan\u00eb m\u00eb t\u00eb vogla ose t\u00eb barabarta me JavaScript.MAX_SAFE_INTEGER konvertohen n\u00eb tipin JavaScript Number, nd\u00ebrsa ato m\u00eb t\u00eb m\u00ebdha - n\u00eb tipin JavaScript BigInt.\n
N\u00eb utilitarin e komand\u00ebs mysql \u00ebsht\u00eb shtuar opsioni \"--commands\", q\u00eb Lejon aktivizimin e mb\u00ebshtetjes p\u00ebr ekzekutimin e komandave lokale (n\u00eb m\u00ebnyr\u00eb default komandat jan\u00eb t\u00eb \u00e7aktivizuara):\n
\n
charset <\/li>\n
clear <\/li>\n
connect <\/li>\n
edit <\/li>\n
ego <\/li>\n
exit <\/li>\n
go <\/li>\n
help <\/li>\n
nopager <\/li>\n
notee <\/li>\n
nowarning <\/li>\n
pager <\/li>\n
print <\/li>\n
prompt <\/li>\n
query_attributes <\/li>\n
quit <\/li>\n
rehash <\/li>\n
resetconnection <\/li>\n
ssl_session_data_print <\/li>\n
source <\/li>\n
status <\/li>\n
sistem. <\/li>\n
tee <\/li>\n
\\u <\/li>\n
warnings <\/ul>\n
N\u00eb vend t\u00eb pluginit firewall, q\u00eb lejon filtrimin e k\u00ebrkesave SQL ndaj DBMS n\u00eb baz\u00eb t\u00eb modeleve t\u00eb caktuara, \u00ebsht\u00eb propozuar komponenti MySQL Enterprise Firewall, i cili implementon funksionalitet t\u00eb ngjash\u00ebm p\u00ebrve\u00e7 mb\u00ebshtetjes p\u00ebr profilin e llogarive (n\u00eb vend t\u00eb k\u00ebsaj mb\u00ebshteten profilin e grupeve). Plugin i firewall-it \u00ebsht\u00eb shpallur i vjetruar dhe do t\u00eb hiqet n\u00eb nj\u00eb nga l\u00ebshimet e ardhshme. MySQL Enterprise Firewall \u00ebsht\u00eb n\u00eb dispozicion vet\u00ebm p\u00ebr p\u00ebrdoruesit e versionit komercial MySQL Enterprise Edition.\n
Jan\u00eb eliminuar 30 vulnerabilitete, nga t\u00eb cilat nj\u00eb mund t\u00eb eksplatohet p\u00ebrmes distanc\u00ebs n\u00ebse ka qasje p\u00ebr t\u00eb d\u00ebrguar k\u00ebrkesa nga DBMS. Kat\u00ebr problemet m\u00eb serioze kan\u00eb nj\u00eb nivel rrezikshm\u00ebrie prej 6.5 dhe lidhen me vulnerabilitetet n\u00eb DML dhe optimizuesin. Vulnerabilitetet m\u00eb pak t\u00eb rrezikshme prekin InnoDB, optimizuesin, procedurat e ruajtura, LDAP Auth dhe sistemin e replikimit. <\/ul>\n