{"id":3140,"date":"2019-06-05T11:33:12","date_gmt":"2019-06-05T10:33:12","guid":{"rendered":"http:\/\/dasini.net\/blog\/?p=3140"},"modified":"2020-11-28T14:08:20","modified_gmt":"2020-11-28T13:08:20","slug":"resume-des-nouveautes-de-mysql-8-0-16","status":"publish","type":"post","link":"https:\/\/dasini.net\/blog\/2019\/06\/05\/resume-des-nouveautes-de-mysql-8-0-16\/","title":{"rendered":"R\u00e9sum\u00e9 des nouveaut\u00e9s de MySQL 8.0.16"},"content":{"rendered":"\n<figure class=\"wp-block-image\"><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/Sakila_on_a_Rock_mozaik_600x333_by_olivier_dasini.JPG\" alt=\"Sakila mozaik by Olivier DASINI\"\/><\/figure>\n\n\n\n<p>J&rsquo;ai cr\u00e9\u00e9, sp\u00e9cialement pour toi, une pr\u00e9sentation qui r\u00e9sume les nouvelles fonctionnalit\u00e9s de la derni\u00e8re version de <a rel=\"noreferrer noopener\" aria-label=\"MySQL (opens in a new tab)\" href=\"https:\/\/dev.mysql.com\/downloads\/\" target=\"_blank\">MySQL<\/a> en date, la 8.0.<strong>16<\/strong>.<\/p>\n\n\n\n<p>Je te propose une vid\u00e9o, en fran\u00e7ais, de moins de 10 minutes ainsi que les slides (en anglais) \u00e0 t\u00e9l\u00e9charger.<\/p>\n\n\n\n<p><u>Au programme<\/u>:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>mysql_upgrade is no longer necessary<\/li><li>CHECK Constraints<\/li><li>Constant-Folding Optimization<\/li><li>SYSTEM_USER &amp; partial_revokes<\/li><li>Chinese collation for utf8mb4<\/li><li>Performance Schema keyring_keys table<\/li><li>MySQL Shell Enhancements<\/li><li>MySQL Router Enhancements<\/li><li>InnoDB Cluster Enhancements<\/li><li>Group Replication Enhancements<\/li><li>Size of the binary tarball for Linux<\/li><li>Server quick settings validation<\/li><li>Thanks to the Contributor<\/li><\/ul>\n\n\n\n\n\n<p>La pr\u00e9sentation, en fran\u00e7ais, est disponible sur ma toute nouvelle cha\u00eene <a href=\"https:\/\/www.youtube.com\/channel\/UC12TulyJsJZHoCmby3Nm3WQ\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"Youtube (opens in a new tab)\">Youtube<\/a>.<\/p>\n\n\n\n<figure class=\"wp-block-embed-youtube wp-block-embed is-type-video is-provider-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"MySQL 8 0 16 New Features Summary\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/3_esLnhHHck?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<p>Pour s&rsquo;y abonner c&rsquo;est <a href=\"https:\/\/www.youtube.com\/channel\/UC12TulyJsJZHoCmby3Nm3WQ\/?sub_confirmation=1\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"ici (opens in a new tab)\">ici<\/a>.<\/p>\n\n\n\n\n\n<p>Les slides sont disponibles et t\u00e9l\u00e9chargeables sur mon compte <a rel=\"noreferrer noopener\" aria-label=\"Slideshare (opens in a new tab)\" href=\"https:\/\/www.slideshare.net\/freshdaz\/\" target=\"_blank\">SlideShare<\/a>:<\/p>\n\n\n\n<figure class=\"wp-block-embed-slideshare wp-block-embed is-type-rich is-provider-slideshare wp-embed-aspect-1-1 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"MySQL 8.0.16 New Features Summary\" src=\"https:\/\/www.slideshare.net\/slideshow\/embed_code\/key\/4R4Oj98fzNLvlp\" width=\"427\" height=\"356\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" style=\"border:1px solid #CCC; border-width:1px; margin-bottom:5px; max-width: 100%;\" allowfullscreen> <\/iframe> <div style=\"margin-bottom:5px\"> <strong> <a href=\"https:\/\/www.slideshare.net\/slideshow\/mysql-8016-new-features-summary\/148852698\" title=\"MySQL 8.0.16 New Features Summary\" target=\"_blank\">MySQL 8.0.16 New Features Summary<\/a> <\/strong> from <strong><a href=\"https:\/\/www.slideshare.net\/freshdaz\" target=\"_blank\">Olivier DASINI<\/a><\/strong> <\/div>\n<\/div><\/figure>\n\n\n\n\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<p><strong><span style=\"text-decoration: underline;\">Ces articles devraient t&rsquo;int\u00e9resser<\/span><\/strong>:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"http:\/\/dasini.net\/blog\/2020\/11\/10\/resume-des-nouveautes-de-mysql-8-0-22\/\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"R\u00e9sum\u00e9 des nouveaut\u00e9s de MySQL 8.0.22\">R\u00e9sum\u00e9 des nouveaut\u00e9s de MySQL 8.0.22<\/a><\/li><li><a href=\"http:\/\/dasini.net\/blog\/2020\/08\/27\/resume-des-nouveautes-de-mysql-8-0-21\/\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"R\u00e9sum\u00e9 des nouveaut\u00e9s de MySQL 8.0.21\">R\u00e9sum\u00e9 des nouveaut\u00e9s de MySQL 8.0.21<\/a><\/li><li><a href=\"http:\/\/dasini.net\/blog\/2020\/05\/26\/mysql-8-0-20-new-features-summary\/\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"MySQL 8.0.20 New Features Summary\">MySQL 8.0.20 New Features Summary<\/a><\/li><li><a href=\"http:\/\/dasini.net\/blog\/2020\/02\/17\/mysql-8-0-19-new-features-summary\/\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"MySQL 8.0.19 New Features Summary\">MySQL 8.0.19 New Features Summary<\/a><\/li><li><a href=\"http:\/\/dasini.net\/blog\/2019\/11\/26\/mysql-8-0-18-new-features-summary\/\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"R\u00e9sum\u00e9 des nouveaut\u00e9s de MySQL 8.0.18\">R\u00e9sum\u00e9 des nouveaut\u00e9s de MySQL 8.0.18<\/a><\/li><li><a href=\"http:\/\/dasini.net\/blog\/2019\/09\/19\/resume-des-nouveautes-de-mysql-8-0-17\/\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"R\u00e9sum\u00e9 des nouveaut\u00e9s de MySQL 8.0.17\">R\u00e9sum\u00e9 des nouveaut\u00e9s de MySQL 8.0.17<\/a><\/li><li><a href=\"http:\/\/dasini.net\/blog\/2019\/06\/05\/resume-des-nouveautes-de-mysql-8-0-16\/\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"R\u00e9sum\u00e9 des nouveaut\u00e9s de MySQL 8.0.16\">R\u00e9sum\u00e9 des nouveaut\u00e9s de MySQL 8.0.16<\/a><\/li><\/ul>\n\n\n<\/div><\/div>\n\n\n\n\n\n\n\n<div style=\"height:75px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-vivid-red-color has-text-color\"><strong>Thanks for using MySQL!<\/strong><\/p>\n\n\n\n<div style=\"height:25px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><a href=\"https:\/\/www.linkedin.com\/groups\/12524512\/\" target=\"_blank\" rel=\"noopener\" title=\"Olivier DASINI on Linkedin\">Follow me on Linkedin<\/a><\/p>\n\n\n\n<p>Watch my videos on my <a href=\"https:\/\/www.youtube.com\/channel\/UC12TulyJsJZHoCmby3Nm3WQ\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"Olivier's MySQL Channel\">YouTube channel<\/a> and <a href=\"https:\/\/www.youtube.com\/channel\/UC12TulyJsJZHoCmby3Nm3WQ\/?sub_confirmation=1\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"Subscribe\">subscribe<\/a>.<\/p>\n\n\n\n<p>My <a href=\"https:\/\/www.slideshare.net\/freshdaz\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"Olivier DASINI on Slideshare\">Slideshare account<\/a>.<\/p>\n\n\n\n<p>My <a href=\"https:\/\/speakerdeck.com\/freshdaz\/\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"Olivier DASINI on Speaker Deck\">Speaker Deck account<\/a>.<\/p>\n\n\n\n<div style=\"height:25px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-vivid-red-color has-text-color\"><strong>Thanks for using HeatWave &amp; MySQL!<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>J&rsquo;ai cr\u00e9\u00e9, sp\u00e9cialement pour toi, une pr\u00e9sentation qui r\u00e9sume les nouvelles fonctionnalit\u00e9s de la derni\u00e8re version de MySQL en date, la 8.0.16.<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"footnotes":""},"categories":[282,8,39],"tags":[],"class_list":["post-3140","post","type-post","status-publish","format-standard","hentry","category-group-replication","category-mysql","category-presentation"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9LfWW-OE","jetpack-related-posts":[{"id":3492,"url":"https:\/\/dasini.net\/blog\/2019\/11\/26\/resume-des-nouveautes-de-mysql-8-0-18\/","url_meta":{"origin":3140,"position":0},"title":"R\u00e9sum\u00e9 des nouveaut\u00e9s de MySQL 8.0.18","author":"Olivier DASINI","date":"26 novembre 2019","format":false,"excerpt":"J'ai cr\u00e9\u00e9, sp\u00e9cialement pour toi, une pr\u00e9sentation qui r\u00e9sume les nouvelles fonctionnalit\u00e9s de la derni\u00e8re version de MySQL en date, la 8.0.18.","rel":"","context":"Dans &quot;MySQL&quot;","block_context":{"text":"MySQL","link":"https:\/\/dasini.net\/blog\/category\/mysql\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3469,"url":"https:\/\/dasini.net\/blog\/2019\/09\/19\/resume-des-nouveautes-de-mysql-8-0-17\/","url_meta":{"origin":3140,"position":1},"title":"R\u00e9sum\u00e9 des nouveaut\u00e9s de MySQL 8.0.17","author":"Olivier DASINI","date":"19 septembre 2019","format":false,"excerpt":"J'ai cr\u00e9\u00e9, sp\u00e9cialement pour toi, une pr\u00e9sentation qui r\u00e9sume les nouvelles fonctionnalit\u00e9s de la derni\u00e8re version de MySQL en date, la 8.0.17. Je te propose une vid\u00e9o, en fran\u00e7ais, de moins de 5 minutes ainsi que les slides (en anglais) \u00e0 t\u00e9l\u00e9charger.","rel":"","context":"Dans &quot;MySQL&quot;","block_context":{"text":"MySQL","link":"https:\/\/dasini.net\/blog\/category\/mysql\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/img.youtube.com\/vi\/BxenbgcKdPQ\/0.jpg?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":3969,"url":"https:\/\/dasini.net\/blog\/2020\/11\/10\/resume-des-nouveautes-de-mysql-8-0-22\/","url_meta":{"origin":3140,"position":2},"title":"R\u00e9sum\u00e9 des nouveaut\u00e9s de MySQL 8.0.22","author":"Olivier DASINI","date":"10 novembre 2020","format":false,"excerpt":"J'ai cr\u00e9\u00e9, sp\u00e9cialement pour toi, une pr\u00e9sentation qui r\u00e9sume les nouvelles fonctionnalit\u00e9s de la derni\u00e8re version de MySQL, sortie le 19 octobre 2020, la 8.0.22.","rel":"","context":"Dans &quot;MySQL&quot;","block_context":{"text":"MySQL","link":"https:\/\/dasini.net\/blog\/category\/mysql\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/img.youtube.com\/vi\/CFFcaqhN-W8\/0.jpg?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":3751,"url":"https:\/\/dasini.net\/blog\/2020\/08\/27\/resume-des-nouveautes-de-mysql-8-0-21\/","url_meta":{"origin":3140,"position":3},"title":"R\u00e9sum\u00e9 des nouveaut\u00e9s de MySQL 8.0.21","author":"Olivier DASINI","date":"27 ao\u00fbt 2020","format":false,"excerpt":"J'ai cr\u00e9\u00e9, sp\u00e9cialement pour toi, une pr\u00e9sentation qui r\u00e9sume les nouvelles fonctionnalit\u00e9s de la derni\u00e8re version de MySQL, sortie le 13 juillet 2020, la 8.0.21.","rel":"","context":"Dans &quot;MySQL&quot;","block_context":{"text":"MySQL","link":"https:\/\/dasini.net\/blog\/category\/mysql\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3762,"url":"https:\/\/dasini.net\/blog\/2020\/09\/10\/webinar-migrer-vers-mysql-8-0\/","url_meta":{"origin":3140,"position":4},"title":"Webinar &#8211; Migrer vers MySQL 8.0","author":"Olivier DASINI","date":"10 septembre 2020","format":false,"excerpt":"MySQL 8.0 est la derni\u00e8re GA - version conseill\u00e9e pour la production - de la base de donn\u00e9es la plus populaire au monde, disponible depuis 2018. Cette pr\u00e9sentation vous donnera les bonnes pratiques et les astuces pour vous aider \u00e0 migrer votre base de donn\u00e9es de mani\u00e8re fluide. Pourquoi migrer\u2026","rel":"","context":"Dans &quot;Conf\u00e9rence&quot;","block_context":{"text":"Conf\u00e9rence","link":"https:\/\/dasini.net\/blog\/category\/conference\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3780,"url":"https:\/\/dasini.net\/blog\/2020\/10\/01\/presentation-de-mysql-enterprise-edition\/","url_meta":{"origin":3140,"position":5},"title":"Pr\u00e9sentation de MySQL Enterprise Edition","author":"Olivier DASINI","date":"1 octobre 2020","format":false,"excerpt":"MySQL Enterprise Edition, c'est un ensemble de fonctionnalit\u00e9s avanc\u00e9es, d'outils et de services dont le but est de vous permettre de passer moins de temps sur les probl\u00e8mes de gestions des donn\u00e9es, de performances et de s\u00e9curit\u00e9s, afin de pouvoir vous consacrer \u00e0 vos probl\u00e9matiques m\u00e9tiers.","rel":"","context":"Dans &quot;MySQL&quot;","block_context":{"text":"MySQL","link":"https:\/\/dasini.net\/blog\/category\/mysql\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/img.youtube.com\/vi\/CtRIc6Hsia8\/0.jpg?resize=350%2C200","width":350,"height":200},"classes":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts\/3140","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/comments?post=3140"}],"version-history":[{"count":18,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts\/3140\/revisions"}],"predecessor-version":[{"id":4042,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts\/3140\/revisions\/4042"}],"wp:attachment":[{"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/media?parent=3140"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/categories?post=3140"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/tags?post=3140"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}