{"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\/cs\/blog\/news\/dostupna-subd-mysql-9-0-0","title":{"rendered":"K dispozici je datab\u00e1zov\u00fd syst\u00e9m MySQL 9.0.0","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Spole\u010dnost Oracle vytvo\u0159ila novou v\u011btev datab\u00e1zov\u00e9ho syst\u00e9mu MySQL 9.0.0. Verze MySQL Community Server 9.0.0 jsou p\u0159ipraveny pro v\u0161echny hlavn\u00ed distribuce Linuxu, FreeBSD, macOS a Windows. V r\u00e1mci modelu vyd\u00e1v\u00e1n\u00ed, kter\u00fd byl zaveden v lo\u0148sk\u00e9m roce, je MySQL 9.0 za\u0159azena do v\u011btve \"Innovation\", do kter\u00e9 budou tak\u00e9 za\u0159azeny n\u00e1sleduj\u00edc\u00ed v\u00fdznamn\u00e9 verze MySQL 9.1 a 9.2. V\u011btve Innovation jsou doporu\u010dov\u00e1ny pro ty, kte\u0159\u00ed cht\u011bj\u00ed rychle z\u00edskat p\u0159\u00edstup k nov\u00fdm funkc\u00edm; jsou vyd\u00e1v\u00e1ny ka\u017ed\u00e9 3 m\u011bs\u00edce a podporov\u00e1ny pouze do vyd\u00e1n\u00ed dal\u0161\u00ed v\u00fdznamn\u00e9 verze (nap\u0159\u00edklad po vyd\u00e1n\u00ed verze 9.1 bude podpora verze 9.0 ukon\u010dena). P\u0159ibli\u017en\u011b za rok pl\u00e1nuj\u00ed vytvo\u0159it LTS verzi, kter\u00e1 bude doporu\u010dena pro nasazen\u00ed, je\u017e pot\u0159ebuj\u00ed p\u0159edv\u00eddatelnost a dlouhodob\u00e9 udr\u017een\u00ed nem\u011bnn\u00e9ho chov\u00e1n\u00ed. Po LTS v\u011btvi bude vytvo\u0159ena nov\u00e1 v\u011btev Innovation \u2014 MySQL 10.0.<\/p>\n<p>Hlavn\u00ed zm\u011bny v MySQL 9.0:<\/p>\n<ul>\n<li class=\"l\"> P\u0159i prov\u00e1d\u011bn\u00ed konstrukce \"EXPLAIN ANALYZE INTO\" byla p\u0159id\u00e1na mo\u017enost ukl\u00e1dat v\u00fdstup ve form\u00e1tu JSON do u\u017eivatelsk\u00e9 prom\u011bnn\u00e9, kter\u00e1 m\u016f\u017ee b\u00fdt n\u00e1sledn\u011b pou\u017eita jako argument v funkc\u00edch pro pr\u00e1ci s JSON.\n<p>   EXPLAIN ANALYZE FORMAT=JSON INTO @variable select_stmt<\/p>\n<li class=\"l\"> Bylo povoleno vytv\u00e1\u0159en\u00ed v\u00fdraz\u016f \"CREATE EVENT\", \"ALTER EVENT\" a \"DROP EVENT\" ve form\u011b parametrizovan\u00fdch dotaz\u016f uvnit\u0159 ulo\u017een\u00fdch procedur. Vytv\u00e1\u0159en\u00ed parametrizovan\u00e9ho dotazu se prov\u00e1d\u00ed pomoc\u00ed v\u00fdrazu PREPARE, a vykon\u00e1v\u00e1n\u00ed \u2014 v\u00fdrazem EXECUTE.\n<p>   CREATE PROCEDURE sp(n INT)<br \/>\n   BEGIN<br \/>\n     SET @s1 = \"CREATE EVENT e ON SCHEDULE EVERY \" ;<br \/>\n     SET @s2 = \" SECOND\"<br \/>\n          STARTS CURRENT_TIMESTAMP + INTERVAL 10 SECOND<br \/>\n          ENDS CURRENT_TIMESTAMP + INTERVAL 2 MINUTE<br \/>\n          ON COMPLETION PRESERVE<br \/>\n          DO<br \/>\n          INSERT INTO d.t VALUES ROW(NULL, NOW(), FLOOR(RAND()*100))\";<\/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   END<\/p>\n<li class=\"l\"> Byly p\u0159id\u00e1ny dv\u011b nov\u00e9 syst\u00e9mov\u00e9 tabulky, obsahuj\u00edc\u00ed informace o syst\u00e9mov\u00fdch prom\u011bnn\u00fdch: variables_metadata \u2014 obsahuje informace o n\u00e1zvech, rozsahu, typech a hodnot\u00e1ch v\u0161ech podporovan\u00fdch syst\u00e9mov\u00fdch prom\u011bnn\u00fdch MySQL serveru; global_variable_attributes \u2014 obsahuje hodnoty atribut\u016f nastaven\u00fdch pro glob\u00e1ln\u00ed prom\u011bnn\u00e9, jako jsou offline_mode a read_only.\n<li class=\"l\"> Byl odstran\u011bn d\u0159\u00edve prohl\u00e1\u0161en\u00fd za zastaral\u00fd serverov\u00fd plugin mysql_native_password, kter\u00fd zaji\u0161\u0165oval autentizaci pomoc\u00ed hesel. Doporu\u010duje se p\u0159ej\u00edt na pou\u017e\u00edv\u00e1n\u00ed pluginu caching_sha2_password, kter\u00fd pou\u017e\u00edv\u00e1 pro hashov\u00e1n\u00ed algoritmus SHA2 m\u00edsto SHA1.\n<li class=\"l\"> Bylo p\u0159id\u00e1no 15 prom\u011bnn\u00fdch pro nastaven\u00ed a inspekci motoru MLE (Multilingual Engine Component), kter\u00fd umo\u017e\u0148uje pou\u017e\u00edvat v ulo\u017een\u00fdch procedur\u00e1ch a funkc\u00edch k\u00f3d v jazyc\u00edch odli\u0161n\u00fdch od SQL.\n<\/ul>\n<p>Zdroj: <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.3 - 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\/cs\/blog\/news\/dostupna-subd-mysql-9-0-0\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.3\" \/>\n\t\t<meta property=\"og:locale\" content=\"cs_CZ\" \/>\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\/cs\/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\udd47Datab\u00e1zov\u00fd syst\u00e9m MySQL 9.0.0 | ProHoster","description":"Spole\u010dnost Oracle vytvo\u0159ila novou v\u011btev datab\u00e1zov\u00e9ho syst\u00e9mu MySQL 9.0.0. Sestaven\u00ed MySQL Community Server 9.0.0 byla p\u0159ipravena pro v\u0161echny hlavn\u00ed distribuce Linuxu, FreeBSD, macOS a Windows.","canonical_url":"https:\/\/prohoster.info\/cs\/blog\/news\/dostupna-subd-mysql-9-0-0","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"cs_CZ","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\/cs\/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\/cs\/wp-json\/wp\/v2\/posts\/116891","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/comments?post=116891"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/posts\/116891\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/media?parent=116891"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/categories?post=116891"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/tags?post=116891"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}