{"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\/novosti-interneta\/vypusk-subd-mysql-9-5-0","title":{"rendered":"Shk\u00ebputja e baz\u00ebs s\u00eb t\u00eb dh\u00ebnave MySQL 9.5.0","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"
Kompania Oracle ka krijuar nj\u00eb deg\u00eb t\u00eb re t\u00eb DBMS 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 krijimit t\u00eb l\u00ebshimeve t\u00eb zbatuar n\u00eb vitin 2023, MySQL 9.5 \u00ebsht\u00eb klasifikuar n\u00eb deg\u00ebt \u00abInnovation\u00bb. Deg\u00ebt e Innovation rekomandohen p\u00ebr ata q\u00eb d\u00ebshirojn\u00eb t\u00eb ken\u00eb qasje m\u00eb her\u00ebt n\u00eb funksionalitetet e 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.5, ndihma p\u00ebr deg\u00ebn 9.4 do t\u00eb ndaloj\u00eb). N\u00eb dim\u00ebr planifikojn\u00eb t\u00eb krijojn\u00eb l\u00ebshimin LTS 9.6, i cili rekomandohet p\u00ebr implementimet q\u00eb kan\u00eb nevoj\u00eb p\u00ebr parashikueshm\u00ebri dhe ruajtje t\u00eb q\u00ebndrueshme t\u00eb sjelljes. Pas deg\u00ebs LTS do t\u00eb krijohet nj\u00eb deg\u00eb e re Innovation \u2014 MySQL 10.0. <\/p>\n
Ndryshimet kryesore n\u00eb MySQL 9.5: <\/p>\n
\n
Shtuar opsioni \u00abactivate_mandatory_roles\u00bb p\u00ebr menaxhim t\u00eb avancuar t\u00eb roleve \u2014 kur \u00ebsht\u00eb \u00e7aktivizuar cil\u00ebsimi \u00abactivate_all_roles_on_login\u00bb dhe aktivizuar \u00abactivate_mandatory_roles\u00bb, p\u00ebrve\u00e7 roleve standarde aktivizohet mb\u00ebshtetje p\u00ebr rolet e detyrueshme (t\u00eb cilat caktohen automatikisht p\u00ebrdoruesit gjat\u00eb lidhjes).\n
N\u00eb pluginin MySQL Multilingual Engine, n\u00eb implementimin e gjuh\u00ebs JavaScript, \u00ebsht\u00eb siguruar mb\u00ebshtetje p\u00ebr specifikimin ECMAScript 2025.\n
\u00cbsht\u00eb shtuar utilita mysqldm (MySQL Diagnostic Monitor), e destinuar p\u00ebr mbledhjen e informacionit diagnostik (analizohet ekzekutimi i nj\u00eb grupi t\u00eb p\u00ebrcaktuar k\u00ebrkesash), q\u00eb mund t\u00eb d\u00ebrgohet nga p\u00ebrdoruesi n\u00eb sh\u00ebrbimin e mb\u00ebshtetjes p\u00ebr t\u00eb leht\u00ebsuar analizimin e problemeve.\n
\u00cbsht\u00eb shtuar mund\u00ebsia p\u00ebr instalimin e nj\u00ebkohsh\u00ebm t\u00eb l\u00ebshimeve normale dhe LTS t\u00eb MySQL.\n
N\u00eb parametrat e replikimit, konfigurimet e mbrojtjes jan\u00eb aktive p\u00ebr t\u00eb gjitha lidhjet gjat\u00eb replikimit.\n
N\u00eb pluginin MySQL Thread Pool \u00ebsht\u00eb realizuar p\u00ebrcaktimi automatik i parametrave p\u00ebr t\u00eb arritur performanc\u00ebn maksimale n\u00eb p\u00ebrputhje me konfigurimin hardware ekzistues.\n
Ndryshuar sjellja e parametrin \u00abinnodb_log_writer_threads\u00bb, aktivizimi i t\u00eb cilit tani varet nga moda aktive e log-eve binar\u00eb redo (log_bin). Kur \u00ablog_bin\u00bb nuk \u00ebsht\u00eb aktiv, parametrin \u00abinnodb_log_writer_threads\u00bb e merr aktiv p\u00ebr sistemet me m\u00eb shum\u00eb se 4 CPU logjike, nd\u00ebrsa kur \u00ebsht\u00eb aktiv \u2014 p\u00ebr ato me m\u00eb shum\u00eb se 31 CPU logjike.\n
Sipas parazgjedhjes, vlera e parametrin \u00abbinlog_transaction_dependency_history_size\u00bb \u00ebsht\u00eb rritur nga 25,000 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 parametrin \u00abcaching_sha2_password_digest_rounds\u00bb \u00ebsht\u00eb rritur n\u00eb parazgjedhje n\u00eb 10,000.\n
\u00cbsht\u00eb shpallur e pap\u00ebrdorshme p\u00ebrdorimi i metod\u00ebs s\u00eb autentifikimit SCRAM-SHA-1 gjat\u00eb lidhjes me SASL LDAP. N\u00eb vend t\u00eb saj duhet t\u00eb p\u00ebrdoret metoda SCRAM-SHA-256, e cila tani vendoset si parazgjedhje n\u00eb parametrin \u00abauthentication_ldap_sasl_auth_method_name\u00bb.\n
Ndalimi i mb\u00ebshtetjes p\u00ebr variablat \u00abgroup_replication_allow_local_lower_version_join\u00bb dhe \u00abreplica_parallel_type\u00bb, t\u00eb cil\u00ebt m\u00eb par\u00eb ishin shpallur t\u00eb pap\u00ebrdorsh\u00ebm.\n
N\u00eb platform\u00ebn Solaris \u00ebsht\u00eb shtuar mb\u00ebshtetje p\u00ebr nd\u00ebrtimin duke p\u00ebrdorur Clang dhe GCC. \u00cbsht\u00eb shtuar gjithashtu mund\u00ebsia p\u00ebr p\u00ebrdorimin e 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 dob\u00ebsi, m\u00eb serioza e t\u00eb cilave \u00ebsht\u00eb vler\u00ebsuar me nivelin e rrezikshm\u00ebris\u00eb 5.5 nga 10. Detajet nuk jan\u00eb raportuar, vet\u00ebm q\u00eb dob\u00ebsit\u00eb jan\u00eb t\u00eb pranishme n\u00eb InnoDB, DML dhe optimizuesit. P\u00ebr shfryt\u00ebzimin e dob\u00ebsive k\u00ebrkohet qasje e autentikuar n\u00eb DBMS. <\/ul>\n