{"id":6684,"date":"2022-05-24T18:14:07","date_gmt":"2022-05-25T01:14:07","guid":{"rendered":"https:\/\/en.pingcap.com\/?post_type=event&#038;p=6684"},"modified":"2024-07-16T05:02:54","modified_gmt":"2024-07-16T12:02:54","slug":"inside-out-tidbs-sql-engine","status":"publish","type":"event","link":"https:\/\/www.pingcap.com\/ko\/event\/inside-out-tidbs-sql-engine\/","title":{"rendered":"Inside Out: TiDB&#8217;s SQL Engine"},"content":{"rendered":"\n<p><strong>Time: <\/strong>May 31, 5:30 PM Pacific Daylight Time.<\/p>\n\n\n\n<p>Join us at our Sunnyvale office for dinner and drinks! If you can\u2019t make it in person, then check out our livestream. &nbsp;&nbsp;<\/p>\n\n\n\n<p>Sign up today to reserve your seat! Address and links will be emailed to you.<\/p>\n\n\n\n<p>The SQL optimizer is one of the most complicated database components. Even after decades of evolution, it continues to fascinate database enthusiasts. In this meetup, we will talk about TiDB&#8217;s experience with the query optimizer. Yu Dong will start with an overview and talk about some of its key components. He&#8217;ll also discuss the challenges, opportunities, and evolution behind the optimizer in an HTAP system. Finally, Yu will share some tuning practices for TiDB users as well as some features to come. Ed Huang will provide some practical insights on TiDB&#8217;s SQL optimizer.<\/p>\n\n\n\n<figure class=\"wp-block-embed aligncenter is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"[PingCAP Meetup] TiDB Optimizer Inside out\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/arZynB9G9VI?list=PLlGz8dzgfp-6dxSnUpCCqSGT87QApNWHM\" 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><\/p>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:33.33%\"><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"420\" height=\"404\" src=\"https:\/\/www.pingcap.com\/core\/uploads\/2022\/04\/Ed-Picture-1.png\" alt=\"\" class=\"wp-image-6325\" srcset=\"https:\/\/static.pingcap.com\/files\/2022\/04\/Ed-Picture-1.png 420w, https:\/\/static.pingcap.com\/files\/2022\/04\/Ed-Picture-1-300x289.png 300w\" sizes=\"auto, (max-width: 420px) 100vw, 420px\" \/><\/figure>\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:66.66%\">\n<p><strong>Ed Huang<\/strong><\/p>\n\n\n\n<p><strong>Co-founder and CTO, PingCAP<\/strong><\/p>\n\n\n\n<p>Ed Huang is co-founder and CTO of PingCAP, one of the creators of the TiDB distributed database and the TiKV key value store. While he was at Wandou Labs, Ed worked on clustering Redis and created and open-sourced Codis, a proxy based high performance Redis cluster solution. He decided to focus on the next generation database and went on to found PingCAP and create TiDB and TiKV.<\/p>\n<\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:33.33%\"><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"1024\" src=\"https:\/\/www.pingcap.com\/core\/uploads\/2022\/05\/Yu-Dong-Profile-Picture-cropped-1024x1024.png\" alt=\"\" class=\"wp-image-6646\" srcset=\"https:\/\/static.pingcap.com\/files\/2022\/05\/Yu-Dong-Profile-Picture-cropped-1024x1024.png 1024w, https:\/\/static.pingcap.com\/files\/2022\/05\/Yu-Dong-Profile-Picture-cropped-300x300.png 300w, https:\/\/static.pingcap.com\/files\/2022\/05\/Yu-Dong-Profile-Picture-cropped-150x150.png 150w, https:\/\/static.pingcap.com\/files\/2022\/05\/Yu-Dong-Profile-Picture-cropped-768x768.png 768w, https:\/\/static.pingcap.com\/files\/2022\/05\/Yu-Dong-Profile-Picture-cropped.png 1183w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:66.66%\">\n<p><strong>Yu Dong<\/strong><\/p>\n\n\n\n<p><strong>TiDB Cloud Compute team leader<\/strong><\/p>\n\n\n\n<p>Yu Dong is an architect and manager at PingCAP. He leads TiDB Cloud Compute team, which builds the cloud-native, distributed query, and computing capabilities of TiDB Cloud. Before joining PingCAP, Yu worked on query processing and optimization for 15+ years with IBM Db2z, Huawei Gauss MppDB, and Alibaba Cloud ADB. Yu also served on the Governing Board of Presto to help the Presto open source community.<\/p>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Time: May 31, 5:30 PM Pacific Daylight Time. Join us at our Sunnyvale office for dinner and drinks! If you can\u2019t make it in person, then check out our livestream. &nbsp;&nbsp; Sign up today to reserve your seat! Address and links will be emailed to you. The SQL optimizer is one of the most complicated [&hellip;]<\/p>\n","protected":false},"featured_media":6735,"template":"","categories":[18],"tags":[147,149,14,111],"region":[216],"location":[205],"class_list":["post-6684","event","type-event","status-publish","has-post-thumbnail","hentry","category-community","tag-distributed-sql","tag-distributedsql","tag-mysql","tag-tidb","region-north-america","location-hybrid"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Inside Out: TiDB&#039;s SQL Engine | TiDB<\/title>\n<meta name=\"description\" content=\"Join us for a meetup on TiDB&#039;s query optimizer. Learn about its components, challenges, and upcoming features from industry experts.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.pingcap.com\/ko\/event\/inside-out-tidbs-sql-engine\/\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Inside Out: TiDB&#039;s SQL Engine | TiDB\" \/>\n<meta property=\"og:description\" content=\"Join us for a meetup on TiDB&#039;s query optimizer. Learn about its components, challenges, and upcoming features from industry experts.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.pingcap.com\/ko\/event\/inside-out-tidbs-sql-engine\/\" \/>\n<meta property=\"og:site_name\" content=\"TiDB\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/facebook.com\/pingcap2015\" \/>\n<meta property=\"article:modified_time\" content=\"2024-07-16T12:02:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/static.pingcap.com\/files\/2022\/05\/531-cover-page.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1848\" \/>\n\t<meta property=\"og:image:height\" content=\"908\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/static.pingcap.com\/files\/2022\/05\/531-cover-page.png\" \/>\n<meta name=\"twitter:site\" content=\"@PingCAP\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2\ubd84\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.pingcap.com\/event\/inside-out-tidbs-sql-engine\/\",\"url\":\"https:\/\/www.pingcap.com\/event\/inside-out-tidbs-sql-engine\/\",\"name\":\"Inside Out: TiDB's SQL Engine | TiDB\",\"isPartOf\":{\"@id\":\"https:\/\/www.pingcap.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.pingcap.com\/event\/inside-out-tidbs-sql-engine\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.pingcap.com\/event\/inside-out-tidbs-sql-engine\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/static.pingcap.com\/files\/2022\/05\/531-banner.png\",\"datePublished\":\"2022-05-25T01:14:07+00:00\",\"dateModified\":\"2024-07-16T12:02:54+00:00\",\"description\":\"Join us for a meetup on TiDB's query optimizer. Learn about its components, challenges, and upcoming features from industry experts.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.pingcap.com\/event\/inside-out-tidbs-sql-engine\/#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.pingcap.com\/event\/inside-out-tidbs-sql-engine\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.pingcap.com\/event\/inside-out-tidbs-sql-engine\/#primaryimage\",\"url\":\"https:\/\/static.pingcap.com\/files\/2022\/05\/531-banner.png\",\"contentUrl\":\"https:\/\/static.pingcap.com\/files\/2022\/05\/531-banner.png\",\"width\":3125,\"height\":1042},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.pingcap.com\/event\/inside-out-tidbs-sql-engine\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.pingcap.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Events\",\"item\":\"https:\/\/www.pingcap.com\/event\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Inside Out: TiDB&#8217;s SQL Engine\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.pingcap.com\/#website\",\"url\":\"https:\/\/www.pingcap.com\/\",\"name\":\"TiDB\",\"description\":\"TiDB | SQL at Scale\",\"publisher\":{\"@id\":\"https:\/\/www.pingcap.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.pingcap.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ko-KR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.pingcap.com\/#organization\",\"name\":\"PingCAP\",\"url\":\"https:\/\/www.pingcap.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.pingcap.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/static.pingcap.com\/files\/2021\/11\/pingcap-logo.png\",\"contentUrl\":\"https:\/\/static.pingcap.com\/files\/2021\/11\/pingcap-logo.png\",\"width\":811,\"height\":232,\"caption\":\"PingCAP\"},\"image\":{\"@id\":\"https:\/\/www.pingcap.com\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/facebook.com\/pingcap2015\",\"https:\/\/x.com\/PingCAP\",\"https:\/\/linkedin.com\/company\/pingcap\",\"https:\/\/youtube.com\/channel\/UCuq4puT32DzHKT5rU1IZpIA\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Inside Out: TiDB's SQL Engine | TiDB","description":"Join us for a meetup on TiDB's query optimizer. Learn about its components, challenges, and upcoming features from industry experts.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.pingcap.com\/ko\/event\/inside-out-tidbs-sql-engine\/","og_locale":"ko_KR","og_type":"article","og_title":"Inside Out: TiDB's SQL Engine | TiDB","og_description":"Join us for a meetup on TiDB's query optimizer. Learn about its components, challenges, and upcoming features from industry experts.","og_url":"https:\/\/www.pingcap.com\/ko\/event\/inside-out-tidbs-sql-engine\/","og_site_name":"TiDB","article_publisher":"https:\/\/facebook.com\/pingcap2015","article_modified_time":"2024-07-16T12:02:54+00:00","og_image":[{"width":1848,"height":908,"url":"https:\/\/static.pingcap.com\/files\/2022\/05\/531-cover-page.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_image":"https:\/\/static.pingcap.com\/files\/2022\/05\/531-cover-page.png","twitter_site":"@PingCAP","twitter_misc":{"Est. reading time":"2\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.pingcap.com\/event\/inside-out-tidbs-sql-engine\/","url":"https:\/\/www.pingcap.com\/event\/inside-out-tidbs-sql-engine\/","name":"Inside Out: TiDB's SQL Engine | TiDB","isPartOf":{"@id":"https:\/\/www.pingcap.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.pingcap.com\/event\/inside-out-tidbs-sql-engine\/#primaryimage"},"image":{"@id":"https:\/\/www.pingcap.com\/event\/inside-out-tidbs-sql-engine\/#primaryimage"},"thumbnailUrl":"https:\/\/static.pingcap.com\/files\/2022\/05\/531-banner.png","datePublished":"2022-05-25T01:14:07+00:00","dateModified":"2024-07-16T12:02:54+00:00","description":"Join us for a meetup on TiDB's query optimizer. Learn about its components, challenges, and upcoming features from industry experts.","breadcrumb":{"@id":"https:\/\/www.pingcap.com\/event\/inside-out-tidbs-sql-engine\/#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.pingcap.com\/event\/inside-out-tidbs-sql-engine\/"]}]},{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.pingcap.com\/event\/inside-out-tidbs-sql-engine\/#primaryimage","url":"https:\/\/static.pingcap.com\/files\/2022\/05\/531-banner.png","contentUrl":"https:\/\/static.pingcap.com\/files\/2022\/05\/531-banner.png","width":3125,"height":1042},{"@type":"BreadcrumbList","@id":"https:\/\/www.pingcap.com\/event\/inside-out-tidbs-sql-engine\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.pingcap.com\/"},{"@type":"ListItem","position":2,"name":"Events","item":"https:\/\/www.pingcap.com\/event\/"},{"@type":"ListItem","position":3,"name":"Inside Out: TiDB&#8217;s SQL Engine"}]},{"@type":"WebSite","@id":"https:\/\/www.pingcap.com\/#website","url":"https:\/\/www.pingcap.com\/","name":"\ud2f0DB","description":"TiDB | SQL at Scale","publisher":{"@id":"https:\/\/www.pingcap.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.pingcap.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ko-KR"},{"@type":"Organization","@id":"https:\/\/www.pingcap.com\/#organization","name":"PingCAP","url":"https:\/\/www.pingcap.com\/","logo":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.pingcap.com\/#\/schema\/logo\/image\/","url":"https:\/\/static.pingcap.com\/files\/2021\/11\/pingcap-logo.png","contentUrl":"https:\/\/static.pingcap.com\/files\/2021\/11\/pingcap-logo.png","width":811,"height":232,"caption":"PingCAP"},"image":{"@id":"https:\/\/www.pingcap.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/facebook.com\/pingcap2015","https:\/\/x.com\/PingCAP","https:\/\/linkedin.com\/company\/pingcap","https:\/\/youtube.com\/channel\/UCuq4puT32DzHKT5rU1IZpIA"]}]}},"card_markup":"<a class=\"card-resource bg-white\" href=\"https:\/\/www.pingcap.com\/ko\/event\/inside-out-tidbs-sql-engine\/\"><div class=\"card-event__image-container\"><img class=\"card-event__image\" alt=\"5:31 banner\" src=\"https:\/\/static.pingcap.com\/files\/2022\/05\/531-banner.png\" loading=\"lazy\" width=3125 height=1042 \/><\/div><div class=\"card-event__content-container\"><div class=\"card-resource__content-status\"><div class=\"card-resource__status completed\">Completed<\/div><\/div><h5 class=\"card-resource__title\">Inside Out: TiDB&#8217;s SQL Engine<\/h5><p class=\"card-resource__date\"><i class=\"icon-calendar-check\"><\/i>Jan 1 12:00 am - 12:00 am PDT<\/p><p class=\"card-resource__location\"><i class=\"icon-map-pin\"><\/i>Hybrid<\/p><\/div><\/a>","_links":{"self":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/event\/6684","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/event"}],"about":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/types\/event"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/media\/6735"}],"wp:attachment":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/media?parent=6684"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/categories?post=6684"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/tags?post=6684"},{"taxonomy":"region","embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/region?post=6684"},{"taxonomy":"location","embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/location?post=6684"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}