Database Concurrency

Full-Stack Internet Architecture

Jun 11, 2025 · Databases

Understanding MySQL Transaction Isolation Levels with Real‑World Examples

This article explains MySQL's four transaction isolation levels—READ UNCOMMITTED, READ COMMITTED, REPEATABLE READ, and SERIALIZABLE—through step‑by‑step examples, demonstrating their effects on dirty reads, non‑repeatable reads, phantom reads, and performance considerations, helping developers choose the appropriate level.

Database ConcurrencyInnoDBMySQL

0 likes · 10 min read

Understanding MySQL Transaction Isolation Levels with Real‑World Examples

Selected Java Interview Questions

Dec 11, 2024 · Databases

Understanding MySQL InnoDB MVCC: Concepts, Isolation Levels, and Code Implementation

This article explains MySQL InnoDB's multi-version concurrency control (MVCC), covering its basic concepts, hidden columns, isolation levels, the creation and evaluation of Read Views, and includes detailed source code examples and step‑by‑step experiments to illustrate transaction visibility.

Database ConcurrencyInnoDBMVCC

0 likes · 18 min read

Understanding MySQL InnoDB MVCC: Concepts, Isolation Levels, and Code Implementation

Aikesheng Open Source Community

Aug 14, 2024 · Databases

Granting Table Locks and Row Locks in InnoDB

This article explains how InnoDB in MySQL 8.0.32 grants table and row locks, detailing the active versus passive acquisition, the lock‑granting algorithms for tables and rows, and the priority, weight, and FIFO rules that determine lock ordering and deadlock handling.

Database ConcurrencyInnoDBMySQL

0 likes · 11 min read

Granting Table Locks and Row Locks in InnoDB

Architect's Guide

Apr 20, 2024 · Databases

Why Transaction Isolation Is Needed and an Overview of MySQL Isolation Levels

The article explains why transaction isolation is essential in databases, describes common concurrency problems such as lost updates, dirty reads, non‑repeatable reads, and phantom reads, and outlines MySQL's four isolation levels with their effects and trade‑offs.

ACIDDatabase ConcurrencyIsolation Levels

0 likes · 8 min read

Why Transaction Isolation Is Needed and an Overview of MySQL Isolation Levels

Architecture & Thinking

Apr 16, 2024 · Databases

Master MySQL InnoDB Locks: How SELECT…FOR UPDATE Behaves

This article explains the default repeatable‑read isolation level in InnoDB, details the three main lock types—record, gap, and next‑key—and shows how SELECT … FOR UPDATE applies different locking rules depending on primary key, unique, ordinary, range, or table‑scan queries, with practical SQL examples.

Database ConcurrencyInnoDBMySQL

0 likes · 10 min read

Master MySQL InnoDB Locks: How SELECT…FOR UPDATE Behaves

Architecture & Thinking

Nov 17, 2023 · Databases

Mastering MySQL Transactions: ACID, Isolation Levels, and Common Pitfalls

This article explains MySQL transaction fundamentals, the necessity of ACID properties, details the four isolation levels and their impact on phenomena like dirty reads, non‑repeatable reads, and phantom reads, and provides practical SQL examples and strategies for ensuring data consistency in high‑concurrency environments.

ACIDDatabase ConcurrencyInnoDB

0 likes · 15 min read

Mastering MySQL Transactions: ACID, Isolation Levels, and Common Pitfalls

IT Services Circle

Aug 20, 2023 · Databases

Understanding MySQL Transaction Isolation Levels and Their Practical Implications

This article explains MySQL's four transaction isolation levels—READ UNCOMMITTED, READ COMMITTED, REPEATABLE READ, and SERIALIZABLE—detailing their definitions, associated phenomena such as dirty reads, non‑repeatable reads, and phantom reads, and demonstrates how to query and set isolation levels with practical SQL examples.

Database ConcurrencyDirty ReadMySQL

0 likes · 12 min read

Understanding MySQL Transaction Isolation Levels and Their Practical Implications

Selected Java Interview Questions

Feb 3, 2023 · Databases

Understanding MySQL Transactions: Concepts, Isolation Levels, MVCC, and Implementation Details

This article explains MySQL transaction fundamentals, including the ACID properties, isolation levels, MVCC mechanics, transaction start methods, and practical examples that illustrate how different isolation levels affect data visibility and consistency.

Database ConcurrencyInnoDBIsolation Levels

0 likes · 20 min read

Understanding MySQL Transactions: Concepts, Isolation Levels, MVCC, and Implementation Details

Wukong Talks Architecture

Jul 21, 2022 · Databases

Understanding MySQL MVCC Mechanism

This article explains MySQL's multi-version concurrency control (MVCC), describing how version chains, undo logs, and ReadView work together to implement isolation levels, prevent dirty reads, non‑repeatable reads, and phantom reads, and how RC and RR isolation differ in practice.

Database ConcurrencyIsolation LevelsMVCC

0 likes · 8 min read

政采云技术

May 10, 2022 · Databases

Understanding MySQL InnoDB Locks, Latches, and Intention Locks with Source‑Code Analysis

This article explains MySQL 8.0.17 InnoDB locking mechanisms—including latches, row and table locks, lock modes, intention locks, their compatibility matrix, and detailed source‑code examples that illustrate how IX and X locks are acquired during record updates.

Database ConcurrencyInnoDBIntention Locks

0 likes · 13 min read

Understanding MySQL InnoDB Locks, Latches, and Intention Locks with Source‑Code Analysis

vivo Internet Technology

Jul 21, 2021 · Backend Development

Resolving Duplicate OpenID Insertions in Fast App Center: Analysis and Distributed Lock Solutions

The Fast App Center’s duplicate OpenID rows were traced to a non‑atomic check‑then‑insert race condition, prompting the team to evaluate a unique‑index safeguard versus application‑level distributed locking, ultimately implementing a Redis‑based lock to serialize inserts and adding a cleanup job to purge existing duplicates.

Backend DevelopmentDatabase ConcurrencyDistributed Lock

0 likes · 18 min read

Resolving Duplicate OpenID Insertions in Fast App Center: Analysis and Distributed Lock Solutions

Xiaolei Talks DB

Jul 21, 2021 · Databases

Optimistic vs Pessimistic Transactions in TiDB: 10x Performance Boost

This article compares TiDB's optimistic and pessimistic transaction models through a real‑world high‑concurrency write‑conflict scenario, showing how pessimistic locking can achieve over ten times higher throughput than optimistic retries.

Database ConcurrencyOptimistic TransactionPessimistic Transaction

0 likes · 14 min read

Optimistic vs Pessimistic Transactions in TiDB: 10x Performance Boost

Laravel Tech Community

Jul 8, 2021 · Databases

Understanding Optimistic and Pessimistic Locks in MySQL/InnoDB

This article explains the concepts, mechanisms, and practical code examples of optimistic and pessimistic locking in MySQL/InnoDB, including version‑based optimistic locks, shared (read) locks, exclusive (write) locks, and how to apply them with Laravel's query builder.

Database ConcurrencyLaravelMySQL

0 likes · 6 min read

Understanding Optimistic and Pessimistic Locks in MySQL/InnoDB

Architecture Digest

Apr 24, 2020 · Databases

Detailed Explanation of MySQL InnoDB Lock Mechanisms

This article provides a comprehensive overview of MySQL InnoDB locking, covering shared/exclusive locks, intention locks, record locks, gap locks, next‑key locks, insert‑intention locks, and auto‑increment locks, with examples, compatibility tables, and practical SQL snippets to illustrate each mechanism.

Database ConcurrencyInnoDBLocks

0 likes · 12 min read

Detailed Explanation of MySQL InnoDB Lock Mechanisms

NetEase Game Operations Platform

Oct 12, 2019 · Databases

Understanding MySQL 8.0.1 NOWAIT and SKIP LOCKED Features for Reducing Lock Wait

This article explains the new NOWAIT and SKIP LOCKED keywords introduced in MySQL 8.0.1, describes their background, functionality, and internal implementation, and demonstrates their practical impact on lock‑wait scenarios through a fictional flash‑sale case study with code examples.

Database ConcurrencyInnoDBMySQL

0 likes · 9 min read

Understanding MySQL 8.0.1 NOWAIT and SKIP LOCKED Features for Reducing Lock Wait

Efficient Ops

May 29, 2019 · Databases

Understanding MySQL Locks: From Table Locks to InnoDB Row Locks

This article explains MySQL's lock mechanisms, comparing MyISAM's table‑level locks with InnoDB's row‑level locks, covering lock types, compatibility, transaction isolation levels, deadlock scenarios, and practical tips to avoid lock contention and improve database concurrency.

Database ConcurrencyInnoDBLocks

0 likes · 22 min read

Understanding MySQL Locks: From Table Locks to InnoDB Row Locks

Java Captain

Nov 7, 2018 · Databases

Using Pessimistic and Optimistic Locks to Prevent Over‑Issuance in a Red‑Packet System

This article explains how to use pessimistic (FOR UPDATE) and optimistic (version field) database locks in a Java SSM red‑packet application to prevent over‑issuance, details implementation steps, code changes, performance testing, and the trade‑offs between lock types.

Database ConcurrencyJavaMyBatis

0 likes · 11 min read

Using Pessimistic and Optimistic Locks to Prevent Over‑Issuance in a Red‑Packet System

Mike Chen's Internet Architecture

Sep 15, 2018 · Databases

Overview of MySQL Locks: Types, Characteristics, and Usage Scenarios

This article explains MySQL's lock mechanisms, covering table‑level, row‑level, and page locks, the differences between pessimistic and optimistic locking, shared locks, and provides guidance on when to choose table locks versus row locks in various application scenarios.

Database ConcurrencyLocksMySQL

0 likes · 7 min read

Overview of MySQL Locks: Types, Characteristics, and Usage Scenarios