{"id":8008,"date":"2022-08-01T10:57:11","date_gmt":"2022-08-01T17:57:11","guid":{"rendered":"https:\/\/en.pingcap.com\/?post_type=event&#038;p=8008"},"modified":"2024-07-16T04:56:42","modified_gmt":"2024-07-16T11:56:42","slug":"the-design-of-tidbs-columnar-storage-engine-tiflash","status":"publish","type":"event","link":"https:\/\/www.pingcap.com\/ko\/event\/the-design-of-tidbs-columnar-storage-engine-tiflash\/","title":{"rendered":"The Design of TiDB&#8217;s Columnar Storage Engine, TiFlash"},"content":{"rendered":"\n<p><\/p>\n\n\n\n<p><strong>Title: <\/strong>The Design of TiDB&#8217;s Columnar Storage Engine, TiFlash<\/p>\n\n\n\n<p><br><strong>Time: <\/strong>August 11, 6 PM Pacific Daylight Time. Doors will open at 5:30 PM <\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>Introduction: <\/strong><\/p>\n\n\n\n<p>TiDB is an open-source, real-time HTAP database that works great for both transactional and analytical workloads. TiFlash is the analytical extension in the TiDB family that powers TiDB via columnar storage and a massively parallel processing (MPP) query engine. This talk will discuss the design and the ideas behind the columnar storage engine. We will focus on how data is stored on disk in order to combine fast writes with efficient analytics.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>Speaker<\/strong><\/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=\"353\" height=\"353\" src=\"https:\/\/www.pingcap.com\/core\/uploads\/2022\/07\/Wish-Profile-Picture-modified.png\" alt=\"\" class=\"wp-image-8010\" srcset=\"https:\/\/static.pingcap.com\/files\/2022\/07\/Wish-Profile-Picture-modified.png 353w, https:\/\/static.pingcap.com\/files\/2022\/07\/Wish-Profile-Picture-modified-300x300.png 300w, https:\/\/static.pingcap.com\/files\/2022\/07\/Wish-Profile-Picture-modified-150x150.png 150w\" sizes=\"auto, (max-width: 353px) 100vw, 353px\" \/><\/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>Wish Shi<\/strong><\/p>\n\n\n\n<p><strong>Database Engineer, PingCAP<\/strong><\/p>\n\n\n\n<p>Wish joined PingCAP in 2017. He currently focuses on adapting TiFlash to a cloud-native architecture. Wish is an expert in high-performance programming and observability. Before working with TiFlash, he was responsible for optimizing product performance and led the development of the observability features in TiDB.<\/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-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"[PingCAP Meetup] The Design of TiDB&#039;s Columnar Storage Engine, TiFlash\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/KXN6XsQx2b0?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: The Design of TiDB&#8217;s Columnar Storage Engine, TiFlash Time: August 11, 6 PM Pacific Daylight Time. Doors will open at 5:30 PM Introduction: TiDB is an open-source, real-time HTAP database that works great for both transactional and analytical workloads. TiFlash is the analytical extension in the TiDB family that powers TiDB via columnar storage [&hellip;]<\/p>\n","protected":false},"featured_media":10232,"template":"","categories":[18],"tags":[15,10,11,111],"region":[216],"location":[205],"class_list":["post-8008","event","type-event","status-publish","has-post-thumbnail","hentry","category-community","tag-cloud","tag-htap","tag-real-time-analytics","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>The Design of TiDB&#039;s Columnar Storage Engine, TiFlash | TiDB<\/title>\n<meta name=\"description\" content=\"Discover the power of columnar storage engines for fast writes and efficient analytics. Sign up for this insightful talk today!\" \/>\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\/the-design-of-tidbs-columnar-storage-engine-tiflash\/\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The Design of TiDB&#039;s Columnar Storage Engine, TiFlash | TiDB\" \/>\n<meta property=\"og:description\" content=\"Discover the power of columnar storage engines for fast writes and efficient analytics. Sign up for this insightful talk today!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.pingcap.com\/ko\/event\/the-design-of-tidbs-columnar-storage-engine-tiflash\/\" \/>\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-16T11:56:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/static.pingcap.com\/files\/2022\/11\/30070731\/img16.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1800\" \/>\n\t<meta property=\"og:image:height\" content=\"600\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@PingCAP\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1\ubd84\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.pingcap.com\/event\/the-design-of-tidbs-columnar-storage-engine-tiflash\/\",\"url\":\"https:\/\/www.pingcap.com\/event\/the-design-of-tidbs-columnar-storage-engine-tiflash\/\",\"name\":\"The Design of TiDB's Columnar Storage Engine, TiFlash | TiDB\",\"isPartOf\":{\"@id\":\"https:\/\/www.pingcap.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.pingcap.com\/event\/the-design-of-tidbs-columnar-storage-engine-tiflash\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.pingcap.com\/event\/the-design-of-tidbs-columnar-storage-engine-tiflash\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/static.pingcap.com\/files\/2022\/11\/30070731\/img16.jpg\",\"datePublished\":\"2022-08-01T17:57:11+00:00\",\"dateModified\":\"2024-07-16T11:56:42+00:00\",\"description\":\"Discover the power of columnar storage engines for fast writes and efficient analytics. Sign up for this insightful talk today!\",\"breadcrumb\":{\"@id\":\"https:\/\/www.pingcap.com\/event\/the-design-of-tidbs-columnar-storage-engine-tiflash\/#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.pingcap.com\/event\/the-design-of-tidbs-columnar-storage-engine-tiflash\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.pingcap.com\/event\/the-design-of-tidbs-columnar-storage-engine-tiflash\/#primaryimage\",\"url\":\"https:\/\/static.pingcap.com\/files\/2022\/11\/30070731\/img16.jpg\",\"contentUrl\":\"https:\/\/static.pingcap.com\/files\/2022\/11\/30070731\/img16.jpg\",\"width\":1800,\"height\":600},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.pingcap.com\/event\/the-design-of-tidbs-columnar-storage-engine-tiflash\/#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\":\"The Design of TiDB&#8217;s Columnar Storage Engine, TiFlash\"}]},{\"@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":"The Design of TiDB's Columnar Storage Engine, TiFlash | TiDB","description":"Discover the power of columnar storage engines for fast writes and efficient analytics. Sign up for this insightful talk today!","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\/the-design-of-tidbs-columnar-storage-engine-tiflash\/","og_locale":"ko_KR","og_type":"article","og_title":"The Design of TiDB's Columnar Storage Engine, TiFlash | TiDB","og_description":"Discover the power of columnar storage engines for fast writes and efficient analytics. Sign up for this insightful talk today!","og_url":"https:\/\/www.pingcap.com\/ko\/event\/the-design-of-tidbs-columnar-storage-engine-tiflash\/","og_site_name":"TiDB","article_publisher":"https:\/\/facebook.com\/pingcap2015","article_modified_time":"2024-07-16T11:56:42+00:00","og_image":[{"width":1800,"height":600,"url":"https:\/\/static.pingcap.com\/files\/2022\/11\/30070731\/img16.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_site":"@PingCAP","twitter_misc":{"Est. reading time":"1\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.pingcap.com\/event\/the-design-of-tidbs-columnar-storage-engine-tiflash\/","url":"https:\/\/www.pingcap.com\/event\/the-design-of-tidbs-columnar-storage-engine-tiflash\/","name":"The Design of TiDB's Columnar Storage Engine, TiFlash | TiDB","isPartOf":{"@id":"https:\/\/www.pingcap.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.pingcap.com\/event\/the-design-of-tidbs-columnar-storage-engine-tiflash\/#primaryimage"},"image":{"@id":"https:\/\/www.pingcap.com\/event\/the-design-of-tidbs-columnar-storage-engine-tiflash\/#primaryimage"},"thumbnailUrl":"https:\/\/static.pingcap.com\/files\/2022\/11\/30070731\/img16.jpg","datePublished":"2022-08-01T17:57:11+00:00","dateModified":"2024-07-16T11:56:42+00:00","description":"Discover the power of columnar storage engines for fast writes and efficient analytics. Sign up for this insightful talk today!","breadcrumb":{"@id":"https:\/\/www.pingcap.com\/event\/the-design-of-tidbs-columnar-storage-engine-tiflash\/#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.pingcap.com\/event\/the-design-of-tidbs-columnar-storage-engine-tiflash\/"]}]},{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.pingcap.com\/event\/the-design-of-tidbs-columnar-storage-engine-tiflash\/#primaryimage","url":"https:\/\/static.pingcap.com\/files\/2022\/11\/30070731\/img16.jpg","contentUrl":"https:\/\/static.pingcap.com\/files\/2022\/11\/30070731\/img16.jpg","width":1800,"height":600},{"@type":"BreadcrumbList","@id":"https:\/\/www.pingcap.com\/event\/the-design-of-tidbs-columnar-storage-engine-tiflash\/#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":"The Design of TiDB&#8217;s Columnar Storage Engine, TiFlash"}]},{"@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\/the-design-of-tidbs-columnar-storage-engine-tiflash\/\"><div class=\"card-event__image-container\"><img class=\"card-event__image\" alt=\"img16\" src=\"https:\/\/static.pingcap.com\/files\/2022\/11\/30070731\/img16.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\">The Design of TiDB&#8217;s Columnar Storage Engine, TiFlash<\/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\/8008","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\/10232"}],"wp:attachment":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/media?parent=8008"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/categories?post=8008"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/tags?post=8008"},{"taxonomy":"region","embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/region?post=8008"},{"taxonomy":"location","embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/location?post=8008"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}