BestHub
Sign in
Tagged articles
58 articles
Page 1 of 1
Big Data Technology Tribe
Big Data Technology Tribe
Feb 25, 2026 · Databases

How Lance Implements MVCC Transactions with Optimistic Concurrency and Automatic Conflict Resolution

Lance uses Multi-Version Concurrency Control to provide ACID guarantees, creating immutable table versions on each commit and employing atomic storage primitives, rebase logic, and retry mechanisms to handle concurrent writes, conflict detection, and resolution across multiple transaction types.

Concurrency ControlDatabase InternalsLance
0 likes · 16 min read
How Lance Implements MVCC Transactions with Optimistic Concurrency and Automatic Conflict Resolution
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.

Concurrency ControlInnoDBIsolation Levels
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.

Concurrency ControlSQLdatabases
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.

Concurrency ControlVersioningdatabase
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.

Concurrency ControlExpressVue
0 likes · 18 min read
Fast, Resumable Large File Uploads with Vue & Express
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.

Concurrency ControlFrontend OptimizationJavaScript
0 likes · 7 min read
How to Prevent Request Overload with a Simple Frontend Request Queue
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.

Concurrency ControlDatabase LocksInnoDB
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.

Concurrency ControlPHPReactPHP
0 likes · 5 min read
How to Rate‑Limit Asynchronous Tasks with ReactPHP‑MQ
Alibaba Cloud Big Data AI Platform
Alibaba Cloud Big Data AI Platform
Mar 13, 2025 · Databases

Master Hologres Query Queues: Boost Concurrency, Isolation & Fault Tolerance

This article explains Hologres 3.0's Query Queue feature, covering its motivation, architecture, four core capabilities—concurrency control, queueing, query isolation, and circuit breaking—along with practical usage scenarios, management steps, classifier rules, and best‑practice recommendations.

Concurrency ControlDatabase ManagementHologres
0 likes · 13 min read
Master Hologres Query Queues: Boost Concurrency, Isolation & Fault Tolerance
Alibaba Cloud Developer
Alibaba Cloud Developer
Oct 10, 2024 · Databases

Inside MySQL 8.0: How Table, Page, and Row Locks Manage Concurrency

This article provides a comprehensive overview of MySQL 8.0's concurrency control mechanisms, detailing table‑level MDL locks, server‑ and engine‑layer table locks, page‑level B+Tree locking, and row‑level lock types with code examples and real‑world deadlock scenarios.

Concurrency ControlDatabase InternalsInnoDB
0 likes · 28 min read
Inside MySQL 8.0: How Table, Page, and Row Locks Manage Concurrency
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 HudiBig DataConcurrency Control
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.

Concurrency ControlDatabase InternalsInnoDB
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.

Concurrency ControlPHPmysql
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.

Concurrency ControlInnoDBLocks
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.

Concurrency ControlDevOpsSoftware Testing
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.

ByteHouseClickHouseConcurrency Control
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.

ByteHouseClickHouseConcurrency Control
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.

CASConcurrency Controlatomic write
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 IcebergConcurrency Control
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.

Concurrency ControlInnoDBMVCC
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.

Concurrency ControlDatabase OptimizationMyBatis
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.

Concurrency Controlmysqloptimistic lock
0 likes · 6 min read
Understanding Optimistic and Pessimistic Locks in MySQL
Top Architect
Top Architect
Feb 26, 2022 · Backend Development

Design and Analysis of a Flash‑Sale System: Architecture, Request Flow, and Lock Strategies

This article analyzes the business scenario of flash‑sale (秒杀) systems, outlines their technical characteristics, dissects the request chain, compares optimistic and pessimistic locking mechanisms with code examples, and presents a comparative table of concurrency‑control outcomes.

Backend ArchitectureConcurrency Controlflash sale
0 likes · 8 min read
Design and Analysis of a Flash‑Sale System: Architecture, Request Flow, and Lock Strategies
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.

Concurrency ControlDistributed SystemsToken Bucket
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.

Concurrency ControlDatabase Locksmysql
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.

Concurrency ControlLinux toolTDSQL
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.

Backend DevelopmentConcurrency ControlEvent Processing
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.

Concurrency ControlInnoDBMVCC
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.

Concurrency ControlID segment allocationdatabase 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 ControlSystem Architecturemembership
0 likes · 17 min read
Design and Optimization of MaFengWo Membership System Architecture
ITPUB
ITPUB
Apr 25, 2019 · Databases

Pessimistic vs Optimistic Locks: Choosing the Right Concurrency Control for High‑Traffic Databases

This article explains the concepts of concurrency control, detailing pessimistic and optimistic locking mechanisms, their implementation in MySQL, practical SQL examples, advantages, drawbacks such as deadlocks and ABA problems, and guidance on selecting the appropriate lock strategy for high‑concurrency applications.

CASConcurrency ControlVersioning
0 likes · 11 min read
Pessimistic vs Optimistic Locks: Choosing the Right Concurrency Control for High‑Traffic Databases
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.

Concurrency ControlIsolationVersion 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.

Concurrency ControlDistributed SystemsMVCC
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.

Backend DevelopmentConcurrency ControlZooKeeper
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.

Concurrency ControlIsolation LevelsLocks
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.

Concurrency ControlMessage Queuecustom 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.

Concurrency ControlDatabase LocksDatabase Optimization
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.

Concurrency ControlDistributed Systemsdatabase
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.

Concurrency ControlDatabase TransactionsDistributed Systems
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.

Backend DevelopmentBatch ProcessingConcurrency Control
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.

Concurrency ControlDatabase PerformanceVersioning
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.

Concurrency Controldatabaseslocking protocols
0 likes · 10 min read
Understanding Database Transaction Isolation and Locking Protocols