Skip to content
Tagged articles

Seckill Inventory

1 articles · Page 1 of 1
Rain's Path to Java Mastery
Rain's Path to Java Mastery
Oct 22, 2026 · Databases

MySQL High-Concurrency Optimization: From Diagnosis to Sharding with Seckill Case Study

A layered MySQL optimization guide for high-concurrency scenarios covering bottleneck diagnosis, SQL/index tuning, transaction/lock optimization, a three-layer seckill inventory implementation (Redis Lua, MQ async, sharded buckets), caching patterns, read-write separation, connection pooling, InnoDB tuning, and sharding trade-offs, with real production metrics showing P99 latency dropping from 1.2s to 85ms.

CachingConnection PoolHigh Concurrency
0 likes · 64 min read
MySQL High-Concurrency Optimization: From Diagnosis to Sharding with Seckill Case Study