Author

Tencent Database Technology

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.

Articles

Likes

206

Views

Comments

Latest from Tencent Database Technology

96 recent articles

Tencent Database Technology

Jan 19, 2022 · Databases

Deep Dive into Tencent's Self‑Developed MySQL Kernel TXSQL and Its Architecture

This article provides a comprehensive overview of Tencent's self‑developed MySQL kernel TXSQL, covering its evolution, overall architecture, columnar storage engine, instant DDL capabilities, enterprise‑grade features, high‑availability mechanisms, performance optimizations, and the rigorous development and testing processes behind the product.

Columnar StorageMySQLPerformance optimization

0 likes · 11 min read

Deep Dive into Tencent's Self‑Developed MySQL Kernel TXSQL and Its Architecture

Tencent Database Technology

Dec 31, 2021 · Databases

Practices and Exploration of Disaster Recovery in Cloud‑Native Database TDSQL‑C (formerly CynosDB)

This article examines the architecture differences between traditional MySQL and the cloud‑native TDSQL‑C database, outlines MySQL disaster‑recovery deployment models, and details TDSQL‑C’s multi‑dimensional disaster‑recovery system, including its agent‑scheduler design, cross‑AZ switching challenges, and mitigation strategies.

Cloud‑Native DatabaseMySQLTDSQL-C

0 likes · 10 min read

Practices and Exploration of Disaster Recovery in Cloud‑Native Database TDSQL‑C (formerly CynosDB)

Tencent Database Technology

Dec 29, 2021 · Databases

In-Depth Analysis of Hash Join Implementation and Execution Flow in MySQL 8.0

The article explores MySQL's Hash Join algorithms, comparing Basic, On-disk, Grace, and Hybrid variants, while detailing rule-based optimizer decisions, memory management, disk spilling mechanisms, and outer join execution strategies through source code analysis.

Hash JoinJoin AlgorithmsMySQL

0 likes · 21 min read

In-Depth Analysis of Hash Join Implementation and Execution Flow in MySQL 8.0

Tencent Database Technology

Nov 16, 2021 · Databases

InnoDB Transaction System, MVCC, and Locking Mechanisms – A Comprehensive Overview

This article provides an in‑depth explanation of MySQL InnoDB’s transaction system, covering ACID properties, isolation levels, MVCC implementation, various lock types, key data structures, lock acquisition flows, semi‑consistent reads, insert locking, implicit‑to‑explicit lock conversion, and rollback mechanisms.

InnoDBMVCCMySQL

0 likes · 26 min read

InnoDB Transaction System, MVCC, and Locking Mechanisms – A Comprehensive Overview

Tencent Database Technology

Nov 12, 2021 · Databases

Key Features and Optimizations of Tencent Cloud‑Native Database TDSQL‑C

The article details Tencent Cloud's TDSQL‑C database, explaining traditional database limitations, its cloud‑native architecture, four standout capabilities such as petabyte storage and serverless billing, and the extensive kernel optimizations that enable rapid scaling, backup, indexing, and future cross‑region reads.

BackupTDSQL-Ccloud-native

0 likes · 7 min read

Key Features and Optimizations of Tencent Cloud‑Native Database TDSQL‑C

Tencent Database Technology

Oct 20, 2021 · Databases

Percona Thread Pool Implementation and TXSQL Optimizations: Architecture, Dynamic Switching, Load Balancing, and Disconnection Handling

This article explains the background, principles, architecture, and detailed implementation of Percona's thread pool, and describes TXSQL's dynamic thread‑pool activation, load‑balancing strategies, disconnection optimizations, related configuration parameters, status variables, and a concise summary.

Connection HandlingLoad BalancingMySQL

0 likes · 27 min read

Percona Thread Pool Implementation and TXSQL Optimizations: Architecture, Dynamic Switching, Load Balancing, and Disconnection Handling

Tencent Database Technology

Oct 13, 2021 · Databases

Tencent Cloud MongoDB Enhances maxTimeMS Handling to Avoid Service Avalanche

This article explains how Tencent Cloud MongoDB improves the maxTimeMS server-side timeout feature to prevent request backlog and service avalanche, covering native MongoDB limitations, optimizations in mongos write command support, and default configuration implementation.

MongoDBService AvalancheTencent Cloud

0 likes · 10 min read

Tencent Cloud MongoDB Enhances maxTimeMS Handling to Avoid Service Avalanche

Tencent Database Technology

Sep 14, 2021 · Databases

Writeset‑Based Replication in MySQL: Background, Principles, Source‑Code Analysis, Testing, and Summary

This article explains how MySQL’s logical‑clock replication can be enhanced with writeset‑based dependency tracking, detailing the underlying theory, code implementation, configuration options, performance testing, and practical considerations for improving parallel applier concurrency.

MySQLTransaction DependencyWriteSet

0 likes · 12 min read

Writeset‑Based Replication in MySQL: Background, Principles, Source‑Code Analysis, Testing, and Summary

Tencent Database Technology

Sep 8, 2021 · Databases

Tencent Cloud Enterprise MySQL Dynamic Thread‑Pool Feature Overview

The article explains Tencent Cloud's enterprise‑level MySQL dynamic thread‑pool capability, describing the one‑thread‑per‑connection and thread‑pool modes, the new thread_handling_switch_mode parameter with its four options, status‑monitoring commands, and added columns for process‑list visibility, enabling seamless mode switching without server restarts.

Database PerformanceDynamic SwitchingMySQL

0 likes · 6 min read

Tencent Cloud Enterprise MySQL Dynamic Thread‑Pool Feature Overview

Tencent Database Technology

Sep 6, 2021 · Cloud Native

Cloud‑Native ClickHouse Architecture and Design Overview

This article presents a comprehensive design of a cloud‑native ClickHouse OLAP system, detailing its three‑layer architecture, storage‑compute separation, unified metadata management, high‑availability mechanisms, elastic scaling, cost reductions, and future enhancements for multi‑replica and MPP query support.

ClickHouseOLAPcloud-native

0 likes · 19 min read

Cloud‑Native ClickHouse Architecture and Design Overview