{"id":112960,"date":"2024-01-17T17:28:13","date_gmt":"2024-01-17T15:28:13","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/dostupna-subd-mysql-8-3-0"},"modified":"2024-01-17T17:28:13","modified_gmt":"2024-01-17T15:28:13","slug":"dostupna-subd-mysql-8-3-0","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sq\/blog\/news\/dostupna-subd-mysql-8-3-0","title":{"rendered":"T\u00eb dh\u00ebnat n\u00eb MySQL 8.3.0 jan\u00eb t\u00eb disponueshme","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Kompania Oracle krijoi nj\u00eb deg\u00eb t\u00eb re t\u00eb SGBD MySQL 8.3 dhe publikoi nj\u00eb azhurnim korrektiv MySQL 8.0.36. Nd\u00ebrtimet MySQL Community Server 8.3.0 jan\u00eb p\u00ebrgatitur p\u00ebr t\u00eb gjitha distribucionet kryesore t\u00eb Linux, FreeBSD, macOS dhe Windows.    <\/p>\n<p>MySQL 8.3.0 \u00ebsht\u00eb lansimi i tret\u00eb, i formuar n\u00eb kuad\u00ebr t\u00eb modelit t\u00eb ri t\u00eb nxjerrjes s\u00eb versioneve, q\u00eb parashikon ekzistenc\u00ebn e dy llojeve t\u00eb deg\u00ebve t\u00eb MySQL - \"Innovation\" dhe \"LTS\". Deg\u00ebt Innovation, q\u00eb p\u00ebrfshijn\u00eb MySQL 8.1, 8.2 dhe 8.3, rekomandohen p\u00ebr ata q\u00eb duan t\u00eb ken\u00eb akses m\u00eb her\u00ebt n\u00eb funksionalitete t\u00eb reja. K\u00ebto deg\u00eb 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, pas shfaqjes s\u00eb deg\u00ebs 8.3, mb\u00ebshtetja p\u00ebr deg\u00ebn 8.2 nd\u00ebrpritet). Deg\u00ebt LTS rekomandohen p\u00ebr implementimet q\u00eb kan\u00eb nevoj\u00eb p\u00ebr parashikueshm\u00ebri dhe ruajtje p\u00ebr nj\u00eb periudh\u00eb m\u00eb t\u00eb gjat\u00eb t\u00eb sjelljes s\u00eb pandryshuar. Deg\u00ebt LTS do t\u00eb lansohen nj\u00eb her\u00eb \u00e7do dy vjet dhe do t\u00eb mb\u00ebshteten si normalisht p\u00ebr 5 vjet, p\u00ebrve\u00e7 q\u00eb do t\u00eb ken\u00eb nj\u00eb periudh\u00eb shtes\u00eb mb\u00ebshtetjeje prej 3 vjet\u00ebsh. N\u00eb pranver\u00ebn e vitit 2024 pritet lanimi i versionit LTS t\u00eb MySQL 8.4, pas t\u00eb cilit do t\u00eb formohet nj\u00eb deg\u00eb e re Innovation 9.0.        <\/p>\n<p>Ndryshimet kryesore n\u00eb MySQL 8.3:  <\/p>\n<ul>\n<li class=\"l\"> Jan\u00eb eliminuar 25 cenueshm\u00ebri, nj\u00ebra prej t\u00eb cilave (CVE-2023-5363, prek OpenSSL) mund t\u00eb eksploitohet n\u00eb distanc\u00eb. Problemit m\u00eb t\u00eb r\u00ebnd\u00ebsish\u00ebm, q\u00eb lidhet me p\u00ebrdorimin e protokollit Kerberos, i \u00ebsht\u00eb caktuar nj\u00eb niveli rreziku 8.8. Cenueshm\u00ebrit\u00eb m\u00eb pak t\u00eb rrezikshme me nivelin e rrezikut 6.5 prekin optimizuesin, UDF, DDL, DML, replikimin, sistemin e privilegjeve dhe mjetet p\u00ebr enkriptimin.\n<li class=\"l\"> N\u00eb platform\u00ebn Linux \u00ebsht\u00eb shtuar mb\u00ebshtetje p\u00ebr lidh\u00ebsin mold. P\u00ebrfshirja e tij \u00ebsht\u00eb parashikuar me opsionin \"-DWITH_LD=mold|lld\".\n<li class=\"l\"> K\u00ebrkesat e standardit t\u00eb mb\u00ebshtetur nga kompilatori C++ jan\u00eb rritur nga C++17 n\u00eb C++20.\n<li class=\"l\"> Mb\u00ebshtetja p\u00ebr nd\u00ebrtimin me biblioteka t\u00eb jashtme Boost C++ \u00ebsht\u00eb nd\u00ebrprer\u00eb - tani gjat\u00eb kompilimit t\u00eb MySQL p\u00ebrdoren vet\u00ebm bibliotekat e integruara Boost. Opsionet e nd\u00ebrtimit WITH_BOOST, DOWNLOAD_BOOST dhe DOWNLOAD_BOOST_TIMEOUT jan\u00eb eliminuar nga CMake.\n<li class=\"l\"> Mb\u00ebshtetja p\u00ebr nd\u00ebrtimin n\u00eb Visual Studio 2022 \u00ebsht\u00eb ndalur. Versioni minimal i mb\u00ebshtetur i instrumenteve Clang \u00ebsht\u00eb rritur nga Clang 10 n\u00eb Clang 12.\n<li class=\"l\"> N\u00eb MySQL Enterprise Edition \u00ebsht\u00eb shtuar mb\u00ebshtetje p\u00ebr grumbullimin e telemetris\u00eb me metrika p\u00ebr performanc\u00ebn <a class=\"wpil_keyword_link\" href=\"https:\/\/prohoster.info\/sq\/server\/dts-los-angeles\/\"   title=\"server\u00eb\" data-wpil-keyword-link=\"linked\"  data-wpil-monitor-id=\"3680\">server\u00eb<\/a> n\u00eb formatin OpenTelemetry dhe transmetimin e t\u00eb dh\u00ebnave n\u00eb nj\u00eb p\u00ebrpunues rrjeti q\u00eb mb\u00ebshtet k\u00ebt\u00eb format.\n<li class=\"l\"> Formati i identifikuesve GTID (identifikues global t\u00eb transaksioneve) \u00ebsht\u00eb zgjeruar, i aplikuar gjat\u00eb replikimit p\u00ebr identifikimin e grupeve t\u00eb transaksioneve. Formati i ri GTID - \"UUID::NUMBER\" (n\u00eb vend t\u00eb \"UUID:NUMBER\"), ku TAG \u00ebsht\u00eb nj\u00eb varg i rast\u00ebsish\u00ebm q\u00eb lejon caktimin e emrave unik\u00eb p\u00ebr nj\u00eb grup t\u00eb caktuar transaksionesh p\u00ebr ta leht\u00ebsuar p\u00ebrpunimin dhe analizimin.\n<li class=\"l\"> Dy variabla t\u00eb rinj \"Deprecated_use_i_s_processlist_count\" dhe \"Deprecated_use_i_s_processlist_last_timestamp\" jan\u00eb shtuar p\u00ebr ndjekjen e p\u00ebrdorimit t\u00eb tabel\u00ebs s\u00eb vjetruar INFORMATION_SCHEMA.PROCESSLIST.\n<li class=\"l\"> Caktimi i variabl\u00ebs mjedisore AUTHENTICATION_PAM_LOG nuk sjell m\u00eb shfaqjen e fjal\u00ebkalimeve n\u00eb mesazhet diagnostikuese (p\u00ebr p\u00ebrmendjen e fjal\u00ebkalimit k\u00ebrkohet caktimi i vler\u00ebs PAM_LOG_WITH_SECRET_INFO).\n<li class=\"l\"> Shtuar tabela tp_connections me informacione p\u00ebr \u00e7do lidhje n\u00eb rezerv\u00ebn e thirrjeve (thread pool).\n<li class=\"l\"> Nj\u00eb variab\u00ebl sistemor \"explain_json_format_version\" \u00ebsht\u00eb shtuar p\u00ebr t\u00eb zgjedhur versionin e formatit JSON q\u00eb p\u00ebrdoret n\u00eb shprehjet \"EXPLAIN FORMAT=JSON\".\n<li class=\"l\"> N\u00eb depozit\u00ebn InnoDB jan\u00eb hequr parametrat \"--innodb\" dhe \"--skip-innodb\", t\u00eb cilat ishin shpallur t\u00eb vjetruara q\u00eb n\u00eb nxjerrjen e MySQL 5.6. Pjesa memcached p\u00ebr InnoDB \u00ebsht\u00eb hequr, e shpallur e vjetruar n\u00eb MySQL 8.0.22.\n<li class=\"l\"> Jan\u00eb hequr disa \u043d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0430 dhe opsione t\u00eb komand\u00ebs lidhur me replikimin, t\u00eb cilat ishin shpallur t\u00eb pavlefshme n\u00eb l\u00ebshime t\u00eb kaluara: &#171;&#8212;slave-rows-search-algorithms&#187;, &#171;&#8212;relay-log-info-file&#187;, &#171;&#8212;relay-log-info-repository&#187;, &#171;&#8212;master-info-file&#187;, &#171;&#8212;master-info-repository&#187;, &#171;log_bin_use_v1_events&#187;, &#171;transaction_write_set_extraction&#187;, &#171;group_replication_ip_whitelist&#187;, &#171;group_replication_primary_member&#187;. \u00cbsht\u00eb ndaluar p\u00ebrdorimi i opsionit IGNORE_SERVER_IDS me modalitetin e replikimit GTID (gtid_mode=ON).\n<li class=\"l\"> \u00cbsht\u00eb ndalur mb\u00ebshtetja p\u00ebr funksionet e API-s\u00eb: mysql_kill(), mysql_list_fields(), mysql_list_processes(), mysql_refresh(), mysql_reload(), mysql_shutdown(), mysql_ssl_set().\n<li class=\"l\"> \u00cbsht\u00eb ndalur mb\u00ebshtetje p\u00ebr shprehjen &#171;FLUSH HOSTS&#187;, e cila u shpall e pavlefshme n\u00eb MySQL 8.0.23.      <\/ul>\n<p>Burimi: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=60453\">opennet.ru<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u041a\u043e\u043c\u043f\u0430\u043d\u0438\u044f Oracle \u0441\u0444\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u043b\u0430 \u043d\u043e\u0432\u0443\u044e \u0432\u0435\u0442\u043a\u0443 \u0421\u0423\u0411\u0414 MySQL 8.3 \u0438 \u043e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043b\u0430 \u043a\u043e\u0440\u0440\u0435\u043a\u0442\u0438\u0440\u0443\u044e\u0449\u0435\u0435 \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u0435 MySQL 8.0.36. \u0421\u0431\u043e\u0440\u043a\u0438 MySQL Community Server 8.3.0 \u043f\u043e\u0434\u0433\u043e\u0442\u043e\u0432\u043b\u0435\u043d\u044b \u0434\u043b\u044f \u0432\u0441\u0435\u0445 \u043e\u0441\u043d\u043e\u0432\u043d\u044b\u0445 \u0434\u0438\u0441\u0442\u0440\u0438\u0431\u0443\u0442\u0438\u0432\u043e\u0432 Linux, FreeBSD, macOS \u0438 Windows. MySQL 8.3.0 \u044f\u0432\u043b\u044f\u0435\u0442\u0441\u044f \u0442\u0440\u0435\u0442\u044c\u0438\u043c \u0432\u044b\u043f\u0443\u0441\u043a\u043e\u043c, \u0441\u0444\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u043d\u043d\u044b\u043c \u0432 \u0440\u0430\u043c\u043a\u0430\u0445 \u043d\u043e\u0432\u043e\u0439 \u043c\u043e\u0434\u0435\u043b\u0438 \u0444\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u0440\u0435\u043b\u0438\u0437\u043e\u0432, \u043f\u0440\u0435\u0434\u0443\u0441\u043c\u0430\u0442\u0440\u0438\u0432\u0430\u044e\u0449\u0435\u0439 \u043d\u0430\u043b\u0438\u0447\u0438\u0435 \u0434\u0432\u0443\u0445 \u0442\u0438\u043f\u043e\u0432 \u0432\u0435\u0442\u043e\u043a MySQL &#8212; &#171;Innovation&#187; \u0438 &#171;LTS&#187;. \u0412\u0435\u0442\u043a\u0438 Innovation, \u043a \u043a\u043e\u0442\u043e\u0440\u044b\u043c [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[702],"tags":[],"class_list":["post-112960","post","type-post","status-publish","format-standard","hentry","category-news"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.2.1 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u041a\u043e\u043c\u043f\u0430\u043d\u0438\u044f Oracle \u0441\u0444\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u043b\u0430 \u043d\u043e\u0432\u0443\u044e \u0432\u0435\u0442\u043a\u0443 \u0421\u0423\u0411\u0414 MySQL 8.3 \u0438 \u043e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043b\u0430 \u043a\u043e\u0440\u0440\u0435\u043a\u0442\u0438\u0440\u0443\u044e\u0449\u0435\u0435 \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u0435 MySQL 8.0.36.\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Yuri Gagarin\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/prohoster.info\/sq\/blog\/news\/dostupna-subd-mysql-8-3-0\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.2.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"sq_AL\" \/>\n\t\t<meta property=\"og:site_name\" content=\"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"\ud83e\udd47\u0414\u043e\u0441\u0442\u0443\u043f\u043d\u0430 \u0421\u0423\u0411\u0414 MySQL 8.3.0 | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u041a\u043e\u043c\u043f\u0430\u043d\u0438\u044f Oracle \u0441\u0444\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u043b\u0430 \u043d\u043e\u0432\u0443\u044e \u0432\u0435\u0442\u043a\u0443 \u0421\u0423\u0411\u0414 MySQL 8.3 \u0438 \u043e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043b\u0430 \u043a\u043e\u0440\u0440\u0435\u043a\u0442\u0438\u0440\u0443\u044e\u0449\u0435\u0435 \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u0435 MySQL 8.0.36.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/sq\/blog\/news\/dostupna-subd-mysql-8-3-0\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:width\" content=\"350\" \/>\n\t\t<meta property=\"og:image:height\" content=\"350\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2024-01-17T15:28:13+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2024-01-17T15:28:13+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"\ud83e\udd47DBMS MySQL 8.3.0 \u00ebsht\u00eb n\u00eb dispozicion | ProHoster","description":"Kompania Oracle ka formuar nj\u00eb deg\u00eb t\u00eb re t\u00eb DBMS MySQL 8.3 dhe ka publikuar nj\u00eb p\u00ebrdit\u00ebsim korrektiv p\u00ebr MySQL 8.0.36.","canonical_url":"https:\/\/prohoster.info\/sq\/blog\/news\/dostupna-subd-mysql-8-3-0","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"sq_AL","og:site_name":"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b","og:type":"article","og:title":"\ud83e\udd47\u0414\u043e\u0441\u0442\u0443\u043f\u043d\u0430 \u0421\u0423\u0411\u0414 MySQL 8.3.0 | ProHoster","og:description":"\u041a\u043e\u043c\u043f\u0430\u043d\u0438\u044f Oracle \u0441\u0444\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u043b\u0430 \u043d\u043e\u0432\u0443\u044e \u0432\u0435\u0442\u043a\u0443 \u0421\u0423\u0411\u0414 MySQL 8.3 \u0438 \u043e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043b\u0430 \u043a\u043e\u0440\u0440\u0435\u043a\u0442\u0438\u0440\u0443\u044e\u0449\u0435\u0435 \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u0435 MySQL 8.0.36.","og:url":"https:\/\/prohoster.info\/sq\/blog\/news\/dostupna-subd-mysql-8-3-0","og:image":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:secure_url":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:width":350,"og:image:height":350,"article:published_time":"2024-01-17T15:28:13+00:00","article:modified_time":"2024-01-17T15:28:13+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"112960","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":"default","schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"seo_analyzer_scan_date":null,"breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2026-02-22 15:29:48","updated":"2026-02-22 15:29:48","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/112960","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/comments?post=112960"}],"version-history":[{"count":1,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/112960\/revisions"}],"predecessor-version":[{"id":162208,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/112960\/revisions\/162208"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media?parent=112960"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/categories?post=112960"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/tags?post=112960"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}