{"id":146187,"date":"2025-10-23T17:12:00","date_gmt":"2025-10-23T15:12:00","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/vypusk-subd-mysql-9-5-0"},"modified":"2025-10-23T17:12:00","modified_gmt":"2025-10-23T15:12:00","slug":"vypusk-subd-mysql-9-5-0","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sq\/blog\/news\/vypusk-subd-mysql-9-5-0","title":{"rendered":"L\u00ebshimi i DBMS MySQL 9.5.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.5.0. Nd\u00ebrtimet e MySQL Community Server 9.5.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 prezantuar p\u00ebr formimin e l\u00ebshimeve n\u00eb vitin 2023, MySQL 9.5 \u00ebsht\u00eb klasifikuar n\u00eb deg\u00ebt \u201cInnovation\u201d. Deg\u00ebt e Innovation rekomandohen p\u00ebr ata q\u00eb d\u00ebshirojn\u00eb t\u00eb ken\u00eb akses m\u00eb her\u00ebt n\u00eb funksionalitetet e 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.5, mb\u00ebshtetja p\u00ebr deg\u00ebn 9.4 \u00ebsht\u00eb ndalur). N\u00eb dim\u00ebr planifikohet formimi i l\u00ebshimit LTS 9.6, i rekomanduar p\u00ebr implementimet q\u00eb k\u00ebrkojn\u00eb parashikueshm\u00ebri dhe ruajtje t\u00eb q\u00ebndrueshme t\u00eb sjelljes. 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.5: <\/p>\n
\n
Shtuar opsioni \u201cactivate_mandatory_roles\u201d p\u00ebr menaxhim t\u00eb avancuar t\u00eb roleve - kur cil\u00ebsimi \u201cactivate_all_roles_on_login\u201d \u00ebsht\u00eb i \u00e7aktivizuar dhe \u201cactivate_mandatory_roles\u201d \u00ebsht\u00eb i aktivizuar, p\u00ebrve\u00e7 roleve standarde aktivizohet mb\u00ebshtetje p\u00ebr rolet e detyrueshme (t\u00eb caktuara automatikisht p\u00ebr p\u00ebrdoruesin gjat\u00eb lidhjes).\n
N\u00eb pluginin MySQL Multilingual Engine, n\u00eb realizimin e gjuh\u00ebs JavaScript \u00ebsht\u00eb siguruar mb\u00ebshtetje p\u00ebr specifikimin ECMAScript 2025.\n
Shtuar utilitarin mysqldm (MySQL Diagnostic Monitor), i cili \u00ebsht\u00eb i destinuar p\u00ebr mbledhjen e informacionit diagnostik (analizohet ekzekutimi i nj\u00eb grupi t\u00eb paracaktuar k\u00ebrkesash), i cili mund t\u00eb d\u00ebrgohet nga p\u00ebrdoruesi n\u00eb sh\u00ebrbimin p\u00ebr mb\u00ebshtetje p\u00ebr t\u00eb leht\u00ebsuar analiz\u00ebn e problemeve.\n
Shtuar mund\u00ebsia p\u00ebr instalimin e nj\u00ebkohsh\u00ebm t\u00eb l\u00ebshimeve t\u00eb zakonshme dhe LTS t\u00eb MySQL.\n
N\u00eb parametrat e replikimit, jan\u00eb aktivizuar si parazgjedhje cil\u00ebsime t\u00eb avancuara t\u00eb mbrojtjes, t\u00eb cilat n\u00ebnkuptojn\u00eb p\u00ebrdorimin e enkriptimit p\u00ebr t\u00eb gjitha lidhjet gjat\u00eb replikimit.\n
N\u00eb pluginin MySQL Thread Pool \u00ebsht\u00eb realizuar vendosja automatike e parametrave p\u00ebr arritjen e performanc\u00ebs maksimale duke marr\u00eb parasysh konfigurimin ekzistues t\u00eb harduerit.\n
Ndryshuar sjellja e parametrave \u201cinnodb_log_writer_threads\u201d, aktivizimi i t\u00eb cilit tani varet nga modelet aktive t\u00eb regjistrit binar (log_bin). Kur \u201clog_bin\u201d nuk \u00ebsht\u00eb aktiv, parametri \u201cinnodb_log_writer_threads\u201d aktivizohet p\u00ebr sistemet me m\u00eb shum\u00eb se 4 CPU logjik\u00eb, dhe kur \u00ebsht\u00eb aktiv - me m\u00eb shum\u00eb se 31 CPU logjik\u00eb.\n
Si\u00e7 \u00ebsht\u00eb e p\u00ebrcaktuar, vlera e parametrave \u201cbinlog_transaction_dependency_history_size\u201d \u00ebsht\u00eb rritur nga 25 mij\u00eb n\u00eb nj\u00eb milion. Vlera maksimale e mundshme p\u00ebr k\u00ebt\u00eb parametr \u00ebsht\u00eb rritur nga 1 n\u00eb 10 milion.\n
Vlera e parametrave \u201ccaching_sha2_password_digest_rounds\u201d si\u00e7 \u00ebsht\u00eb e p\u00ebrcaktuar \u00ebsht\u00eb rritur n\u00eb 10000.\n
Deklaruar si t\u00eb vjetruar p\u00ebrdorimi i metod\u00ebs s\u00eb autentikimit SCRAM-SHA-1 p\u00ebr lidhjet me SASL LDAP. N\u00eb vend t\u00eb saj, duhet t\u00eb p\u00ebrdoret metoda SCRAM-SHA-256, e cila tani \u00ebsht\u00eb caktuar si e default n\u00eb parametrin \u201cauthentication_ldap_sasl_auth_method_name\u201d.\n
Ndalur mb\u00ebshtetje p\u00ebr variablat \u201cgroup_replication_allow_local_lower_version_join\u201d dhe \u201creplica_parallel_type\u201d, t\u00eb cilat ishin shpallur si t\u00eb vjetra m\u00eb par\u00eb.\n
N\u00eb platform\u00ebn Solaris \u00ebsht\u00eb shtuar mb\u00ebshtetje p\u00ebr nd\u00ebrtimin duke p\u00ebrdorur Clang dhe GCC. Po ashtu, \u00ebsht\u00eb shtuar mund\u00ebsia e p\u00ebrdorimit t\u00eb OpenSSL 3 n\u00eb Solaris.\n
Versioni minimal i mb\u00ebshtetur t\u00eb Cmake \u00ebsht\u00eb ngritur n\u00eb 3.17.5.\n
Jan\u00eb eliminuar 9 vulnerabilitete, prej t\u00eb cilave m\u00eb seriozja ka marr\u00eb nivelin e rrezikshm\u00ebris\u00eb 5.5 nga 10. Nuk jepen detaje, p\u00ebrve\u00e7 faktit se vulnerabilitetet jan\u00eb t\u00eb pranishme n\u00eb InnoDB, DML dhe optimizuesin. P\u00ebr t\u00eb shfryt\u00ebzuar vulnerabilitetet k\u00ebrkohet qasje e autorizuar n\u00eb DBMS. <\/ul>\n