{"id":9764,"date":"2022-11-06T21:19:31","date_gmt":"2022-11-07T05:19:31","guid":{"rendered":"https:\/\/www.pingcap.com\/?post_type=event&#038;p=9764"},"modified":"2023-08-08T20:46:49","modified_gmt":"2023-08-09T03:46:49","slug":"inside-out-tidbs-table-partition-and-data-definition-language-ddl","status":"publish","type":"event","link":"https:\/\/www.pingcap.com\/ko\/event\/inside-out-tidbs-table-partition-and-data-definition-language-ddl\/","title":{"rendered":"Inside Out: TiDB&#8217;s Table Partition and Data Definition Language (DDL)"},"content":{"rendered":"\n<p><strong>Title: <\/strong>Inside Out: TiDB&#8217;s Table Partition and Data Definition Language (DDL)<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>Time: <\/strong>November 7th, 6 PM Pacific Daylight Time. Doors will open at 5:30 PM.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>Introduction: <\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>In this talk, we will discuss two important aspects of TiDB: Table Partition and Data Definition Language (DDL).<\/p>\n\n\n\n<p>Mattias will first talk about Table Partitioning in TiDB. He will introduce table partitioning in TiDB and MySQL compatibility. He will also go through the most common use cases, the specifics of TiDB and how the distributed SQL system and HTAP affects the use cases for table partitioning.&nbsp;<\/p>\n\n\n\n<p>You can also discuss with Mattias about planned features and user requests.<\/p>\n\n\n\n<p>Cong will then give a talk about the overview of Data Definition Language (DDL)&nbsp;execution of TiDB, including how the online schema change works in a HTAP distributed system: the challenging parts and the solutions to archive them. Cong will also discuss the compatibility of TiDB with MySQL in DDL: the features that have been supported, not supported and extended. Also, he will give a brief introduction to the roadmap of DDL in TiDB. <\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>Speakers<\/strong><\/p>\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=\"311\" height=\"311\" src=\"https:\/\/static.pingcap.com\/files\/2022\/10\/27210501\/Cong-Wang-Profile-Picture-modified.png\" alt=\"\" class=\"wp-image-9766\" srcset=\"https:\/\/static.pingcap.com\/files\/2022\/10\/27210501\/Cong-Wang-Profile-Picture-modified.png 311w, https:\/\/static.pingcap.com\/files\/2022\/10\/27210501\/Cong-Wang-Profile-Picture-modified-300x300.png 300w, https:\/\/static.pingcap.com\/files\/2022\/10\/27210501\/Cong-Wang-Profile-Picture-modified-150x150.png 150w\" sizes=\"auto, (max-width: 311px) 100vw, 311px\" \/><\/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>Cong Wang,<\/strong><\/p>\n\n\n\n<p><strong>Senior Database Engineer, PingCAP<\/strong><\/p>\n\n\n\n<p>Cong has worked on distributed systems for more than 10 years and contributed to the TiDB project for more than 4 years. As a maintainer of TiDB, he mainly focuses on the computation layer (the &#8216;TiDB Server&#8217;) of the cluster, which includes the authentications, security-related features, metadata management and character sets.<\/p>\n<\/div>\n<\/div>\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=\"455\" height=\"455\" src=\"https:\/\/static.pingcap.com\/files\/2022\/10\/27210631\/Mattias-Profile-picture-modified.png\" alt=\"\" class=\"wp-image-9767\" srcset=\"https:\/\/static.pingcap.com\/files\/2022\/10\/27210631\/Mattias-Profile-picture-modified.png 455w, https:\/\/static.pingcap.com\/files\/2022\/10\/27210631\/Mattias-Profile-picture-modified-300x300.png 300w, https:\/\/static.pingcap.com\/files\/2022\/10\/27210631\/Mattias-Profile-picture-modified-150x150.png 150w\" sizes=\"auto, (max-width: 455px) 100vw, 455px\" \/><\/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>Mattias Jonsson,<\/strong><\/p>\n\n\n\n<p><strong>Senior Database Engineer, PingCAP<\/strong><\/p>\n\n\n\n<p>Mattias is currently a senior database engineer at PingCAP. Prior to joining PingCAP, Mattias worked for Booking.com, where he spent a significant amount of time on MySQL. Mattias has also worked as a developer in the MySQL server team before joining Bookings.com, where he focused on the partitioning storage engine. He has worked with MySQL for more than 15 years.<\/p>\n<\/div>\n<\/div>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-4-3 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"[PingCAP Meetup] Inside Out: TiDB&#039;s Table Partition and Data Definition Language (DDL)\" width=\"500\" height=\"375\" src=\"https:\/\/www.youtube.com\/embed\/IiiFVr6UEIc?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","protected":false},"excerpt":{"rendered":"<p>Title: Inside Out: TiDB&#8217;s Table Partition and Data Definition Language (DDL) Time: November 7th, 6 PM Pacific Daylight Time. Doors will open at 5:30 PM. Introduction: In this talk, we will discuss two important aspects of TiDB: Table Partition and Data Definition Language (DDL). Mattias will first talk about Table Partitioning in TiDB. He will [&hellip;]<\/p>\n","protected":false},"featured_media":10219,"template":"","categories":[18],"tags":[16,10,11,9,111],"region":[216],"location":[205],"class_list":["post-9764","event","type-event","status-publish","has-post-thumbnail","hentry","category-community","tag-distributed-system","tag-htap","tag-real-time-analytics","tag-scalability","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 Table Partition and Data Definition Language (DDL)<\/title>\n<meta name=\"description\" content=\"Discover TiDB&#039;s Table Partition and DDL features, including use cases, MySQL compatibility, and roadmap, in this engaging talk.\" \/>\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-table-partition-and-data-definition-language-ddl\/\" \/>\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 Table Partition and Data Definition Language (DDL)\" \/>\n<meta property=\"og:description\" content=\"Discover TiDB&#039;s Table Partition and DDL features, including use cases, MySQL compatibility, and roadmap, in this engaging talk.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.pingcap.com\/ko\/event\/inside-out-tidbs-table-partition-and-data-definition-language-ddl\/\" \/>\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=\"2023-08-09T03:46:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/static.pingcap.com\/files\/2022\/10\/27210918\/117-cover-page-1.jpeg\" \/>\n\t<meta property=\"og:image:width\" content=\"2388\" \/>\n\t<meta property=\"og:image:height\" content=\"1343\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/static.pingcap.com\/files\/2022\/10\/27210918\/117-cover-page-1.jpeg\" \/>\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-table-partition-and-data-definition-language-ddl\/\",\"url\":\"https:\/\/www.pingcap.com\/event\/inside-out-tidbs-table-partition-and-data-definition-language-ddl\/\",\"name\":\"Inside Out: TiDB's Table Partition and Data Definition Language (DDL)\",\"isPartOf\":{\"@id\":\"https:\/\/www.pingcap.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.pingcap.com\/event\/inside-out-tidbs-table-partition-and-data-definition-language-ddl\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.pingcap.com\/event\/inside-out-tidbs-table-partition-and-data-definition-language-ddl\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/static.pingcap.com\/files\/2022\/11\/30070610\/img3.jpg\",\"datePublished\":\"2022-11-07T05:19:31+00:00\",\"dateModified\":\"2023-08-09T03:46:49+00:00\",\"description\":\"Discover TiDB's Table Partition and DDL features, including use cases, MySQL compatibility, and roadmap, in this engaging talk.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.pingcap.com\/event\/inside-out-tidbs-table-partition-and-data-definition-language-ddl\/#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.pingcap.com\/event\/inside-out-tidbs-table-partition-and-data-definition-language-ddl\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.pingcap.com\/event\/inside-out-tidbs-table-partition-and-data-definition-language-ddl\/#primaryimage\",\"url\":\"https:\/\/static.pingcap.com\/files\/2022\/11\/30070610\/img3.jpg\",\"contentUrl\":\"https:\/\/static.pingcap.com\/files\/2022\/11\/30070610\/img3.jpg\",\"width\":1800,\"height\":600},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.pingcap.com\/event\/inside-out-tidbs-table-partition-and-data-definition-language-ddl\/#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 Table Partition and Data Definition Language (DDL)\"}]},{\"@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 Table Partition and Data Definition Language (DDL)","description":"Discover TiDB's Table Partition and DDL features, including use cases, MySQL compatibility, and roadmap, in this engaging talk.","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-table-partition-and-data-definition-language-ddl\/","og_locale":"ko_KR","og_type":"article","og_title":"Inside Out: TiDB's Table Partition and Data Definition Language (DDL)","og_description":"Discover TiDB's Table Partition and DDL features, including use cases, MySQL compatibility, and roadmap, in this engaging talk.","og_url":"https:\/\/www.pingcap.com\/ko\/event\/inside-out-tidbs-table-partition-and-data-definition-language-ddl\/","og_site_name":"TiDB","article_publisher":"https:\/\/facebook.com\/pingcap2015","article_modified_time":"2023-08-09T03:46:49+00:00","og_image":[{"width":2388,"height":1343,"url":"https:\/\/static.pingcap.com\/files\/2022\/10\/27210918\/117-cover-page-1.jpeg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_image":"https:\/\/static.pingcap.com\/files\/2022\/10\/27210918\/117-cover-page-1.jpeg","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-table-partition-and-data-definition-language-ddl\/","url":"https:\/\/www.pingcap.com\/event\/inside-out-tidbs-table-partition-and-data-definition-language-ddl\/","name":"Inside Out: TiDB's Table Partition and Data Definition Language (DDL)","isPartOf":{"@id":"https:\/\/www.pingcap.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.pingcap.com\/event\/inside-out-tidbs-table-partition-and-data-definition-language-ddl\/#primaryimage"},"image":{"@id":"https:\/\/www.pingcap.com\/event\/inside-out-tidbs-table-partition-and-data-definition-language-ddl\/#primaryimage"},"thumbnailUrl":"https:\/\/static.pingcap.com\/files\/2022\/11\/30070610\/img3.jpg","datePublished":"2022-11-07T05:19:31+00:00","dateModified":"2023-08-09T03:46:49+00:00","description":"Discover TiDB's Table Partition and DDL features, including use cases, MySQL compatibility, and roadmap, in this engaging talk.","breadcrumb":{"@id":"https:\/\/www.pingcap.com\/event\/inside-out-tidbs-table-partition-and-data-definition-language-ddl\/#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.pingcap.com\/event\/inside-out-tidbs-table-partition-and-data-definition-language-ddl\/"]}]},{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.pingcap.com\/event\/inside-out-tidbs-table-partition-and-data-definition-language-ddl\/#primaryimage","url":"https:\/\/static.pingcap.com\/files\/2022\/11\/30070610\/img3.jpg","contentUrl":"https:\/\/static.pingcap.com\/files\/2022\/11\/30070610\/img3.jpg","width":1800,"height":600},{"@type":"BreadcrumbList","@id":"https:\/\/www.pingcap.com\/event\/inside-out-tidbs-table-partition-and-data-definition-language-ddl\/#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 Table Partition and Data Definition Language (DDL)"}]},{"@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-table-partition-and-data-definition-language-ddl\/\"><div class=\"card-event__image-container\"><img class=\"card-event__image\" alt=\"img3\" src=\"https:\/\/static.pingcap.com\/files\/2022\/11\/30070610\/img3.jpg\" loading=\"lazy\" width=1800 height=600 \/><\/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 Table Partition and Data Definition Language (DDL)<\/h5><p class=\"card-resource__date\"><i class=\"icon-calendar-check\"><\/i>Jan 1 12:00 am - 12:00 am PST<\/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\/9764","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\/10219"}],"wp:attachment":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/media?parent=9764"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/categories?post=9764"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/tags?post=9764"},{"taxonomy":"region","embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/region?post=9764"},{"taxonomy":"location","embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/location?post=9764"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}