BestHub
Sign in
Efficient Ops
Efficient Ops
Feb 11, 2026 · Databases

How Merged Seckill Boosts MySQL Write Throughput by 5× for High‑Concurrency Flash Sales

The article explains a MySQL kernel‑level merged seckill optimization that replaces traditional queue‑based flash‑sale handling, achieving up to 5‑fold throughput gains (up to 1.5 W/s) without requiring SQL changes, detailing background, performance results, bottleneck analysis, design of cache visibility, leader‑follower coordination, row‑lock refinements, binlog parallelism, and crash‑recovery considerations.

MySQLPerformanceSeckill
0 likes · 12 min read
How Merged Seckill Boosts MySQL Write Throughput by 5× for High‑Concurrency Flash Sales
JD Tech Talk
JD Tech Talk
Nov 7, 2024 · Databases

Understanding Bloom Filters and Cuckoo Filters

This article explains Bloom filters and Cuckoo filters, covering their principles, implementations, and practical applications in database optimization.

Cuckoo FilterData Structuresalgorithm
0 likes · 12 min read
Understanding Bloom Filters and Cuckoo Filters
Tencent Cloud Developer
Tencent Cloud Developer
May 15, 2023 · Operations

Taking Over and Stabilizing a Complex Legacy System: Tencent's Practical Experience

Tencent’s team successfully took over a 93‑service legacy content architecture, stabilizing it by building comprehensive monitoring, creating detailed code walkthrough documentation, fixing critical bugs, and streamlining R&D processes, which cut daily alerts from 159 to zero, reduced business incidents, and lowered on‑call staffing dramatically.

CI/CDSystem monitoringalert-governance
0 likes · 24 min read
Taking Over and Stabilizing a Complex Legacy System: Tencent's Practical Experience
Top Architect
Top Architect
Aug 29, 2020 · Databases

SQL Query Optimization and Stored Procedure Refactoring for Large‑Scale MES Reporting

The article describes how a massive MES reporting query that took over half an hour to run was analyzed, re‑engineered with proper indexing, partitioning considerations, and a comprehensive stored‑procedure redesign, resulting in sub‑second response times for both backend analysis and front‑end B/S applications.

Stored Proceduredatabase-optimization
0 likes · 22 min read
SQL Query Optimization and Stored Procedure Refactoring for Large‑Scale MES Reporting