{"id":21213,"date":"2024-09-30T14:04:57","date_gmt":"2024-09-30T21:04:57","guid":{"rendered":"https:\/\/www.pingcap.com\/article\/optimizing-tidb-performance-for-large-scale-enterprises\/"},"modified":"2024-12-11T20:07:00","modified_gmt":"2024-12-12T04:07:00","slug":"optimizing-tidb-performance-for-large-scale-enterprises","status":"publish","type":"article","link":"https:\/\/www.pingcap.com\/ko\/article\/optimizing-tidb-performance-for-large-scale-enterprises\/","title":{"rendered":"Optimizing TiDB Performance for Large-Scale Enterprises"},"content":{"rendered":"<h2><span class=\"ez-toc-section\" id=\"Introduction_to_TiDB_Performance_Optimization\"><\/span>Introduction to TiDB Performance Optimization<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3>Importance of Performance Optimization in Large-Scale Enterprises<\/h3>\n<p>In today&#8217;s data-driven environment, enterprises face the daunting challenge of managing and optimizing vast amounts of data efficiently. This challenge is compounded by the need for real-time analytics, rapid transactions, and high availability. Performance optimization is no longer a luxury\u2014it&#8217;s a necessity. Effective optimization can lead to faster query responses, improved user experiences, and significant cost savings by maximizing existing resources. For large-scale enterprises, where data volume and complexity are continually increasing, optimizing database performance ensures business continuity, scalability, and competitive advantage.<\/p>\n<h3>Overview of TiDB Architecture<\/h3>\n<p><a href=\"https:\/\/tidb.io\/\">TiDB<\/a>, an open-source NewSQL database, seamlessly blends the benefits of traditional relational databases and NoSQL. <a href=\"https:\/\/docs.pingcap.com\/tidb\/stable\/tidb-architecture\">TiDB&#8217;s architecture<\/a> is designed to handle both Online Transactional Processing (OLTP) and Online Analytical Processing (OLAP) workloads. At its core, TiDB comprises three main components:<\/p>\n<ol>\n<li><strong>TiDB Server<\/strong>: This stateless SQL layer operations node functions as an entry point for SQL queries, handling them through the MySQL protocol.<\/li>\n<li><strong><a href=\"https:\/\/docs.pingcap.com\/tidb\/stable\/tikv-overview\">TiKV<\/a><\/strong>: The distributed, row-based transactional storage engine ensures low-latency data reads and writes.<\/li>\n<li><strong>Placement Driver (PD)<\/strong>: This cluster manager component handles metadata storage, scheduling, and load balancing.<\/li>\n<\/ol>\n<p>Understanding this architecture is essential for performance optimization, as it offers multiple entry points for tuning and configuration to meet specific workload demands.<\/p>\n<h3>Performance Metrics and Measurement Tools for TiDB<\/h3>\n<p>Effective performance optimization begins with accurate measurement. TiDB provides a suite of tools for performance diagnostics and monitoring, ensuring comprehensive insights into the system&#8217;s behavior:<\/p>\n<ul>\n<li><strong>TiDB Dashboard<\/strong>: A graphical interface offering a range of diagnostic tools, including Top SQL and Continuous Profiling, which provide insights into SQL execution and resource consumption.<\/li>\n<li><strong>Prometheus and Grafana<\/strong>: Integrated for real-time monitoring, these tools collect and visualize important performance metrics, helping administrators identify patterns and anomalies.<\/li>\n<li><strong>Log Analysis<\/strong>: TiDB&#8217;s logging system captures detailed information about database operations, crucial for diagnosing slow queries and understanding transaction behavior.<\/li>\n<\/ul>\n<p>For a deeper dive into performance tuning at a granular level, refer to the <a href=\"https:\/\/docs.pingcap.com\/tidb\/v6.1\/continuous-profiling\">Continuous Profiling guide<\/a> which offers a comprehensive overview of TiDB instance profiling.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Key_Performance_Optimization_Strategies\"><\/span>Key Performance Optimization Strategies<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3>Schema Design and Query Optimization<\/h3>\n<h4>Index Optimization<\/h4>\n<p>Effective indexing is foundational to performance optimization. Proper index utilization can drastically reduce the amount of data scanned during a query. TiDB supports various index types, including primary, secondary, and composite indexes. For columns frequently involved in search conditions or join operations, creating indexes is crucial. However, each additional index can slow down write operations as it requires maintaining multiple data structures.<\/p>\n<div class=\"codehilite\">\n<pre><code><span class=\"c1\">-- Example: Creating a composite index<\/span>\n<span class=\"k\">CREATE<\/span> <span class=\"k\">INDEX<\/span> <span class=\"n\">idx_user_age<\/span> <span class=\"k\">ON<\/span> <span class=\"n\">users<\/span> <span class=\"p\">(<\/span><span class=\"n\">last_name<\/span><span class=\"p\">,<\/span> <span class=\"n\">first_name<\/span><span class=\"p\">,<\/span> <span class=\"n\">age<\/span><span class=\"p\">);<\/span>\n<\/code><\/pre>\n<\/div>\n<p>To ensure indexes are used efficiently, the <a href=\"https:\/\/docs.pingcap.com\/tidb\/v6.5\/dev-guide-index-best-practice\">Index Best Practices<\/a> document provides detailed guidelines and examples.<\/p>\n<h4>Handling Large Tables and Partitions<\/h4>\n<p>Large tables can become a bottleneck. Partitioning tables can help by dividing a large table into smaller, more manageable pieces. TiDB supports various partitioning methods, making it easier to maintain and query large datasets efficiently.<\/p>\n<div class=\"codehilite\">\n<pre><code><span class=\"c1\">-- Example: Range partitioning based on the year<\/span>\n<span class=\"k\">CREATE<\/span> <span class=\"k\">TABLE<\/span> <span class=\"n\">orders<\/span> <span class=\"p\">(<\/span>\n    <span class=\"n\">order_id<\/span> <span class=\"nb\">INT<\/span><span class=\"p\">,<\/span>\n    <span class=\"n\">order_date<\/span> <span class=\"nb\">DATE<\/span><span class=\"p\">,<\/span>\n    <span class=\"p\">...<\/span>\n<span class=\"p\">)<\/span>\n<span class=\"n\">PARTITION<\/span> <span class=\"k\">BY<\/span> <span class=\"n\">RANGE<\/span> <span class=\"p\">(<\/span><span class=\"k\">YEAR<\/span><span class=\"p\">(<\/span><span class=\"n\">order_date<\/span><span class=\"p\">))<\/span> <span class=\"p\">(<\/span>\n    <span class=\"n\">PARTITION<\/span> <span class=\"n\">p2021<\/span> <span class=\"k\">VALUES<\/span> <span class=\"k\">LESS<\/span> <span class=\"k\">THAN<\/span> <span class=\"p\">(<\/span><span class=\"mi\">2022<\/span><span class=\"p\">),<\/span>\n    <span class=\"n\">PARTITION<\/span> <span class=\"n\">p2022<\/span> <span class=\"k\">VALUES<\/span> <span class=\"k\">LESS<\/span> <span class=\"k\">THAN<\/span> <span class=\"p\">(<\/span><span class=\"mi\">2023<\/span><span class=\"p\">)<\/span>\n<span class=\"p\">);<\/span>\n<\/code><\/pre>\n<\/div>\n<p>Proper partitioning helps in parallel processing and minimizes the amount of data scanned.<\/p>\n<h4>Query Execution Plans<\/h4>\n<p>Understanding and optimizing query execution plans can lead to significant performance gains. TiDB&#8217;s optimizer chooses the most efficient execution path. However, in certain cases, manual intervention might be needed to guide the optimizer. Tools like <code>EXPLAIN<\/code> can help visualize and understand these plans.<\/p>\n<div class=\"codehilite\">\n<pre><code><span class=\"c1\">-- Example: Using EXPLAIN to understand a query execution plan<\/span>\n<span class=\"k\">EXPLAIN<\/span> <span class=\"k\">SELECT<\/span> <span class=\"o\">*<\/span> <span class=\"k\">FROM<\/span> <span class=\"n\">users<\/span> <span class=\"k\">WHERE<\/span> <span class=\"n\">last_name<\/span> <span class=\"o\">=<\/span> <span class=\"s1\">'Doe'<\/span><span class=\"p\">;<\/span>\n<\/code><\/pre>\n<\/div>\n<p>Refer to the <a href=\"https:\/\/docs.pingcap.com\/tidb\/stable\/dev-guide-hybrid-oltp-and-olap-queries\">HTAP Query Documentation<\/a> for detailed insights on query plan optimization.<\/p>\n<h3>Configuration and Tuning<\/h3>\n<h4>TiDB and TiKV Configuration Parameters<\/h4>\n<p>Optimal configuration of TiDB and TiKV parameters can drastically enhance performance. Parameters such as <code>tidb_max_tnxn_size<\/code> and <code>tikv_gc_life_time<\/code> can be adjusted based on workload requirements. Adjusting these settings ensures that system resources are utilized effectively without overloading any single component.<\/p>\n<div class=\"codehilite\">\n<pre><code><span class=\"c1\">-- Example: Adjusting garbage collection life time<\/span>\n<span class=\"k\">SET<\/span> <span class=\"k\">GLOBAL<\/span> <span class=\"n\">tikv_gc_life_time<\/span><span class=\"o\">=<\/span><span class=\"s1\">'10m'<\/span><span class=\"p\">;<\/span>\n<\/code><\/pre>\n<\/div>\n<h4>Adjusting Garbage Collection Settings<\/h4>\n<p>Garbage collection (GC) is critical in a distributed database for reclaiming space from deleted data. Incorrect GC settings can lead to long query times and increased latency. Tailoring GC settings based on the dataset size and transaction workload helps in maintaining optimal performance.<\/p>\n<p>For more on this, refer to the detailed <a href=\"https:\/\/docs.pingcap.com\/tidb\/stable\/dev-guide-optimize-sql-overview\">Garbage Collection documentation<\/a>.<\/p>\n<h4>Memory and Cache Management<\/h4>\n<p>Memory management is vital for performance. Ensuring that memory is adequately allocated to TiDB and TiKV processes minimizes disk I\/O, leading to faster query responses. Parameters like <code>tidb_mem_quota_query<\/code> and <code>tikv_block_cache_size<\/code> play a significant role in managing memory utilization.<\/p>\n<div class=\"codehilite\">\n<pre><code><span class=\"c1\">-- Example: Setting memory quota for a query<\/span>\n<span class=\"k\">SET<\/span> <span class=\"k\">GLOBAL<\/span> <span class=\"n\">tidb_mem_quota_query<\/span><span class=\"o\">=<\/span><span class=\"mi\">1073741824<\/span><span class=\"p\">;<\/span>\n<\/code><\/pre>\n<\/div>\n<h3>Scaling and Load Balancing<\/h3>\n<h4>Horizontal vs Vertical Scaling<\/h4>\n<p>TiDB supports both horizontal and vertical scaling. Horizontal scaling involves adding more nodes to the cluster, distributing the load, and providing fault tolerance. Vertical scaling, on the other hand, focuses on enhancing the resources on existing nodes.<\/p>\n<ul>\n<li><strong>Horizontal Scaling<\/strong>: Ideal for read-heavy workloads where adding more TiDB servers helps balance the query load.<\/li>\n<li><strong>Vertical Scaling<\/strong>: Best for improving individual node performance by enhancing CPU, memory, or storage capabilities.<\/li>\n<\/ul>\n<h4>Effective Use of Load Balancers<\/h4>\n<p>Load balancers play a crucial role in distributing the workload evenly across multiple TiDB instances. Tools like HAProxy and F5 can be used to manage and route traffic dynamically, ensuring high availability and optimal resource use.<\/p>\n<h4>Dynamic Resource Allocation<\/h4>\n<p>Dynamic resource allocation enables the system to adjust resources based on current demand. This flexibility is vital in maintaining performance during peak loads and ensuring efficient resource utilization during low demand periods.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Advanced_Techniques\"><\/span>Advanced Techniques<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3>Performance Profiling and Troubleshooting<\/h3>\n<h4>Using TiDB&#8217;s Built-in Tools<\/h4>\n<p>TiDB comes with a suite of built-in tools that facilitate performance profiling and troubleshooting. Tools like Top SQL and Continuous Profiling provide real-time and historical insights into database performance, helping administrators pinpoint and resolve issues efficiently.<\/p>\n<div class=\"codehilite\">\n<pre><code>![<span class=\"nt\">TiDB Dashboard<\/span>](<span class=\"na\">https:\/\/docs.pingcap.com\/tidb\/v6.1\/media\/dashboard\/dashboard-conprof-history.png<\/span>)\n<\/code><\/pre>\n<\/div>\n<p>For a detailed guide on using these tools, check the <a href=\"https:\/\/docs.pingcap.com\/tidb\/v6.1\/continuous-profiling\">Continuous Profiling documentation<\/a>.<\/p>\n<h4>Integrating Third-Party Monitoring Solutions<\/h4>\n<p>While TiDB\u2019s internal tools provide comprehensive insights, integrating third-party solutions like Prometheus, Grafana, and ELK Stack can offer enhanced monitoring capabilities. These integrations help in collecting, visualizing, and analyzing performance metrics more effectively.<\/p>\n<div class=\"codehilite\">\n<pre><code>![<span class=\"nt\">Grafana Dashboard<\/span>](<span class=\"na\">https:\/\/docs.pingcap.com\/tidb\/v7.1\/media\/grafana-performance-overview-dashboard.png<\/span>)\n<\/code><\/pre>\n<\/div>\n<h4>Identifying and Resolving Bottlenecks<\/h4>\n<p>Identifying bottlenecks involves monitoring various performance metrics and logs. Root cause analysis tools and techniques help in understanding the source of performance degradation and implementing effective solutions. Techniques such as query optimization, index refinement, and resource re-allocation can be employed based on the identified issues.<\/p>\n<h3>Case Studies and Real-World Examples<\/h3>\n<h4>Success Stories from Large-Scale Enterprises<\/h4>\n<p>Many large-scale enterprises have leveraged TiDB to overcome their data management challenges. These success stories provide valuable insights into real-world applications and the tangible benefits of performance optimization.<\/p>\n<p>For instance, a major e-commerce platform improved its transaction processing speed by 40% by optimizing its TiDB cluster configuration and implementing partitioning strategies. Another financial institution achieved a 50% reduction in query latency by utilizing TiDB&#8217;s execution plan caching and tuning memory settings.<\/p>\n<h4>Lessons Learned and Best Practices<\/h4>\n<p>From these real-world implementations, several best practices can be distilled:<\/p>\n<ul>\n<li><strong>Regular Performance Audits<\/strong>: Periodic reviews of performance metrics help in preemptively identifying potential issues.<\/li>\n<li><strong>Tailored Configuration<\/strong>: Customizing configuration settings based on specific workload characteristics leads to more efficient resource utilization.<\/li>\n<li><strong>Continuous Learning and Adaptation<\/strong>: Staying updated with the latest features and improvements in TiDB ensures that the system remains optimized as new versions are released.<\/li>\n<\/ul>\n<h4>Benchmarking Reports and Data Analysis<\/h4>\n<p>Benchmarking different configurations and optimization strategies provides quantitative data on performance improvements. TiDB\u2019s built-in tools, combined with third-party benchmarking suites, facilitate detailed analysis and comparison.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Conclusion\"><\/span>Conclusion<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Performance optimization in TiDB involves a multifaceted approach encompassing schema design, configuration tuning, scaling strategies, and continuous monitoring. By understanding and implementing these optimization techniques, enterprises can significantly enhance their database performance, ensuring scalability, reliability, and cost-efficiency. Whether leveraging TiDB&#8217;s built-in tools or integrating third-party solutions, the ultimate goal remains the same: to maintain peak performance in an ever-evolving data landscape. By staying proactive and adaptive, organizations can harness the full potential of TiDB, transforming their data management challenges into strategic advantages.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Learn how to optimize TiDB for real-time analytics, rapid transactions, and high availability with expert tips and case studies.<\/p>","protected":false},"author":8,"featured_media":0,"template":"","class_list":["post-21213","article","type-article","status-publish","hentry"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Optimizing TiDB Performance for Large-Scale Enterprises | TiDB<\/title>\n<meta name=\"description\" content=\"Learn how to optimize TiDB for real-time analytics, rapid transactions, and high availability with expert tips and case studies.\" \/>\n<meta name=\"robots\" content=\"noindex, follow\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Optimizing TiDB Performance for Large-Scale Enterprises | TiDB\" \/>\n<meta property=\"og:description\" content=\"Learn how to optimize TiDB for real-time analytics, rapid transactions, and high availability with expert tips and case studies.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.pingcap.com\/ko\/article\/optimizing-tidb-performance-for-large-scale-enterprises\/\" \/>\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-12-12T04:07:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/static.pingcap.com\/files\/2024\/09\/11005522\/Homepage-Ad.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1440\" \/>\n\t<meta property=\"og:image:height\" content=\"714\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\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=\"7\ubd84\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.pingcap.com\/article\/optimizing-tidb-performance-for-large-scale-enterprises\/\",\"url\":\"https:\/\/www.pingcap.com\/article\/optimizing-tidb-performance-for-large-scale-enterprises\/\",\"name\":\"Optimizing TiDB Performance for Large-Scale Enterprises | TiDB\",\"isPartOf\":{\"@id\":\"https:\/\/www.pingcap.com\/#website\"},\"datePublished\":\"2024-09-30T21:04:57+00:00\",\"dateModified\":\"2024-12-12T04:07:00+00:00\",\"description\":\"Learn how to optimize TiDB for real-time analytics, rapid transactions, and high availability with expert tips and case studies.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.pingcap.com\/article\/optimizing-tidb-performance-for-large-scale-enterprises\/#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.pingcap.com\/article\/optimizing-tidb-performance-for-large-scale-enterprises\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.pingcap.com\/article\/optimizing-tidb-performance-for-large-scale-enterprises\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.pingcap.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Articles\",\"item\":\"https:\/\/www.pingcap.com\/article\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Optimizing TiDB Performance for Large-Scale Enterprises\"}]},{\"@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":"Optimizing TiDB Performance for Large-Scale Enterprises | TiDB","description":"Learn how to optimize TiDB for real-time analytics, rapid transactions, and high availability with expert tips and case studies.","robots":{"index":"noindex","follow":"follow"},"og_locale":"ko_KR","og_type":"article","og_title":"Optimizing TiDB Performance for Large-Scale Enterprises | TiDB","og_description":"Learn how to optimize TiDB for real-time analytics, rapid transactions, and high availability with expert tips and case studies.","og_url":"https:\/\/www.pingcap.com\/ko\/article\/optimizing-tidb-performance-for-large-scale-enterprises\/","og_site_name":"TiDB","article_publisher":"https:\/\/facebook.com\/pingcap2015","article_modified_time":"2024-12-12T04:07:00+00:00","og_image":[{"width":1440,"height":714,"url":"https:\/\/static.pingcap.com\/files\/2024\/09\/11005522\/Homepage-Ad.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_site":"@PingCAP","twitter_misc":{"Est. reading time":"7\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.pingcap.com\/article\/optimizing-tidb-performance-for-large-scale-enterprises\/","url":"https:\/\/www.pingcap.com\/article\/optimizing-tidb-performance-for-large-scale-enterprises\/","name":"Optimizing TiDB Performance for Large-Scale Enterprises | TiDB","isPartOf":{"@id":"https:\/\/www.pingcap.com\/#website"},"datePublished":"2024-09-30T21:04:57+00:00","dateModified":"2024-12-12T04:07:00+00:00","description":"Learn how to optimize TiDB for real-time analytics, rapid transactions, and high availability with expert tips and case studies.","breadcrumb":{"@id":"https:\/\/www.pingcap.com\/article\/optimizing-tidb-performance-for-large-scale-enterprises\/#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.pingcap.com\/article\/optimizing-tidb-performance-for-large-scale-enterprises\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.pingcap.com\/article\/optimizing-tidb-performance-for-large-scale-enterprises\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.pingcap.com\/"},{"@type":"ListItem","position":2,"name":"Articles","item":"https:\/\/www.pingcap.com\/article\/"},{"@type":"ListItem","position":3,"name":"Optimizing TiDB Performance for Large-Scale Enterprises"}]},{"@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-article\" href=\"https:\/\/www.pingcap.com\/ko\/article\/optimizing-tidb-performance-for-large-scale-enterprises\/\">            <h3>Optimizing TiDB Performance for Large-Scale Enterprises<\/h3>            <p>Learn how to optimize TiDB for real-time analytics, rapid transactions, and high availability with expert tips and case studies.<\/p>        <\/a>","_links":{"self":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/article\/21213","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/article"}],"about":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/types\/article"}],"author":[{"embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/users\/8"}],"wp:attachment":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/media?parent=21213"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}