Accelerating Query Performance: The Benefits of TiDB’s In-Memory Engine (IME)
If you’ve ever struggled with slow queries or high resource consumption in your database, you’re not alone. Many databases, including those built on Multi-Version Concurrency Control (MVCC), face query performance degradation over time. While MVCC is essential for managing concurrent access, excessive historical data scanning can slow down queries and overload system resources — a […]
Comparing Vitess and TiDB: Cross-Shard Queries, Consistency, and AZ Outages
TiDB focuses on simplicity, transparency, and high availability, providing a robust foundation for distributed SQL workloads. While concerns about cross-shard queries and availability zone (AZ) outages are valid, TiDB’s architecture minimizes these risks, ensuring reliable and efficient application performance. However, when comparing TiDB and Vitess — an orchestrator for sharded MySQL instances — the architectural differences […]
Node Groups in TiDB Cloud: The Key to Scaling Workloads with Predictable Performance and Control
As modern applications scale, ensuring consistent, predictable performance across different workloads becomes increasingly challenging. Transactional queries, real-time analytics, and batch jobs often compete for resources, leading to slowdowns, inefficient resource allocation, and unpredictable database behavior. With Node Groups in TiDB Cloud, organizations can assign dedicated TiDB node compute resources to specific workloads within a single […]
Why Pinterest Modernized Its Graph Service with Distributed SQL
Pinterest, one of the world’s leading visual search and discovery platforms, recently undertook a significant overhaul of its graph storage service. At the HTAP Summit 2024, Pinterest Senior Software Engineer Ke Chen discussed the company’s transition from its legacy Zen system to a new architecture built on top of TiDB, an advanced distributed SQL database. […]
Unleashing Query Power: Advanced Multi-Column Index Optimization in TiDB
In today’s data-driven world, efficiently handling complex queries on large datasets is critical to keeping applications responsive and performant. For TiDB, a distributed SQL database designed to manage high-scale, high-demand environments, optimizing data access paths is essential to delivering smooth, efficient queries. This post dives into TiDB’s advanced approach to optimizing multi-column indexes. This is […]
Enhancing Database Stability in TiDB with Runaway Query Management
Maintaining database stability is paramount for any business, as unexpected dips in performance for critical systems can cause substantial losses. By streamlining change testing processes or employing new technologies, you can limit unforeseen incidents within a certain range. However, sudden SQL performance issues, such as drastic data volume changes, increasingly complicated queries, and partially validated […]