BestHub
Sign in
Tencent Database Technology
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.

96
Articles
0
Likes
206
Views
0
Comments
Recent Articles

Latest from Tencent Database Technology

96 recent articles
Tencent Database Technology
Tencent Database Technology
Jul 8, 2019 · Databases

SIGMOD 2019 Highlights: Blockchain Keynote, CDBTune Paper on Cloud Database Tuning, and Emerging Database Research

The report summarizes SIGMOD/PODS 2019 in Amsterdam, covering a blockchain-focused keynote, the CDBTune paper on end‑to‑end automatic cloud database tuning using deep reinforcement learning, modern hardware research, award‑winning systems, and related industry activities, providing a comprehensive academic overview.

Database TuningDeep Reinforcement LearningResearch Highlights
0 likes · 7 min read
SIGMOD 2019 Highlights: Blockchain Keynote, CDBTune Paper on Cloud Database Tuning, and Emerging Database Research
Tencent Database Technology
Tencent Database Technology
Jun 27, 2019 · Databases

Analysis and Optimization of InnoDB lock_wait_thread Contention in a Tencent Cloud Database

The article investigates intermittent slow update performance in a Tencent Cloud internal system caused by massive lock_wait_thread contention, analyzes the underlying InnoDB lock mechanisms and thread behavior, implements a fix by disabling lock_wait_suspend_thread triggers, and demonstrates substantial latency reduction through benchmark results.

InnoDBMySQLPerformance optimization
0 likes · 8 min read
Analysis and Optimization of InnoDB lock_wait_thread Contention in a Tencent Cloud Database
Tencent Database Technology
Tencent Database Technology
Jun 4, 2019 · Databases

From SEQUEL to JSON: Tracing the Evolution of SQL Standards

This article chronicles the origins, standardization process, historical milestones, learning resources, and conformance challenges of SQL standards, highlighting key ISO/IEC versions, the roles of major vendors, and the growing complexity of the language over more than three decades.

ANSIDatabase StandardsISO
0 likes · 11 min read
From SEQUEL to JSON: Tracing the Evolution of SQL Standards
Tencent Database Technology
Tencent Database Technology
Apr 18, 2019 · Databases

MySQL Execution Process and SemiJoin Optimization Techniques

This article explains MySQL's execution stages, defines SemiJoin, details how IN subqueries can be transformed into SemiJoin queries, outlines conversion constraints, provides example transformations, and describes the various execution strategies MySQL may use for SemiJoins.

MySQLQuery OptimizationSQL
0 likes · 13 min read
MySQL Execution Process and SemiJoin Optimization Techniques
Tencent Database Technology
Tencent Database Technology
Mar 12, 2019 · Databases

Understanding MySQL 8.0 Data Dictionary, Atomic DDL, and Persistent Autoincrement

This article explains the evolution of MySQL's data dictionary from pre‑8.0 scattered metadata to the unified InnoDB dictionary tables in MySQL 8.0, covering storage structures, dictionary caching, information_schema changes, serialized dictionary information (SDI), atomic DDL mechanisms, persistent autoincrement handling, upgrade considerations, and provides practical code examples.

Atomic DDLInnoDBMySQL
0 likes · 22 min read
Understanding MySQL 8.0 Data Dictionary, Atomic DDL, and Persistent Autoincrement
Tencent Database Technology
Tencent Database Technology
Feb 27, 2019 · Operations

Elasticsearch Cluster Recovery Pitfall: Excessive Shard Recovery Concurrency Leads to Cluster Hang

This article details a real‑world Elasticsearch cluster recovery issue where setting the shard recovery concurrency too high saturated the generic thread pool, causing the entire cluster to hang, and explains the underlying concepts, reproduction steps, analysis, and mitigation measures.

Cluster RecoveryTroubleshootingshard-recovery
0 likes · 10 min read
Elasticsearch Cluster Recovery Pitfall: Excessive Shard Recovery Concurrency Leads to Cluster Hang
Tencent Database Technology
Tencent Database Technology
Jan 24, 2019 · Databases

Architecture Evolution and Performance Optimization of Tencent's CKV Distributed In-Memory Storage System

This article details the architectural evolution and comprehensive refactoring of Tencent's CKV distributed in-memory key-value storage system, highlighting its transition to a two-tier single-process multi-threaded model, multi-tenant resource isolation, deep Redis protocol compatibility, and optimized memory engine, which collectively deliver significant improvements in performance, scalability, and operational cost efficiency.

Database ArchitectureIn-Memory DatabaseMulti-Tenant Architecture
0 likes · 10 min read
Architecture Evolution and Performance Optimization of Tencent's CKV Distributed In-Memory Storage System
Tencent Database Technology
Tencent Database Technology
Jan 8, 2019 · Databases

Performance Optimization of TXRocks Sum Operation: Pushdown, Record Conversion, and Multithreaded Concurrency

This article analyzes the high space efficiency but poor sum performance of TXRocks compared to InnoDB, identifies three main bottlenecks, and details three optimizations—sum push‑down, selective record conversion, and multithreaded execution—that together reduce query latency to less than 5% of InnoDB’s original time.

MySQLPerformance optimizationRocksDB
0 likes · 12 min read
Performance Optimization of TXRocks Sum Operation: Pushdown, Record Conversion, and Multithreaded Concurrency