{"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\/novosti-interneta\/vypusk-subd-mysql-9-4-0","title":{"rendered":"L\u00ebshimi i DB-s\u00eb 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 DBMS MySQL 9.4.0. Nd\u00ebrtime t\u00eb MySQL Community Server 9.4.0 jan\u00eb p\u00ebrgatitur p\u00ebr t\u00eb gjitha shp\u00ebrndarjet kryesore Linux, FreeBSD, macOS dhe Windows. N\u00eb p\u00ebrputhje me modelin e prezantuar n\u00eb vitin 2023 p\u00ebr formimin e l\u00ebshimeve, MySQL 9.4 \u00ebsht\u00eb klasifikuar n\u00eb deg\u00ebt \"Innovation\". Deg\u00ebt e Inovacionit 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 mbahen vet\u00ebm deri n\u00eb publikimin e l\u00ebshimit t\u00eb ardhsh\u00ebm t\u00eb r\u00ebnd\u00ebsish\u00ebm (p.sh., pas shfaqjes s\u00eb deg\u00ebs 9.4, mb\u00ebshtetja p\u00ebr deg\u00ebn 9.3 nd\u00ebrpritet). N\u00eb vjesht\u00eb planifikohet t\u00eb formohet nj\u00eb l\u00ebshim LTS 9.5, i rekomanduar p\u00ebr implementime q\u00eb k\u00ebrkojn\u00eb parashikueshm\u00ebri dhe ruajtje t\u00eb zbatimit t\u00eb pandryshuar p\u00ebr nj\u00eb periudh\u00eb t\u00eb gjat\u00eb. Pas deg\u00ebs LTS do t\u00eb formohet nj\u00eb deg\u00eb e re Inovacioni \u2014 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 Number t\u00eb JavaScript, nd\u00ebrsa ato m\u00eb t\u00eb m\u00ebdha \u2014 n\u00eb tipin BigInt t\u00eb JavaScript.\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 (me default komandat jan\u00eb t\u00eb \u00e7aktivizuara):\n
\n
charset <\/li>\n
clear <\/li>\n
lidhu <\/li>\n
edito <\/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
system <\/li>\n
tee <\/li>\n
\\u <\/li>\n
warnings <\/ul>\n
N\u00eb vend t\u00eb plugin-it firewall, i cili mund\u00ebson filtrimin e k\u00ebrkesave SQL n\u00eb DBMS sipas modele t\u00eb caktuara, \u00ebsht\u00eb propozuar komponenti MySQL Enterprise Firewall, i cili implementon funksionalitet identik p\u00ebrve\u00e7 mb\u00ebshtetjes p\u00ebr profile llogarish (n\u00eb vend t\u00eb k\u00ebsaj mb\u00ebshteten profile grupesh). Plugin-i firewall \u00ebsht\u00eb shpallur i vjetruar dhe do t\u00eb hiqet n\u00eb nj\u00eb nga l\u00ebshimet e ardhshme. MySQL Enterprise Firewall \u00ebsht\u00eb i disponuesh\u00ebm 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 shfryt\u00ebzohet nga distanca n\u00ebse ka qasje p\u00ebr t\u00eb d\u00ebrguar k\u00ebrkesa n\u00eb DBMS. Kat\u00ebr problemet m\u00eb serioze kan\u00eb nivel rreziku 6.5 dhe jan\u00eb t\u00eb lidhura 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