{"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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\"><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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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<p class=\"wp-block-paragraph\">My <a href=\"https:\/\/www.slideshare.net\/freshdaz\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"Olivier DASINI on Slideshare\">Slideshare account<\/a> (<em>archive<\/em>).<\/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 wp-block-paragraph\"><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":{"footnotes":"","jetpack_post_was_ever_published":false},"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":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.9 - aioseo.com -->\n\t<meta name=\"description\" content=\"Presentation of some of the new features of MySQL 8.0.20 released on April 27th, 2020. Highlight Hash JoinsNew InnoDB Doublewrite BufferIndex-Level Optimizer HintsSHOW_ROUTINE PrivilegeMySQL Shell EnhancementsMySQL Router EnhancementsMySQL InnoDB Cluster EnhancementsMySQL Replication EnhancementsMySQL NDB Cluster EnhancementsMySQL Enterprise New FeaturesThanks to the Contributors Slides Download this presentation and others on my SlideShare account. Video Watch this video and others on\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Olivier DASINI\"\/>\n\t<meta name=\"google-site-verification\" content=\"HN6x37mM2NBzUxcsZUKC8OY_DxAioI6oKazYPPNq02c\" \/>\n\t<meta name=\"keywords\" content=\"8.0.20,presentation,summary,video,mysql,new\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/dasini.net\/blog\/2020\/05\/26\/mysql-8-0-20-new-features-summary\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.9\" \/>\n\t\t<meta property=\"og:locale\" content=\"fr_FR\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Data Daz (dasini.net) - Data Systems, AI, and Real-World Insights | Exploring Beyond the Limits of Knowledge\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"MySQL 8.0.20 New Features Summary | Data Daz (dasini.net) - Data Systems, AI, and Real-World Insights\" \/>\n\t\t<meta property=\"og:description\" content=\"Presentation of some of the new features of MySQL 8.0.20 released on April 27th, 2020. Highlight Hash JoinsNew InnoDB Doublewrite BufferIndex-Level Optimizer HintsSHOW_ROUTINE PrivilegeMySQL Shell EnhancementsMySQL Router EnhancementsMySQL InnoDB Cluster EnhancementsMySQL Replication EnhancementsMySQL NDB Cluster EnhancementsMySQL Enterprise New FeaturesThanks to the Contributors Slides Download this presentation and others on my SlideShare account. Video Watch this video and others on\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/dasini.net\/blog\/2020\/05\/26\/mysql-8-0-20-new-features-summary\/\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2020-05-26T08:05:12+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2020-11-28T13:04:58+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary\" \/>\n\t\t<meta name=\"twitter:site\" content=\"@freshdaz\" \/>\n\t\t<meta name=\"twitter:title\" content=\"MySQL 8.0.20 New Features Summary | Data Daz (dasini.net) - Data Systems, AI, and Real-World Insights\" \/>\n\t\t<meta name=\"twitter:description\" content=\"Presentation of some of the new features of MySQL 8.0.20 released on April 27th, 2020. Highlight Hash JoinsNew InnoDB Doublewrite BufferIndex-Level Optimizer HintsSHOW_ROUTINE PrivilegeMySQL Shell EnhancementsMySQL Router EnhancementsMySQL InnoDB Cluster EnhancementsMySQL Replication EnhancementsMySQL NDB Cluster EnhancementsMySQL Enterprise New FeaturesThanks to the Contributors Slides Download this presentation and others on my SlideShare account. Video Watch this video and others on\" \/>\n\t\t<meta name=\"twitter:creator\" content=\"@freshdaz\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/2020\\\/05\\\/26\\\/mysql-8-0-20-new-features-summary\\\/#article\",\"name\":\"MySQL 8.0.20 New Features Summary | Data Daz (dasini.net) - Data Systems, AI, and Real-World Insights\",\"headline\":\"MySQL 8.0.20 New Features Summary\",\"author\":{\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/author\\\/freshdaz\\\/#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/#person\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"http:\\\/\\\/dasini.net\\\/blog\\\/wp-content\\\/uploads\\\/Sakila_on_a_Rock_mozaik_600x333_by_olivier_dasini.JPG\",\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/2020\\\/05\\\/26\\\/mysql-8-0-20-new-features-summary\\\/#articleImage\"},\"datePublished\":\"2020-05-26T09:05:12+01:00\",\"dateModified\":\"2020-11-28T14:04:58+01:00\",\"inLanguage\":\"fr-FR\",\"commentCount\":3,\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/2020\\\/05\\\/26\\\/mysql-8-0-20-new-features-summary\\\/#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/2020\\\/05\\\/26\\\/mysql-8-0-20-new-features-summary\\\/#webpage\"},\"articleSection\":\"MySQL, New, Video, 8.0.20, Presentation, Summary, video, English\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/2020\\\/05\\\/26\\\/mysql-8-0-20-new-features-summary\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/dasini.net\\\/blog#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/dasini.net\\\/blog\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/category\\\/mysql-en\\\/#listItem\",\"name\":\"MySQL\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/category\\\/mysql-en\\\/#listItem\",\"position\":2,\"name\":\"MySQL\",\"item\":\"https:\\\/\\\/dasini.net\\\/blog\\\/category\\\/mysql-en\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/2020\\\/05\\\/26\\\/mysql-8-0-20-new-features-summary\\\/#listItem\",\"name\":\"MySQL 8.0.20 New Features Summary\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/dasini.net\\\/blog#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/2020\\\/05\\\/26\\\/mysql-8-0-20-new-features-summary\\\/#listItem\",\"position\":3,\"name\":\"MySQL 8.0.20 New Features Summary\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/category\\\/mysql-en\\\/#listItem\",\"name\":\"MySQL\"}}]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/#person\",\"name\":\"Olivier DASINI\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/2020\\\/05\\\/26\\\/mysql-8-0-20-new-features-summary\\\/#personImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d46da4fb4b99ea9ce527a93ce9b998a446577e42e1f132d8437235fa5b963636?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"Olivier DASINI\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/author\\\/freshdaz\\\/#author\",\"url\":\"https:\\\/\\\/dasini.net\\\/blog\\\/author\\\/freshdaz\\\/\",\"name\":\"Olivier DASINI\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/2020\\\/05\\\/26\\\/mysql-8-0-20-new-features-summary\\\/#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d46da4fb4b99ea9ce527a93ce9b998a446577e42e1f132d8437235fa5b963636?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"Olivier DASINI\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/2020\\\/05\\\/26\\\/mysql-8-0-20-new-features-summary\\\/#webpage\",\"url\":\"https:\\\/\\\/dasini.net\\\/blog\\\/2020\\\/05\\\/26\\\/mysql-8-0-20-new-features-summary\\\/\",\"name\":\"MySQL 8.0.20 New Features Summary | Data Daz (dasini.net) - Data Systems, AI, and Real-World Insights\",\"description\":\"Presentation of some of the new features of MySQL 8.0.20 released on April 27th, 2020. Highlight Hash JoinsNew InnoDB Doublewrite BufferIndex-Level Optimizer HintsSHOW_ROUTINE PrivilegeMySQL Shell EnhancementsMySQL Router EnhancementsMySQL InnoDB Cluster EnhancementsMySQL Replication EnhancementsMySQL NDB Cluster EnhancementsMySQL Enterprise New FeaturesThanks to the Contributors Slides Download this presentation and others on my SlideShare account. Video Watch this video and others on\",\"inLanguage\":\"fr-FR\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/2020\\\/05\\\/26\\\/mysql-8-0-20-new-features-summary\\\/#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/author\\\/freshdaz\\\/#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/author\\\/freshdaz\\\/#author\"},\"datePublished\":\"2020-05-26T09:05:12+01:00\",\"dateModified\":\"2020-11-28T14:04:58+01:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/dasini.net\\\/blog\\\/\",\"name\":\"dasini.net - Diary of a MySQL expert\",\"description\":\"Exploring Beyond the Limits of Knowledge\",\"inLanguage\":\"fr-FR\",\"publisher\":{\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/#person\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"MySQL 8.0.20 New Features Summary | Data Daz (dasini.net) - Data Systems, AI, and Real-World Insights","description":"Presentation of some of the new features of MySQL 8.0.20 released on April 27th, 2020. Highlight Hash JoinsNew InnoDB Doublewrite BufferIndex-Level Optimizer HintsSHOW_ROUTINE PrivilegeMySQL Shell EnhancementsMySQL Router EnhancementsMySQL InnoDB Cluster EnhancementsMySQL Replication EnhancementsMySQL NDB Cluster EnhancementsMySQL Enterprise New FeaturesThanks to the Contributors Slides Download this presentation and others on my SlideShare account. Video Watch this video and others on","canonical_url":"https:\/\/dasini.net\/blog\/2020\/05\/26\/mysql-8-0-20-new-features-summary\/","robots":"max-image-preview:large","keywords":"8.0.20,presentation,summary,video,mysql,new","webmasterTools":{"google-site-verification":"HN6x37mM2NBzUxcsZUKC8OY_DxAioI6oKazYPPNq02c","miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dasini.net\/blog\/2020\/05\/26\/mysql-8-0-20-new-features-summary\/#article","name":"MySQL 8.0.20 New Features Summary | Data Daz (dasini.net) - Data Systems, AI, and Real-World Insights","headline":"MySQL 8.0.20 New Features Summary","author":{"@id":"https:\/\/dasini.net\/blog\/author\/freshdaz\/#author"},"publisher":{"@id":"https:\/\/dasini.net\/blog\/#person"},"image":{"@type":"ImageObject","url":"http:\/\/dasini.net\/blog\/wp-content\/uploads\/Sakila_on_a_Rock_mozaik_600x333_by_olivier_dasini.JPG","@id":"https:\/\/dasini.net\/blog\/2020\/05\/26\/mysql-8-0-20-new-features-summary\/#articleImage"},"datePublished":"2020-05-26T09:05:12+01:00","dateModified":"2020-11-28T14:04:58+01:00","inLanguage":"fr-FR","commentCount":3,"mainEntityOfPage":{"@id":"https:\/\/dasini.net\/blog\/2020\/05\/26\/mysql-8-0-20-new-features-summary\/#webpage"},"isPartOf":{"@id":"https:\/\/dasini.net\/blog\/2020\/05\/26\/mysql-8-0-20-new-features-summary\/#webpage"},"articleSection":"MySQL, New, Video, 8.0.20, Presentation, Summary, video, English"},{"@type":"BreadcrumbList","@id":"https:\/\/dasini.net\/blog\/2020\/05\/26\/mysql-8-0-20-new-features-summary\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/dasini.net\/blog#listItem","position":1,"name":"Home","item":"https:\/\/dasini.net\/blog","nextItem":{"@type":"ListItem","@id":"https:\/\/dasini.net\/blog\/category\/mysql-en\/#listItem","name":"MySQL"}},{"@type":"ListItem","@id":"https:\/\/dasini.net\/blog\/category\/mysql-en\/#listItem","position":2,"name":"MySQL","item":"https:\/\/dasini.net\/blog\/category\/mysql-en\/","nextItem":{"@type":"ListItem","@id":"https:\/\/dasini.net\/blog\/2020\/05\/26\/mysql-8-0-20-new-features-summary\/#listItem","name":"MySQL 8.0.20 New Features Summary"},"previousItem":{"@type":"ListItem","@id":"https:\/\/dasini.net\/blog#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/dasini.net\/blog\/2020\/05\/26\/mysql-8-0-20-new-features-summary\/#listItem","position":3,"name":"MySQL 8.0.20 New Features Summary","previousItem":{"@type":"ListItem","@id":"https:\/\/dasini.net\/blog\/category\/mysql-en\/#listItem","name":"MySQL"}}]},{"@type":"Person","@id":"https:\/\/dasini.net\/blog\/#person","name":"Olivier DASINI","image":{"@type":"ImageObject","@id":"https:\/\/dasini.net\/blog\/2020\/05\/26\/mysql-8-0-20-new-features-summary\/#personImage","url":"https:\/\/secure.gravatar.com\/avatar\/d46da4fb4b99ea9ce527a93ce9b998a446577e42e1f132d8437235fa5b963636?s=96&d=mm&r=g","width":96,"height":96,"caption":"Olivier DASINI"}},{"@type":"Person","@id":"https:\/\/dasini.net\/blog\/author\/freshdaz\/#author","url":"https:\/\/dasini.net\/blog\/author\/freshdaz\/","name":"Olivier DASINI","image":{"@type":"ImageObject","@id":"https:\/\/dasini.net\/blog\/2020\/05\/26\/mysql-8-0-20-new-features-summary\/#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/d46da4fb4b99ea9ce527a93ce9b998a446577e42e1f132d8437235fa5b963636?s=96&d=mm&r=g","width":96,"height":96,"caption":"Olivier DASINI"}},{"@type":"WebPage","@id":"https:\/\/dasini.net\/blog\/2020\/05\/26\/mysql-8-0-20-new-features-summary\/#webpage","url":"https:\/\/dasini.net\/blog\/2020\/05\/26\/mysql-8-0-20-new-features-summary\/","name":"MySQL 8.0.20 New Features Summary | Data Daz (dasini.net) - Data Systems, AI, and Real-World Insights","description":"Presentation of some of the new features of MySQL 8.0.20 released on April 27th, 2020. Highlight Hash JoinsNew InnoDB Doublewrite BufferIndex-Level Optimizer HintsSHOW_ROUTINE PrivilegeMySQL Shell EnhancementsMySQL Router EnhancementsMySQL InnoDB Cluster EnhancementsMySQL Replication EnhancementsMySQL NDB Cluster EnhancementsMySQL Enterprise New FeaturesThanks to the Contributors Slides Download this presentation and others on my SlideShare account. Video Watch this video and others on","inLanguage":"fr-FR","isPartOf":{"@id":"https:\/\/dasini.net\/blog\/#website"},"breadcrumb":{"@id":"https:\/\/dasini.net\/blog\/2020\/05\/26\/mysql-8-0-20-new-features-summary\/#breadcrumblist"},"author":{"@id":"https:\/\/dasini.net\/blog\/author\/freshdaz\/#author"},"creator":{"@id":"https:\/\/dasini.net\/blog\/author\/freshdaz\/#author"},"datePublished":"2020-05-26T09:05:12+01:00","dateModified":"2020-11-28T14:04:58+01:00"},{"@type":"WebSite","@id":"https:\/\/dasini.net\/blog\/#website","url":"https:\/\/dasini.net\/blog\/","name":"dasini.net - Diary of a MySQL expert","description":"Exploring Beyond the Limits of Knowledge","inLanguage":"fr-FR","publisher":{"@id":"https:\/\/dasini.net\/blog\/#person"}}]},"og:locale":"fr_FR","og:site_name":"Data Daz (dasini.net) - Data Systems, AI, and Real-World Insights | Exploring Beyond the Limits of Knowledge","og:type":"article","og:title":"MySQL 8.0.20 New Features Summary | Data Daz (dasini.net) - Data Systems, AI, and Real-World Insights","og:description":"Presentation of some of the new features of MySQL 8.0.20 released on April 27th, 2020. Highlight Hash JoinsNew InnoDB Doublewrite BufferIndex-Level Optimizer HintsSHOW_ROUTINE PrivilegeMySQL Shell EnhancementsMySQL Router EnhancementsMySQL InnoDB Cluster EnhancementsMySQL Replication EnhancementsMySQL NDB Cluster EnhancementsMySQL Enterprise New FeaturesThanks to the Contributors Slides Download this presentation and others on my SlideShare account. Video Watch this video and others on","og:url":"https:\/\/dasini.net\/blog\/2020\/05\/26\/mysql-8-0-20-new-features-summary\/","article:published_time":"2020-05-26T08:05:12+00:00","article:modified_time":"2020-11-28T13:04:58+00:00","twitter:card":"summary","twitter:site":"@freshdaz","twitter:title":"MySQL 8.0.20 New Features Summary | Data Daz (dasini.net) - Data Systems, AI, and Real-World Insights","twitter:description":"Presentation of some of the new features of MySQL 8.0.20 released on April 27th, 2020. Highlight Hash JoinsNew InnoDB Doublewrite BufferIndex-Level Optimizer HintsSHOW_ROUTINE PrivilegeMySQL Shell EnhancementsMySQL Router EnhancementsMySQL InnoDB Cluster EnhancementsMySQL Replication EnhancementsMySQL NDB Cluster EnhancementsMySQL Enterprise New FeaturesThanks to the Contributors Slides Download this presentation and others on my SlideShare account. Video Watch this video and others on","twitter:creator":"@freshdaz"},"aioseo_meta_data":{"post_id":"3720","title":null,"description":"","keywords":"","keyphrases":null,"primary_term":null,"canonical_url":"","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":[],"defaultGraph":"","defaultPostTypeGraph":""},"schema_type":null,"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,"location":null,"local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":null,"created":"2020-12-21 12:18:58","updated":"2025-06-24 10:00:23","seo_analyzer_scan_date":null},"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}]}}