Tencent's Database R&D team supports internal services such as WeChat Pay, WeChat Red Packets, Tencent Advertising, and Tencent Music, and provides external support on Tencent Cloud for TencentDB products like CynosDB, CDB, and TDSQL. This public account aims to promote and share professional database knowledge, growing together with database enthusiasts.
The article explains how CDB introduced an InnoDB index physical space usage statistic to help users decide when to run OPTIMIZE TABLE, describes the background of page fragmentation, compares incremental and full‑scan methods, and details a sequential I/O optimization that dramatically reduces measurement time.
This document explains the differences between OLTP and OLAP workloads, introduces the CSTORE columnar storage engine architecture, its core technologies, performance advantages, typical use cases, benchmark results, and future development plans for MySQL 8.0.
This article details a comprehensive investigation of MySQL out‑of‑memory (OOM) alerts on a Tencent Cloud CDB instance during a high‑traffic marketing event, covering background, observed symptoms, step‑by‑step debugging, analysis of server and engine memory usage, relevant MySQL bugs, fetch_cache behavior, and the final configuration recommendations to prevent OOM.
This article explains the TPC‑C benchmark, covering its purpose, data model, database schema, the five transaction types, and a detailed step‑by‑step walkthrough of the New‑Order operation with accompanying SQL illustrations, while also summarizing workload characteristics and providing reference links.
This article introduces the TPC-C benchmark, its origin within the Transaction Processing Performance Council, the evolution from early standards like Debit Credit and TP1 to TPC-A, the structure of the TPC-C model with its nine tables and operations, and the subsequent development of newer standards such as TPC-E.
This report details the background, testing methodology, encountered issues, optimization steps, migration process, and final performance outcomes of moving Weimeng's MySQL databases to Tencent Cloud CDB, providing a comprehensive case study for database engineers and cloud architects.
This article explains the principles, evolution, modern structures, compaction strategies, optimization techniques such as Bloom filters and partitioning, and concurrency and recovery mechanisms of Log-Structured Merge (LSM) trees, which are widely used in contemporary NoSQL storage systems.
This article chronicles Tencent's database team overcoming three major challenges—supporting WeChat red packets, stabilizing Honor of Kings gameplay, and ensuring Tencent Video streaming—by developing CKV, CDB, TcaplusDB, and DBBrain technologies that balance performance, cost, and reliability.
This article explains the fundamentals of MySQL InnoDB transaction isolation levels, describes the four standard isolation grades, shows how InnoDB implements them in source code, and provides concrete case studies with SQL scripts to illustrate locking behavior and MVCC effects.
The article presents an in‑depth technical overview of Tencent Cloud's CynosDB, describing the challenges of traditional MySQL‑based cloud databases, detailing its compute‑storage decoupled architecture, redo‑log based replication, MVCC implementation, performance enhancements, and how these innovations address elasticity, stability, and resource utilization issues.
