{"id":3720,"date":"2020-05-26T09:05:12","date_gmt":"2020-05-26T08:05:12","guid":{"rendered":"http:\/\/dasini.net\/blog\/?p=3720"},"modified":"2020-11-28T14:04:58","modified_gmt":"2020-11-28T13:04:58","slug":"mysql-8-0-20-new-features-summary","status":"publish","type":"post","link":"https:\/\/dasini.net\/blog\/2020\/05\/26\/mysql-8-0-20-new-features-summary\/","title":{"rendered":"MySQL 8.0.20 New Features Summary"},"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>Presentation of some of the new features of&nbsp;<a rel=\"noreferrer noopener\" href=\"https:\/\/dev.mysql.com\/downloads\/\" target=\"_blank\">MySQL<\/a>&nbsp;8.0.<strong>20<\/strong>&nbsp;released on April 27th, 2020.<\/p>\n\n\n\n\n\n<h2 class=\"wp-block-heading\">Highlight<\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li>Hash Joins<\/li><li>New InnoDB Doublewrite Buffer<\/li><li>Index-Level Optimizer Hints<\/li><li>SHOW_ROUTINE Privilege<\/li><li>MySQL Shell Enhancements<\/li><li>MySQL Router Enhancements<\/li><li>MySQL InnoDB Cluster Enhancements<\/li><li>MySQL Replication Enhancements<\/li><li>MySQL NDB Cluster Enhancements<\/li><li>MySQL Enterprise New Features<\/li><li>Thanks to the Contributors<\/li><\/ul>\n\n\n\n\n\n<h2 class=\"wp-block-heading\">Slides<\/h2>\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.20 - New Features Summary\" src=\"https:\/\/www.slideshare.net\/slideshow\/embed_code\/key\/LDSrdbxcrQglF7\" 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-8020-new-features-summary\/234575664\" title=\"MySQL 8.0.20 - New Features Summary\" target=\"_blank\">MySQL 8.0.20 &#8211; 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<p>Download this presentation and others on my&nbsp;<a rel=\"noreferrer noopener\" href=\"https:\/\/www.slideshare.net\/freshdaz\/\" target=\"_blank\" class=\"aioseop-link\">SlideShare account<\/a>.<\/p>\n\n\n\n\n\n<h2 class=\"wp-block-heading\">Video<\/h2>\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.20 - New Features Summary\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/iJp9npOJWFw?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\n\n<p>Watch this video and others on my <a aria-label=\"YouTube channel (opens in a new tab)\" href=\"https:\/\/www.youtube.com\/channel\/UC12TulyJsJZHoCmby3Nm3WQ\" target=\"_blank\" rel=\"noreferrer noopener\" class=\"aioseop-link\">YouTube channel<\/a>.<\/p>\n\n\n\n\n\n<h2 class=\"wp-block-heading\">That might interest you<\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"http:\/\/dasini.net\/blog\/2020\/11\/10\/mysql-8-0-22-new-features-summary\/\" title=\"MySQL 8.0.22 New Features Summary\" target=\"_blank\" rel=\"noreferrer noopener\">MySQL 8.0.22 New Features Summary<\/a><\/li><li><a href=\"http:\/\/dasini.net\/blog\/2020\/08\/27\/mysql-8-0-21-new-features-summary\/\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"MySQL 8.0.21 New Features Summary\">MySQL 8.0.21 New Features Summary<\/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\/\" title=\"MySQL 8.0.18 New Features Summary\" target=\"_blank\" rel=\"noreferrer noopener\">MySQL 8.0.18 New Features Summary<\/a><\/li><li><a href=\"http:\/\/dasini.net\/blog\/2019\/09\/19\/mysql-8-0-17-new-features-summary\/\" title=\"MySQL 8.0.17 \u2013 New Features Summary\" target=\"_blank\" rel=\"noreferrer noopener\">MySQL 8.0.17 \u2013 New Features Summary<\/a><\/li><li><a href=\"http:\/\/dasini.net\/blog\/2019\/06\/05\/mysql-8-0-16-new-features-summary\/\" title=\"MySQL 8.0.16 New Features Summary\" target=\"_blank\" rel=\"noreferrer noopener\">MySQL 8.0.16 New Features Summary<\/a><\/li><\/ul>\n\n\n\n\n\n\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>Presentation of some of the new features of MySQL 8.0.20 released on April 27th, 2020.<\/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":[203,1618,1105],"tags":[1631,1624,1126,1106],"class_list":["post-3720","post","type-post","status-publish","format-standard","hentry","category-mysql-en","category-new","category-video","tag-8-0-20","tag-presentation-2","tag-summary","tag-video"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9LfWW-Y0","jetpack-related-posts":[{"id":3157,"url":"https:\/\/dasini.net\/blog\/2019\/06\/05\/mysql-8-0-16-new-features-summary\/","url_meta":{"origin":3720,"position":0},"title":"MySQL 8.0.16 New Features Summary","author":"Olivier DASINI","date":"5 juin 2019","format":false,"excerpt":"Presentation of some of the new features of MySQL 8.0.16 released on April 25, 2019","rel":"","context":"Dans &quot;Group Replication&quot;","block_context":{"text":"Group Replication","link":"https:\/\/dasini.net\/blog\/category\/group-replication-en\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/img.youtube.com\/vi\/3_esLnhHHck\/0.jpg?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":3747,"url":"https:\/\/dasini.net\/blog\/2020\/08\/27\/mysql-8-0-21-new-features-summary\/","url_meta":{"origin":3720,"position":1},"title":"MySQL 8.0.21 New Features Summary","author":"Olivier DASINI","date":"27 ao\u00fbt 2020","format":false,"excerpt":"Presentation of some of the new features of MySQL 8.0.21 released on July 13th, 2020.","rel":"","context":"Dans &quot;MySQL&quot;","block_context":{"text":"MySQL","link":"https:\/\/dasini.net\/blog\/category\/mysql-en\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3503,"url":"https:\/\/dasini.net\/blog\/2020\/02\/17\/mysql-8-0-19-new-features-summary\/","url_meta":{"origin":3720,"position":2},"title":"MySQL 8.0.19 New Features Summary","author":"Olivier DASINI","date":"17 f\u00e9vrier 2020","format":false,"excerpt":"Presentation of some of the new features of MySQL 8.0.19 released on January 13, 2020.","rel":"","context":"Dans &quot;High Availability&quot;","block_context":{"text":"High Availability","link":"https:\/\/dasini.net\/blog\/category\/high-availability\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3481,"url":"https:\/\/dasini.net\/blog\/2019\/11\/26\/mysql-8-0-18-new-features-summary\/","url_meta":{"origin":3720,"position":3},"title":"MySQL 8.0.18 New Features Summary","author":"Olivier DASINI","date":"26 novembre 2019","format":false,"excerpt":"Presentation of some of the new features of MySQL 8.0.18 released on October 14, 2019.","rel":"","context":"Dans &quot;Group Replication&quot;","block_context":{"text":"Group Replication","link":"https:\/\/dasini.net\/blog\/category\/group-replication-en\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3957,"url":"https:\/\/dasini.net\/blog\/2020\/11\/10\/mysql-8-0-22-new-features-summary\/","url_meta":{"origin":3720,"position":4},"title":"MySQL 8.0.22 New Features Summary","author":"Olivier DASINI","date":"10 novembre 2020","format":false,"excerpt":"Presentation of some of the new features of MySQL 8.0.22 released on October 19th, 2020.","rel":"","context":"Dans &quot;MySQL&quot;","block_context":{"text":"MySQL","link":"https:\/\/dasini.net\/blog\/category\/mysql-en\/"},"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":3463,"url":"https:\/\/dasini.net\/blog\/2019\/09\/19\/mysql-8-0-17-new-features-summary\/","url_meta":{"origin":3720,"position":5},"title":"MySQL 8.0.17 &#8211; New Features Summary","author":"Olivier DASINI","date":"19 septembre 2019","format":false,"excerpt":"This presentation is a summary of the MySQL 8.0.17 new features.","rel":"","context":"Dans &quot;Group Replication&quot;","block_context":{"text":"Group Replication","link":"https:\/\/dasini.net\/blog\/category\/group-replication-en\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts\/3720","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=3720"}],"version-history":[{"count":7,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts\/3720\/revisions"}],"predecessor-version":[{"id":4034,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts\/3720\/revisions\/4034"}],"wp:attachment":[{"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/media?parent=3720"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/categories?post=3720"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/tags?post=3720"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}