{"id":116891,"date":"2024-07-02T12:05:43","date_gmt":"2024-07-02T10:05:43","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/dostupna-subd-mysql-9-0-0"},"modified":"2024-07-02T12:05:43","modified_gmt":"2024-07-02T10:05:43","slug":"dostupna-subd-mysql-9-0-0","status":"publish","type":"post","link":"https:\/\/prohoster.info\/hr\/blog\/news\/dostupna-subd-mysql-9-0-0","title":{"rendered":"Dostupna SDB MySQL 9.0.0","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Tvrtka Oracle je formirala novu granu SGBD-a MySQL 9.0.0. Izgradnje MySQL Community Server 9.0.0 su pripremljene za sve glavne distribucije Linuxa, FreeBSD, macOS i Windows. U okviru modela izdanja koji je uveden pro\u0161le godine, MySQL 9.0 je svrstana u grane \u201eInnovation\u201c, kojima \u0107e pripadati i sljede\u0107a zna\u010dajna izdanja MySQL 9.1 i 9.2. Innovation grane su preporu\u010dene za one koji \u017eele raniji pristup novim funkcionalnostima, objavljuju se svaka 3 mjeseca i podr\u017eavaju se samo do objave sljede\u0107eg zna\u010dajnog izdanja (na primjer, nakon pojave grane 9.1 prestaje podr\u0161ka za granu 9.0). Oko godine planiraju formirati LTS izdanje, koje \u0107e biti preporu\u010deno za implementacije kojima je potrebna predvidljivost i dugo o\u010duvanje nepromijenjenog pona\u0161anja. Nakon LTS grane, formirat \u0107e se nova Innovation grana \u2014 MySQL 10.0.<\/p>\n<p>Glavne promjene u MySQL 9.0:<\/p>\n<ul>\n<li class=\"l\"> Izvr\u0161avanjem konstrukcije \u201eEXPLAIN ANALYZE INTO\u201c dodana je mogu\u0107nost spremanja izlaza u JSON formatu u korisni\u010dku varijablu, koja se zatim mo\u017ee koristiti kao argument u funkcijama za rad s JSON-om.\n<p>   EXPLAIN ANALYZE FORMAT=JSON INTO @varijabla select_stmt<\/p>\n<li class=\"l\"> Dopu\u0161teno je oblikovanje izraza \u201eCREATE EVENT\u201c, \u201eALTER EVENT\u201c i \u201eDROP EVENT\u201c kao parametiziranih upita unutar pohranjenih procedura. Kreiranje parametiziranog upita vr\u0161i se koriste\u0107i izraz PREPARE, a izvr\u0161avanje \u2014 izraz EXECUTE.\n<p>   CREATE PROCEDURE sp(n INT)<br \/>\n   PO\u010cNI<br \/>\n     SET @s1 = \u201eCREATE EVENT e ON SCHEDULE EVERY \u201e;<br \/>\n     SET @s2 = \u201d SECOND<br \/>\n          STARTS CURRENT_TIMESTAMP + INTERVAL 10 SECOND<br \/>\n          ENDS CURRENT_TIMESTAMP + INTERVAL 2 MINUTE<br \/>\n          ON COMPLETION PRESERVE<br \/>\n          IZVR\u0160I<br \/>\n          INSERT INTO d.t VALUES ROW(NULL, NOW(), FLOOR(RAND()*100))\u201d;<\/p>\n<p>     SET @s = CONCAT(@s1, n, @s2);<br \/>\n     PREPARE ps FROM @s;<br \/>\n     EXECUTE ps;<br \/>\n     DEALLOCATE PREPARE ps;<br \/>\n   KRAJ<\/p>\n<li class=\"l\"> Dodane su dvije nove sistemske tablice koje sadr\u017ee informacije o sistemskim varijablama: variables_metadata \u2014 sadr\u017ei informacije o imenima, opsegu, tipovima i rasponima vrijednosti svih podr\u017eanih sistemskih varijabli na MySQL poslu\u017eitelju; global_variable_attributes \u2014 sadr\u017ei vrijednosti atributa postavljenih za globalne varijable, kao \u0161to su offline_mode i read_only.\n<li class=\"l\"> Ranije navedeni zastarjeli poslu\u017eiteljski plugin mysql_native_password, koji omogu\u0107ava autentifikaciju pomo\u0107u lozinki, uklonjen je. Umjesto mysql_native_password preporu\u010duje se kori\u0161tenje plugina caching_sha2_password, koji koristi SHA2 algoritam za hashing umjesto SHA1.\n<li class=\"l\"> Dodano je 15 varijabli za konfiguraciju i inspekciju MLE (Multilingual Engine Component) sustava, \u0161to omogu\u0107uje kori\u0161tenje koda na jezicima razli\u010ditim od SQL-a u pohranjenim procedurama i funkcijama.\n<\/ul>\n<p>Izvor: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=61476\">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 9.0.0. \u0421\u0431\u043e\u0440\u043a\u0438 MySQL Community Server 9.0.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. \u0412 \u0440\u0430\u043c\u043a\u0430\u0445 \u0432\u043d\u0435\u0434\u0440\u0451\u043d\u043d\u043e\u0439 \u0432 \u043f\u0440\u043e\u0448\u043b\u043e\u043c \u0433\u043e\u0434\u0443 \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, MySQL 9.0 \u043e\u0442\u043d\u0435\u0441\u0451\u043d \u043a \u0432\u0435\u0442\u043a\u0430\u043c &#171;Innovation&#187;, \u043a \u043a\u043e\u0442\u043e\u0440\u044b\u043c \u0442\u0430\u043a\u0436\u0435 \u0431\u0443\u0434\u0443\u0442 \u043e\u0442\u043d\u0435\u0441\u0435\u043d\u044b \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0438\u0435 \u0437\u043d\u0430\u0447\u0438\u0442\u0435\u043b\u044c\u043d\u044b\u0435 \u0440\u0435\u043b\u0438\u0437\u044b MySQL 9.1 \u0438 9.2. Innovation-\u0432\u0435\u0442\u043a\u0438 \u0440\u0435\u043a\u043e\u043c\u0435\u043d\u0434\u043e\u0432\u0430\u043d\u044b \u0434\u043b\u044f \u0442\u0435\u0445, \u043a\u0442\u043e [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":0,"comment_status":"","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[702],"tags":[],"class_list":["post-116891","post","type-post","status-publish","format-standard","hentry","category-news"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.4 - 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 9.0.0. \u0421\u0431\u043e\u0440\u043a\u0438 MySQL Community Server 9.0.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.\" \/>\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\/hr\/blog\/news\/dostupna-subd-mysql-9-0-0\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.4\" \/>\n\t\t<meta property=\"og:locale\" content=\"hr_HR\" \/>\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 9.0.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 9.0.0. \u0421\u0431\u043e\u0440\u043a\u0438 MySQL Community Server 9.0.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.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/hr\/blog\/news\/dostupna-subd-mysql-9-0-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-07-02T10:05:43+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2024-07-02T10:05:43+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\udd47Dostupan je sustav za upravljanje bazama podataka MySQL 9.0.0 | ProHoster","description":"Tvrtka Oracle je stvorila novu granu sustava za upravljanje bazama podataka MySQL 9.0.0. MySQL Community Server 9.0.0 kompilacije su pripremljene za sve glavne distribucije Linuxa, FreeBSD, macOS i Windows.","canonical_url":"https:\/\/prohoster.info\/hr\/blog\/news\/dostupna-subd-mysql-9-0-0","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"hr_HR","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 9.0.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 9.0.0. \u0421\u0431\u043e\u0440\u043a\u0438 MySQL Community Server 9.0.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.","og:url":"https:\/\/prohoster.info\/hr\/blog\/news\/dostupna-subd-mysql-9-0-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-07-02T10:05:43+00:00","article:modified_time":"2024-07-02T10:05:43+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"116891","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":"2026-01-23 03:19:19","breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2026-01-23 03:19:19","updated":"2026-01-23 03:19:19","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/hr\/wp-json\/wp\/v2\/posts\/116891","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/hr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/hr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/hr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/hr\/wp-json\/wp\/v2\/comments?post=116891"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/hr\/wp-json\/wp\/v2\/posts\/116891\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/hr\/wp-json\/wp\/v2\/media?parent=116891"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/hr\/wp-json\/wp\/v2\/categories?post=116891"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/hr\/wp-json\/wp\/v2\/tags?post=116891"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}