BestHub
Sign in
Tagged articles

concurrency control

81 articles · Page 1 of 1
LuTiao Programming
LuTiao Programming
Sep 28, 2026 · Backend Development

Java Discount Allocation: Solving the 1-Cent Rounding Error in Partial Refunds

The article presents a Java solution for allocating order-level discounts to individual items using integer arithmetic and deterministic remainder distribution, ensuring accurate partial refunds by persisting per-unit prices, allocated discounts, and payable amounts at checkout, with database schema and concurrency considerations.

BigIntegerJavaconcurrency control
0 likes · 12 min read
Java Discount Allocation: Solving the 1-Cent Rounding Error in Partial Refunds
LuTiao Programming
LuTiao Programming
Sep 27, 2026 · Backend Development

Why the 101st Waitlist User Never Gets Skipped: Atomic Promotion with MySQL Row Locks

This article demonstrates how to implement a correct waitlist auto-promotion system for limited-capacity events using Spring Boot, MySQL InnoDB row locks, and database transactions to atomically handle cancellations and promotions without race conditions, ensuring the first waitlisted user always gets the freed spot.

Database TransactionsInnoDBJava 17
0 likes · 12 min read
Why the 101st Waitlist User Never Gets Skipped: Atomic Promotion with MySQL Row Locks
LuTiao Programming
LuTiao Programming
Sep 25, 2026 · Backend Development

How One SQL Statement Solves the Order Closure vs Payment Callback Race

This article demonstrates how to prevent race conditions between order timeout closure and payment callbacks using atomic conditional UPDATE statements and SELECT FOR UPDATE with a refund outbox pattern, ensuring either payment wins and order becomes PAID, or closure wins and late payments trigger automatic refund compensation.

InnoDBMySQLSpring Boot
0 likes · 11 min read
How One SQL Statement Solves the Order Closure vs Payment Callback Race
IT Services Circle
IT Services Circle
Sep 25, 2026 · Databases

Why MySQL Needs Four Isolation Levels Despite MVCC's Lock-Free Reads

This article explains how MySQL's MVCC uses version chains and ReadViews to enable lock-free snapshot reads, why isolation levels control ReadView creation timing (per-statement vs per-transaction), and why READ UNCOMMITTED and SERIALIZABLE bypass MVCC entirely, while writes still require row locks.

InnoDBMVCCMySQL
0 likes · 8 min read
Why MySQL Needs Four Isolation Levels Despite MVCC's Lock-Free Reads
Shepherd Advanced Notes
Shepherd Advanced Notes
Sep 24, 2026 · Backend Development

Building a Lightweight Approval Flow with AI: Why Flowable Wasn't the Right Fit

The author details building a lightweight approval flow end-to-end using AI (Codex), covering process modeling, dynamic forms, conditional and parallel branches, task routing, path replay, and analytics, while explaining why Flowable was rejected due to excessive tables, steep learning curve, integration difficulty, and the need for a lightweight, configurable solution.

AI-assisted developmentFlowableapproval flow
0 likes · 29 min read
Building a Lightweight Approval Flow with AI: Why Flowable Wasn't the Right Fit
LuTiao Programming
LuTiao Programming
Sep 18, 2026 · Backend Development

Spring Boot 5GB File Upload: Chunked, Resumable & Instant Upload Implementation

The author evolves a simple Spring Boot file upload to handle 5GB files by implementing 8MB chunked uploads, resumable upload via chunk tracking, instant upload via SHA-256 deduplication, with database schema, REST API design, streaming merge, database-level concurrency control, and automated cleanup of expired uploads.

Spring Bootchunked uploadconcurrency control
0 likes · 15 min read
Spring Boot 5GB File Upload: Chunked, Resumable & Instant Upload Implementation
IT Services Circle
IT Services Circle
Sep 15, 2026 · Backend Development

How to Diagnose and Resolve CPU/Memory Spikes in Agent Batch Processing

This article details a systematic approach to diagnosing and resolving CPU and memory spikes when an Agent processes large document batches, covering backpressure propagation, concurrency budgeting, runtime profiling, and pipeline design to prevent OOM kills and throttling.

AgentBackpressureBatch Processing
0 likes · 23 min read
How to Diagnose and Resolve CPU/Memory Spikes in Agent Batch Processing
LuTiao Programming
LuTiao Programming
Sep 11, 2026 · Backend Development

API Latency Spike to 8s: Not Slow SQL, But Long Transactions Holding DB Connections

An API's sudden latency spike from 200ms to 8 seconds was traced not to slow SQL but to database connection pool exhaustion caused by @Transactional methods holding connections during external HTTP calls to a payment service; splitting transactions and moving external calls outside the transaction boundary resolved the issue.

Database Connection PoolHikariCPPerformance Troubleshooting
0 likes · 15 min read
API Latency Spike to 8s: Not Slow SQL, But Long Transactions Holding DB Connections
Programmer XiaoFu
Programmer XiaoFu
Sep 8, 2026 · Databases

Why MySQL Still Needs Four Isolation Levels Despite MVCC's Lock-Free Reads

This article explains how MySQL's MVCC mechanism uses version chains and ReadViews to enable lock-free snapshot reads, and why four isolation levels (READ UNCOMMITTED, READ COMMITTED, REPEATABLE READ, SERIALIZABLE) are still necessary: they define when ReadViews are created, controlling which version a transaction sees, while MVCC only handles reads—writes still require row locks.

InnoDBMVCCMySQL
0 likes · 9 min read
Why MySQL Still Needs Four Isolation Levels Despite MVCC's Lock-Free Reads
Cloud Architecture
Cloud Architecture
Sep 7, 2026 · Backend Development

Why a Single Timeout Spawned Two Risk Reviews: Production MCP Server Patterns

The article analyzes a timeout-induced duplicate risk review incident, then presents a comprehensive production-grade MCP server design covering stateless protocol alignment, schema validation, dual-key idempotency (request_key + business_key), UNKNOWN state machine, recovery workers, MCP Tasks integration, concurrency control, observability, and fault-injection testing to ensure exactly-once business effects.

MCPModel Context ProtocolProduction Engineering
0 likes · 27 min read
Why a Single Timeout Spawned Two Risk Reviews: Production MCP Server Patterns
Programmer XiaoFu
Programmer XiaoFu
Aug 28, 2026 · Backend Development

Why Spring Cloud Gateway Rate Limiting Fails to Protect Downstream Services

The article analyzes five reasons why Spring Cloud Gateway's Redis-based token bucket rate limiting fails to protect downstream services during traffic bursts, including QPS vs. concurrency confusion, burstCapacity spikes, multi-route quota multiplication, KeyResolver fallback flaws, and Redis bottleneck fail-open behavior, then recommends tightening burst limits, adding downstream concurrency isolation with Sentinel/Resilience4j, and hardening KeyResolver configuration.

Burst TrafficRate LimitingRedis
0 likes · 13 min read
Why Spring Cloud Gateway Rate Limiting Fails to Protect Downstream Services
LuTiao Programming
LuTiao Programming
Aug 19, 2026 · Backend Development

Recreating WeChat‑Style Message Recall with Spring Boot: Why Deleting Isn’t the Hard Part

The article walks through building a true WeChat‑like message recall feature in Spring Boot, explaining why simply deleting a row is insufficient and detailing the required status change, concurrency‑safe conditional update, multi‑device session handling, and cross‑instance event propagation.

Conditional UpdateSpring Bootconcurrency control
0 likes · 12 min read
Recreating WeChat‑Style Message Recall with Spring Boot: Why Deleting Isn’t the Hard Part
Architecture & Thinking
Architecture & Thinking
Aug 10, 2026 · Backend Development

From a Config Update API to Locking Strategies: Optimistic vs Pessimistic Locks Explained

After encountering potential data overwrite when updating configuration via an API, the author implements an optimistic lock using version numbers and revisits the fundamentals, comparing pessimistic and optimistic locking mechanisms, their implementations in SQL and Java, performance traits, pitfalls, and guidelines for choosing the appropriate strategy.

JavaOptimistic LockPessimistic Lock
0 likes · 8 min read
From a Config Update API to Locking Strategies: Optimistic vs Pessimistic Locks Explained
Coder Life Journal
Coder Life Journal
Jul 20, 2026 · Backend Development

Redis Distributed Lock with Three Checks: Why Small Projects Should Rethink Its Use

The article analyzes Redis distributed locks—its three‑step verification, the limited guarantees it provides, and why small‑to‑medium projects should often prefer database constraints, idempotency keys, or state machines over adding a lock that introduces extra complexity and maintenance overhead.

Database ConstraintsRedisbackend development
0 likes · 10 min read
Redis Distributed Lock with Three Checks: Why Small Projects Should Rethink Its Use
IT Services Circle
IT Services Circle
Jul 14, 2026 · Backend Development

Designing a Restaurant Reservation System: How to Slice Time Granularity?

The article compares interview‑style answers and real‑world production for a restaurant reservation system, outlining six design dimensions, three time‑slot strategies, five engineering challenges, and architectural considerations to help engineers choose the right granularity and avoid common pitfalls.

backend designconcurrency controldistributed systems
0 likes · 15 min read
Designing a Restaurant Reservation System: How to Slice Time Granularity?
YiSu Grain
YiSu Grain
Jul 8, 2026 · Databases

Why a Transfer Can’t Just Deduct Money – A Simple Guide to ACID Transactions

The article uses a simple money‑transfer scenario to introduce database transactions, explains the four ACID properties, illustrates common concurrency anomalies such as dirty reads, non‑repeatable reads and phantom reads, and outlines the four isolation levels with their trade‑offs and default settings in MySQL and Oracle.

ACIDDatabase TransactionsMySQL
0 likes · 8 min read
Why a Transfer Can’t Just Deduct Money – A Simple Guide to ACID Transactions
Cloud Architecture
Cloud Architecture
Jun 24, 2026 · Backend Development

Four Levels of Concurrency Control: Optimistic Locks to Message Queues for Million‑QPS

High‑concurrency systems must go beyond simple locking; the article breaks down four progressive strategies—optimistic locking, database pessimistic locking, Redis distributed locks, and finally message‑queue serialization—explaining their trade‑offs, implementation details, pitfalls, and how to combine them into a layered architecture that sustains million‑QPS workloads with consistency, throughput, and recoverability.

Optimistic LockPessimistic LockRedis Lock
0 likes · 32 min read
Four Levels of Concurrency Control: Optimistic Locks to Message Queues for Million‑QPS
Cloud Architecture
Cloud Architecture
May 29, 2026 · Cloud Native

DAG‑as‑Code: Building a Production‑Grade Batch Orchestration System with Argo Workflows

This article explains how to design and operate a scalable, multi‑tenant batch processing platform on Kubernetes using Argo Workflows, covering core concepts, DAG scheduling, concurrency control, controller scaling, artifact handling, event‑driven triggers, and practical best‑practice patterns for production reliability and cost efficiency.

Argo WorkflowsBatch ProcessingKubernetes
0 likes · 33 min read
DAG‑as‑Code: Building a Production‑Grade Batch Orchestration System with Argo Workflows
JD Tech
JD Tech
Dec 16, 2025 · Databases

How DongSQL’s New Kernel Boosts E‑commerce DB Performance by Up to 215%

The article provides an in‑depth technical analysis of DongSQL V1.1.0, detailing its syntax extensions, concurrency control mechanisms, query‑execution optimizations, thread‑pool redesign, and extensive benchmark results that demonstrate significant performance gains for e‑commerce workloads.

concurrency controle-commerceperformance benchmark
0 likes · 13 min read
How DongSQL’s New Kernel Boosts E‑commerce DB Performance by Up to 215%
Sohu Tech Products
Sohu Tech Products
Dec 3, 2025 · Databases

Why MySQL Uses MVCC: A Deep Dive into Concurrency, Isolation Levels, and Read Views

This article explains MySQL InnoDB’s MVCC mechanism, why it replaces traditional locking, details the four SQL isolation levels, illustrates dirty, non‑repeatable and phantom reads with examples, and breaks down the hidden fields, undo‑log chain, and read‑view algorithm that enable high‑concurrency, non‑blocking reads and writes.

InnoDBMVCCMySQL
0 likes · 18 min read
Why MySQL Uses MVCC: A Deep Dive into Concurrency, Isolation Levels, and Read Views
JD Tech Talk
JD Tech Talk
Dec 3, 2025 · Databases

How DongSQL’s Syntax Extensions and Concurrency Controls Supercharge E‑commerce Performance

This article provides an in‑depth technical analysis of DongSQL’s kernel redesign—including RETURNING clause, Inventory Hint, CCL concurrency control, Statement Outline, and thread‑pool optimizations—showing how each feature dramatically improves throughput and latency for high‑traffic e‑commerce workloads.

SQLconcurrency controldatabases
0 likes · 12 min read
How DongSQL’s Syntax Extensions and Concurrency Controls Supercharge E‑commerce Performance
Mike Chen's Internet Architecture
Mike Chen's Internet Architecture
Sep 24, 2025 · Databases

Unlock MySQL Performance: How Optimistic Locking Works

This article explains MySQL's optimistic locking strategy, detailing how a version column enables conflict detection during updates, provides step‑by‑step SQL examples, compares it with pessimistic locking, and shows why it improves performance in read‑heavy, low‑conflict environments.

MySQLOptimistic Lockconcurrency control
0 likes · 3 min read
Unlock MySQL Performance: How Optimistic Locking Works
Rare Earth Juejin Tech Community
Rare Earth Juejin Tech Community
Sep 3, 2025 · Frontend Development

Fast, Resumable Large File Uploads with Vue & Express

This article walks through a complete Vue‑and‑Express solution for uploading massive files, detailing chunked splitting, hash‑based instant upload detection, resumable transfers, concurrency control, manual abort handling, and server‑side merging using streams, providing ready‑to‑use code snippets and performance optimizations.

ChunkingExpressVue
0 likes · 18 min read
Fast, Resumable Large File Uploads with Vue & Express
Smart Sea Tide
Smart Sea Tide
Aug 25, 2025 · Big Data

Hudi vs Delta Lake vs Iceberg: Deep Technical Comparison of Data Lake Table Formats

This article provides a detailed technical comparison of Apache Hudi, Delta Lake, and Apache Iceberg, covering core features such as incremental pipelines, concurrency control, merge‑on‑read, partition evolution, multi‑mode indexing, ingestion tools, and real‑world use cases, and explains why Hudi often leads for heavy update workloads.

Apache HudiApache IcebergData Lake
0 likes · 14 min read
Hudi vs Delta Lake vs Iceberg: Deep Technical Comparison of Data Lake Table Formats
JavaScript
JavaScript
Jul 1, 2025 · Frontend Development

How to Prevent Request Overload with a Simple Frontend Request Queue

When a page needs to fire many simultaneous requests—such as loading ten resources at once or uploading dozens of files—the browser can freeze and the server can be overwhelmed, so using a request queue to limit concurrency keeps both responsive and stable.

Async ProgrammingFrontend OptimizationJavaScript
0 likes · 7 min read
How to Prevent Request Overload with a Simple Frontend Request Queue
Senior Tony
Senior Tony
Jun 25, 2025 · Backend Development

When Is Using a Distributed Lock the Right Choice? A Deep Dive into Scenarios and Pitfalls

This article examines common interview scenarios involving distributed locks, explains why they are often misused, outlines their proper use cases such as rate limiting, ensuring data consistency, and achieving ordered processing, and compares distributed locks with distributed transactions.

backend architectureconcurrency controldistributed transaction
0 likes · 8 min read
When Is Using a Distributed Lock the Right Choice? A Deep Dive into Scenarios and Pitfalls
Cognitive Technology Team
Cognitive Technology Team
Jun 7, 2025 · Databases

Mastering MySQL Locks: Types, Mechanisms, and Best Practices

This article explains MySQL’s locking mechanisms, categorizing locks by performance, operation type, data granularity, and finer‑grained levels such as gap and next‑key locks, and offers guidance on selecting the appropriate lock strategy for reliable concurrent database operations.

Database LocksInnoDBMySQL
0 likes · 9 min read
Mastering MySQL Locks: Types, Mechanisms, and Best Practices
Open Source Tech Hub
Open Source Tech Hub
May 25, 2025 · Backend Development

How to Rate‑Limit Asynchronous Tasks with ReactPHP‑MQ

ReactPHP‑MQ provides a lightweight, SOLID‑designed queue for managing concurrent asynchronous operations, offering features like configurable concurrency limits, solid test coverage, and advanced methods such as all(), any(), and timeout handling for robust rate‑limiting in PHP applications.

PHPRate LimitingReactPHP
0 likes · 5 min read
How to Rate‑Limit Asynchronous Tasks with ReactPHP‑MQ
DataFunSummit
DataFunSummit
Sep 14, 2024 · Big Data

Apache Hudi Concurrency Control: Overview, MVCC, and OCC

This article provides a comprehensive overview of concurrency control in Apache Hudi, explaining ACID properties, the role of MVCC and OCC, and how Hudi coordinates multiple writers and table services to achieve serializable scheduling while maintaining high performance.

Apache HudiData LakeMVCC
0 likes · 8 min read
Apache Hudi Concurrency Control: Overview, MVCC, and OCC
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 26, 2024 · Databases

Slow Locking Logic in MySQL InnoDB

This article explains the slow‑path row‑locking algorithm used by InnoDB in MySQL 8.0.32, detailing how the engine checks whether a transaction already holds a lock, determines if it must wait, reuses existing lock structures, and allocates new ones when necessary.

Database InternalsInnoDBMySQL
0 likes · 15 min read
Slow Locking Logic in MySQL InnoDB
MaGe Linux Operations
MaGe Linux Operations
Feb 13, 2024 · Fundamentals

Understanding Optimistic vs Pessimistic Locks: When and How to Use Them

This article explains the purpose of locks in concurrent environments, compares optimistic (CAS) and pessimistic locking mechanisms, outlines their advantages, disadvantages, suitable scenarios, and provides PHP/PDO code examples demonstrating implementation and performance testing under high concurrency.

MySQLOptimistic LockPHP
0 likes · 11 min read
Understanding Optimistic vs Pessimistic Locks: When and How to Use Them
Architecture & Thinking
Architecture & Thinking
Nov 7, 2023 · Databases

How MySQL InnoDB Achieves High Concurrency with MVCC and Locks

This article explains MySQL InnoDB's concurrency control mechanisms—including read‑write locks, transaction isolation levels, MVCC, redo/undo logs, and rollback segments—and shows how they work together to ensure data consistency while maximizing read/write performance in high‑traffic environments.

InnoDBLocksMVCC
0 likes · 12 min read
How MySQL InnoDB Achieves High Concurrency with MVCC and Locks
SQB Blog
SQB Blog
Sep 6, 2023 · Operations

How to Build an Efficient, Secure Test Data Management System for DevOps

This article examines the challenges of test data generation in fast‑moving software projects and presents a self‑developed Test Data Management solution that balances efficiency, usability, security, quality, generality, and cost through adaptive concurrency control, masking policies, and a multi‑master architecture.

DevOpsconcurrency controldata security
0 likes · 15 min read
How to Build an Efficient, Secure Test Data Management System for DevOps
ByteDance Data Platform
ByteDance Data Platform
Jan 4, 2023 · Databases

How ByteHouse Enhances ClickHouse with Resource Isolation and High Availability

This article explains how ByteHouse, an enhanced version of ClickHouse used at ByteDance, adds full upsert support, multi‑table joins, high‑availability features, and, most importantly, a Resource Group mechanism that provides fine‑grained CPU, memory, and concurrency isolation to improve query performance and stability.

ByteHouseClickHouseResource Isolation
0 likes · 8 min read
How ByteHouse Enhances ClickHouse with Resource Isolation and High Availability
DataFunTalk
DataFunTalk
Nov 10, 2022 · Big Data

Enhancing ClickHouse Resource Isolation with ByteHouse Resource Group

This article explains how ByteHouse extends ClickHouse with a Resource Group mechanism that provides fine‑grained concurrency, memory, and CPU isolation, improving query latency, reducing variance, and increasing cluster stability for large‑scale ad‑tech workloads.

ByteHouseClickHouseResource Isolation
0 likes · 8 min read
Enhancing ClickHouse Resource Isolation with ByteHouse Resource Group
JavaEdge
JavaEdge
Aug 25, 2022 · Databases

How to Prevent Lost Updates: Atomic Writes, Explicit Locks, and CAS

The article explains why concurrent write transactions cause lost updates, then details practical solutions such as atomic update statements, explicit row‑level locking, automatic lost‑update detection, compare‑and‑swap (CAS) techniques, and special considerations for multi‑replica databases.

CASatomic writeconcurrency control
0 likes · 8 min read
How to Prevent Lost Updates: Atomic Writes, Explicit Locks, and CAS
Big Data Technology Architecture
Big Data Technology Architecture
Aug 23, 2022 · Big Data

Comparative Analysis of Apache Hudi, Delta Lake, and Apache Iceberg for Lakehouse Architectures

This article examines the technical differences and feature sets of Apache Hudi, Delta Lake, and Apache Iceberg, highlighting incremental pipelines, concurrency control, merge‑on‑read storage, partition evolution, multi‑mode indexing, and real‑world use cases to help practitioners choose the most suitable lakehouse solution for their workloads.

Apache HudiApache IcebergDelta Lake
0 likes · 18 min read
Comparative Analysis of Apache Hudi, Delta Lake, and Apache Iceberg for Lakehouse Architectures
Su San Talks Tech
Su San Talks Tech
Aug 8, 2022 · Databases

Mastering MySQL MVCC: How InnoDB Achieves Consistent Reads

This article demystifies MySQL's Multi‑Version Concurrency Control (MVCC) by explaining its Undo Log and Read View mechanisms, showing how InnoDB implements read‑committed and repeatable‑read isolation without locking, and illustrating the process with clear examples and diagrams.

Database isolationInnoDBMVCC
0 likes · 13 min read
Mastering MySQL MVCC: How InnoDB Achieves Consistent Reads
DeWu Technology
DeWu Technology
Jul 11, 2022 · Databases

SQL Fine-Grained Management and Concurrency Control Best Practices

The guide recommends fine‑grained MySQL management in a MyBatis‑based order system—avoiding generic or dynamic SQL, explicitly using indexes, listing columns, limiting results, batching inserts, and checking row counts—while applying appropriate concurrency control (pessimistic FOR UPDATE or optimistic versioning) to improve performance, stability, and data integrity.

Database OptimizationMyBatisSQL
0 likes · 18 min read
SQL Fine-Grained Management and Concurrency Control Best Practices
IT Services Circle
IT Services Circle
Jun 25, 2022 · Databases

Understanding Optimistic and Pessimistic Locks in MySQL

Optimistic and pessimistic locks are conceptual concurrency control strategies used across databases and caching systems; the article explains their principles, MySQL implementations with SELECT ... FOR UPDATE and version checks, compares their trade‑offs, and advises preferring optimistic locking in high‑concurrency scenarios.

MySQLOptimistic LockPessimistic Lock
0 likes · 6 min read
Understanding Optimistic and Pessimistic Locks in MySQL
Java Interview Crash Guide
Java Interview Crash Guide
Sep 11, 2021 · Backend Development

Mastering Rate Limiting: Algorithms, Strategies, and Real-World Implementations

This article explains why rate limiting is essential, outlines common strategies such as circuit breaking, service degradation, delay processing, and privilege handling, compares counter, leaky‑bucket and token‑bucket algorithms, and provides practical Java and Nginx‑Lua implementation examples for backend systems.

Circuit BreakerRate Limitingconcurrency control
0 likes · 13 min read
Mastering Rate Limiting: Algorithms, Strategies, and Real-World Implementations
Selected Java Interview Questions
Selected Java Interview Questions
May 29, 2021 · Databases

Understanding Database Locks: Shared, Exclusive, Mutex, Pessimistic, Optimistic, Row, Table, and Page Locks, and Common Concurrency Issues

This article explains the concepts, usage scenarios, and differences of various database locks—including shared (S) lock, exclusive (X) lock, mutex, pessimistic and optimistic locks—as well as row‑level, table‑level, and page‑level locks, and it discusses common concurrency problems such as lost updates, non‑repeatable reads, dirty reads, and deadlocks.

Database LocksMySQLOptimistic Lock
0 likes · 8 min read
Understanding Database Locks: Shared, Exclusive, Mutex, Pessimistic, Optimistic, Row, Table, and Page Locks, and Common Concurrency Issues
ITPUB
ITPUB
Apr 9, 2021 · Databases

Tencent TDSQL Reveals Infinite Database Anomalies and a Hands‑On Learning Tool

Tencent’s TDSQL team introduces a groundbreaking theory that precisely classifies an infinite set of database transaction anomalies, defines their categories via conflict‑graph analysis, and provides an open‑source Linux tool with step‑by‑step compilation instructions for interactive anomaly exploration.

Linux toolTDSQLconcurrency control
0 likes · 11 min read
Tencent TDSQL Reveals Infinite Database Anomalies and a Hands‑On Learning Tool
Xianyu Technology
Xianyu Technology
Dec 15, 2020 · Backend Development

How Xianyu Built the ‘Resale Lottery’ and ‘Money Tree’ Marketing Engines

This article examines Xianyu's two promotional features—Resale Lottery and Money Tree—detailing their gameplay, underlying business models, and the backend technical solutions such as event collection, idempotent reward accounting, concurrency control, fatigue management, and distributed locking.

Event Processingbackend developmentconcurrency control
0 likes · 11 min read
How Xianyu Built the ‘Resale Lottery’ and ‘Money Tree’ Marketing Engines
Architecture Digest
Architecture Digest
Oct 30, 2020 · Databases

Understanding Multiversion Concurrency Control (MVCC) in InnoDB

This article explains the concept of Multiversion Concurrency Control (MVCC), how it solves read‑write blocking, deadlocks and consistency issues, and details InnoDB’s implementation—including transaction IDs, hidden columns, undo logs, and the behavior of snapshot and current reads under various isolation levels.

InnoDBMVCCMySQL
0 likes · 9 min read
Understanding Multiversion Concurrency Control (MVCC) in InnoDB
Top Architect
Top Architect
Jun 2, 2020 · Backend Development

Improving Database Auto‑Increment Primary Keys for Distributed ID Generation

This article examines the limitations of using database auto‑increment primary keys for distributed ID generation and presents a segment‑allocation approach, discusses concurrency challenges, and introduces a double‑buffer strategy to reduce database load and improve fault tolerance.

ID segment allocationconcurrency controldatabase auto-increment
0 likes · 8 min read
Improving Database Auto‑Increment Primary Keys for Distributed ID Generation
Architecture Digest
Architecture Digest
Jul 31, 2019 · Backend Development

Design and Optimization of MaFengWo Membership System Architecture

This article details the evolution, architectural redesign, and performance optimizations of MaFengWo's membership system, covering identity strategy transformation, four‑layer service architecture, rights pool construction, third‑party integration, points integration, concurrency control, traffic shaping, and risk management to support scalable, high‑quality user experiences.

concurrency controlmembershiprisk management
0 likes · 17 min read
Design and Optimization of MaFengWo Membership System Architecture
Architects' Tech Alliance
Architects' Tech Alliance
Apr 3, 2019 · Databases

Choosing Between Optimistic and Pessimistic Locks in Production Systems

The article explains the concepts, advantages, and drawbacks of optimistic and pessimistic locking, provides real‑world examples such as lost updates and inconsistent reads, and offers practical guidelines and implementation techniques for selecting the appropriate concurrency control strategy in database‑driven applications.

Optimistic LockPessimistic Lockconcurrency control
0 likes · 10 min read
Choosing Between Optimistic and Pessimistic Locks in Production Systems
ITFLY8 Architecture Home
ITFLY8 Architecture Home
Mar 29, 2019 · Backend Development

How MVCC Beats Pessimistic Locks for Distributed Key‑Value Stores

This article examines a distributed system concurrency problem, compares lock‑based transactions with multiversion concurrency control (MVCC), and explains why MVCC often outperforms pessimistic locking in scenarios demanding high read responsiveness and low contention.

MVCCPessimistic Lockconcurrency control
0 likes · 10 min read
How MVCC Beats Pessimistic Locks for Distributed Key‑Value Stores
dbaplus Community
dbaplus Community
Mar 28, 2019 · Backend Development

How Distributed Locks Keep High‑Traffic Red‑Packet Systems Consistent

This article explains why traditional in‑process locks fail under massive concurrency, how distributed locks using Redis or Zookeeper ensure atomic updates across many servers, and details practical implementations, pitfalls like deadlocks, and strategies such as key expiration and ephemeral sequential nodes.

RedisZooKeeperbackend development
0 likes · 14 min read
How Distributed Locks Keep High‑Traffic Red‑Packet Systems Consistent
vivo Internet Technology
vivo Internet Technology
Mar 2, 2019 · Databases

MySQL Locks, Transactions, and Concurrency Control Overview

The article systematically explains MySQL’s locking mechanisms—including shared, exclusive, intention, gap, next‑key, insert‑intention, and auto‑increment locks—alongside transaction handling, isolation levels, MVCC‑based concurrency control, and deadlock detection and avoidance strategies, helping readers understand data consistency and performance.

LocksMVCCMySQL
0 likes · 23 min read
MySQL Locks, Transactions, and Concurrency Control Overview
Mafengwo Technology
Mafengwo Technology
Feb 21, 2019 · Backend Development

How MaFengWo Scaled Its Custom Travel Platform with Multi‑Order Grabbing and Real‑Time Matching

The article explains how MaFengWo built a custom travel transaction system that uses multi‑order distribution, a grab‑pool message queue, concurrency‑controlled locking, and long‑connection notifications to efficiently match personalized travel requests with multiple suppliers, boosting conversion rates and platform performance.

Long Connectionconcurrency controlcustom travel
0 likes · 9 min read
How MaFengWo Scaled Its Custom Travel Platform with Multi‑Order Grabbing and Real‑Time Matching
Youzan Coder
Youzan Coder
Jan 25, 2019 · Databases

MySQL/InnoDB Deadlock Analysis: Detection, Handling, and Prevention

The guide explains MySQL/InnoDB deadlocks—how circular lock waits arise, the wait‑for‑graph detection that rolls back the transaction with fewer undo logs, the various lock modes and their behavior in UPDATE/INSERT/DELETE, and practical strategies such as proper indexing, consistent access order, and configuration tweaks to detect, handle, and prevent deadlocks.

Database LocksDatabase OptimizationInnoDB
0 likes · 13 min read
MySQL/InnoDB Deadlock Analysis: Detection, Handling, and Prevention
Architects' Tech Alliance
Architects' Tech Alliance
Sep 11, 2018 · Databases

Pessimistic vs Optimistic Locking: A Story-Based Explanation

This article uses a humorous story of two threads battling over inventory updates to illustrate the principles, advantages, and drawbacks of pessimistic and optimistic locking in distributed systems, helping readers understand when to apply each concurrency control method.

Optimistic LockPessimistic Lockconcurrency control
0 likes · 8 min read
Pessimistic vs Optimistic Locking: A Story-Based Explanation
AntTech
AntTech
Aug 7, 2018 · Databases

A Timeline Review of Optimistic Concurrency Control (OCC) from Theory to Production Systems

This article presents a chronological overview of Optimistic Concurrency Control (OCC), covering its early theoretical foundations, key research papers, prototype implementations such as MVCC+OCC+2PC and Hekaton, and its adoption in modern distributed NewSQL databases like Megastore, F1, and MaaT, highlighting both advantages and challenges.

Database TransactionsNewSQLOCC
0 likes · 33 min read
A Timeline Review of Optimistic Concurrency Control (OCC) from Theory to Production Systems
Ctrip Technology
Ctrip Technology
Jan 25, 2017 · Backend Development

Handling Duplicate Messages, Ordering, Concurrency, and Batch Processing in Message‑Driven Systems

This article shares practical patterns and built‑in mechanisms for dealing with duplicate messages, message ordering, concurrent updates, asynchronous acknowledgments, and batch processing in a large‑scale, message‑driven architecture, illustrated with QMQ examples from Qunar's platform.

Batch ProcessingDuplicate Message Handlingbackend development
0 likes · 16 min read
Handling Duplicate Messages, Ordering, Concurrency, and Batch Processing in Message‑Driven Systems
ITPUB
ITPUB
May 22, 2016 · Databases

Why Optimistic Locking Improves High‑Concurrency Performance

Optimistic locking replaces heavyweight pessimistic locks with a version‑based approach, allowing concurrent reads and only checking a version or timestamp during updates, which reduces lock contention, improves performance under high concurrency, but requires careful handling of external updates to avoid dirty data.

Optimistic Lockingconcurrency controldatabase performance
0 likes · 5 min read
Why Optimistic Locking Improves High‑Concurrency Performance
MaGe Linux Operations
MaGe Linux Operations
Aug 23, 2014 · Databases

Understanding Database Transaction Isolation and Locking Protocols

This article explains the concurrency problems that arise in databases, describes the five types of read/write anomalies, details the three‑level lock protocol and the two‑phase locking rule, and compares the four standard isolation levels—Read Uncommitted, Read Committed, Repeatable Read, and Serializable—highlighting their effects on performance and data consistency.

MySQLconcurrency controldatabases
0 likes · 10 min read
Understanding Database Transaction Isolation and Locking Protocols