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

May 9, 2018 · Databases

Optimizing Xtrabackup Recovery Process for InnoDB Databases

Xtrabackup is an open-source hot backup tool for InnoDB and XtraDB databases, offering non-blocking backups with features like fast backup speeds, reliable physical backups, and efficient disk space usage. The recovery process involves complex log parsing and page flushing mechanisms, which can be optimized to improve performance, especially for large datasets.

Backup ToolsDatabase ManagementDatabase Recovery

0 likes · 16 min read

Optimizing Xtrabackup Recovery Process for InnoDB Databases

Tencent Database Technology

May 3, 2018 · Databases

Understanding RocksDB Write Process and Group Commit Mechanism

This article explains the ACID properties, write‑ahead logging, and how RocksDB implements a three‑step write path and a leader‑follower Group Commit mechanism to improve transaction throughput by batching fsync operations.

Group CommitRocksDBWrite-Ahead Logging

0 likes · 10 min read

Understanding RocksDB Write Process and Group Commit Mechanism

Tencent Database Technology

Feb 2, 2018 · Databases

In-Depth Exploration of InnoDB Bulk Index Build

This article provides a comprehensive technical overview of InnoDB's bulk index build feature introduced in MySQL 5.7, detailing its design, fast index build phases, bottom‑up construction, dirty‑page flushing, compressed‑table handling, fill‑factor configuration, and potential future optimizations.

Bulk Index BuildDatabase PerformanceFast Index Build

0 likes · 8 min read

In-Depth Exploration of InnoDB Bulk Index Build

Tencent Database Technology

Jan 8, 2018 · Databases

Understanding MySQL Binlog: Management, Formats, Replication, and Recovery

This article explains the fundamentals of MySQL binary logs, how to enable and query them, the different binlog formats, practical steps for setting up master‑slave replication, and methods for using binlog to recover data after accidental changes.

MySQLRecoverydatabase

0 likes · 15 min read

Understanding MySQL Binlog: Management, Formats, Replication, and Recovery

Tencent Database Technology

Jan 2, 2018 · Databases

Understanding SHOW ENGINE ROCKSDB STATUS: Statistics and Background Thread Implementation in MyRocks

This article explains the internal workings of the SHOW ENGINE ROCKSDB STATUS command in MyRocks, detailing how STATISTICS and BG_THREADS data are collected, the underlying RocksDB APIs, code structures, and how to extend these mechanisms for performance monitoring and debugging.

Background ThreadsDatabase MonitoringMyRocks

0 likes · 10 min read

Understanding SHOW ENGINE ROCKSDB STATUS: Statistics and Background Thread Implementation in MyRocks

Tencent Database Technology

Dec 28, 2017 · Databases

CDB for MySQL Read-Only Instances and RO Group Architecture and Features

This article explains the architecture and key features of CDB for MySQL read-only instances and RO groups, including read-write separation, horizontal scaling, automatic load balancing, health checks, and dynamic instance removal for high-delay instances.

Health CheckMySQLRO Group

0 likes · 5 min read

CDB for MySQL Read-Only Instances and RO Group Architecture and Features

Tencent Database Technology

Dec 27, 2017 · Fundamentals

Why ls Slows Down on Directories with Millions of Files and How to Speed It Up Using getdents

The article explains that the ls command becomes slow on directories containing millions of files because it repeatedly calls the getdents system call through readdir, and demonstrates how directly using getdents with a larger buffer can reduce the listing time from several seconds to under one second.

FilesystemLinuxgetdents

0 likes · 10 min read

Why ls Slows Down on Directories with Millions of Files and How to Speed It Up Using getdents

Tencent Database Technology

Dec 14, 2017 · Databases

Performance Bottlenecks and Mitigation Strategies for MySQL DROP TABLE on Large InnoDB Tables

The article analyzes why dropping large InnoDB tables in MySQL can drastically degrade overall database performance due to buffer‑pool mutex and file‑system I/O bottlenecks, and presents both operational work‑arounds and source‑code modifications to alleviate the issue.

DROP TABLEIOInnoDB

0 likes · 10 min read

Performance Bottlenecks and Mitigation Strategies for MySQL DROP TABLE on Large InnoDB Tables

Tencent Database Technology

Dec 7, 2017 · Databases

Implementation and Optimizations of Percona 5.7 Thread Pool

This article explains how Percona Server 5.7 implements a thread‑pool model for MySQL, detailing the activation parameters, internal architecture, functional threads, timer mechanisms, and several performance optimizations such as priority scheduling and special handling for long‑running commands.

Database PerformanceMySQLPercona

0 likes · 13 min read

Implementation and Optimizations of Percona 5.7 Thread Pool

Tencent Database Technology

Dec 5, 2017 · Databases

Understanding MySQL Multi‑Threaded Slave (MTS) Parallel Replication: Schema, Commit‑Parent, and Lock‑Interval Methods

This article explains MySQL's evolution of parallel replication—from schema‑based MTS in 5.6, through commit‑parent based replication in 5.7, to the more efficient lock‑interval approach—detailing the underlying binlog group‑commit mechanisms, master‑side support, and the slave‑side worker coordination that together reduce replication lag.

MTSMySQLparallel replication

0 likes · 19 min read

Understanding MySQL Multi‑Threaded Slave (MTS) Parallel Replication: Schema, Commit‑Parent, and Lock‑Interval Methods