Tagged articles

isolation-level

31 articles · Page 1 of 1

Apr 18, 2026 · Backend Development

Beyond @Transactional: Build a Java Ticket System, Master Deadlocks & Isolation Levels

The article shows why a simple @Transactional approach fails under 300,000 concurrent users, explains MVCC behavior, demonstrates how to use row‑level pessimistic locks, sorting, FOR NO KEY UPDATE, short transactions, optimistic locking, and proper isolation levels, and outlines a production‑ready architecture with read/write splitting, Redis rate limiting and connection‑pool tuning.

DeadlockJavaSpring Boot

0 likes · 10 min read

Beyond @Transactional: Build a Java Ticket System, Master Deadlocks & Isolation Levels

ITPUB

Nov 11, 2025 · Databases

Why Big Tech Switches MySQL Isolation from RR to RC – Benefits & Risks

This article explains the differences between MySQL's RR and RC isolation levels, details master‑slave replication and binlog formats, shows why RR is the default, and why many internet companies now prefer RC for higher concurrency despite its phantom‑read trade‑offs.

BinlogDatabase Performanceconcurrency

0 likes · 10 min read

Why Big Tech Switches MySQL Isolation from RR to RC – Benefits & Risks

Instant Consumer Technology Team

Oct 21, 2025 · Databases

Why MySQL Inserts Can Deadlock: Deep Dive into Locks and Isolation Levels

This article examines how MySQL's lock mechanisms and transaction isolation levels can cause deadlocks during high‑concurrency inserts, presents a real‑world case study, walks through log analysis and testing, and offers practical strategies to diagnose, prevent, and resolve such deadlocks.

DeadlockInnoDBLocking

0 likes · 19 min read

Why MySQL Inserts Can Deadlock: Deep Dive into Locks and Isolation Levels

ITPUB

Oct 17, 2025 · Databases

Why Some Companies Switch MySQL from Repeatable Read to Read Committed

The article explains MySQL's default Repeatable Read isolation level, how its lock and binlog mechanisms affect consistency and replication, and why many high‑traffic internet firms change to Read Committed to boost concurrency and reduce deadlocks despite the need to handle phantom reads.

LockingREPEATABLE READRead Committed

0 likes · 8 min read

Why Some Companies Switch MySQL from Repeatable Read to Read Committed

dbaplus Community

Aug 24, 2025 · Databases

Why Big Tech Chooses RC Over MySQL’s Default RR Isolation Level

This article explains the differences between MySQL’s default REPEATABLE READ (RR) and READ COMMITTED (RC) isolation levels, why large internet firms switch to RC, the mechanics of master‑slave replication, the three binlog formats, and how gap locks affect consistency and performance.

BinlogRCRR

0 likes · 10 min read

Why Big Tech Chooses RC Over MySQL’s Default RR Isolation Level

Java Captain

May 25, 2025 · Databases

Database Transactions: ACID Properties, Isolation Levels, and Usage in MySQL

This article provides a comprehensive overview of database transactions, explaining ACID properties, transaction states, explicit and implicit transaction control, isolation levels, and how to configure and use them in MySQL with practical SQL examples and code snippets.

ACIDTransactiondatabase

0 likes · 22 min read

Database Transactions: ACID Properties, Isolation Levels, and Usage in MySQL

Su San Talks Tech

Dec 18, 2023 · Databases

Master MySQL Transactions: ACID, Isolation Levels, and MVCC Explained

This comprehensive guide explores MySQL transaction fundamentals, the ACID properties, various isolation levels, concurrency issues like dirty, non‑repeatable, and phantom reads, and dives deep into MVCC implementation, hidden fields, undo logs, and read views to help developers write reliable, consistent database code.

ACIDMVCCTransaction

0 likes · 24 min read

Master MySQL Transactions: ACID, Isolation Levels, and MVCC Explained

JD Retail Technology

Sep 21, 2023 · Databases

Analysis of InnoDB Deadlock in Pre‑Production Inventory Updates and Locking Mechanisms

The article examines a MySQL InnoDB deadlock that occurs when concurrent inventory‑write transactions in a pre‑release environment contend for row and gap locks, explains InnoDB lock types, isolation‑level effects, and proposes solutions such as distributed locks and isolation level adjustments.

DeadlockInnoDBisolation-level

0 likes · 13 min read

Analysis of InnoDB Deadlock in Pre‑Production Inventory Updates and Locking Mechanisms

政采云技术

Feb 21, 2023 · Databases

Understanding Next-Key Lock Deadlocks in MySQL and How to Avoid Them

This article examines how common business operations using SELECT ... FOR UPDATE and INSERT can cause Next‑Key lock deadlocks in MySQL under repeatable‑read isolation, demonstrates the locking behavior with practical SQL examples, and proposes strategies such as post‑locking and primary‑key updates to prevent such deadlocks.

DeadlockNext-Key LockSQL

0 likes · 14 min read

Understanding Next-Key Lock Deadlocks in MySQL and How to Avoid Them

ITPUB

Feb 17, 2023 · Databases

Master MySQL Locking: From Row Locks to Deadlocks and How to Prevent Them

This article explains why MySQL needs locking, details every InnoDB lock type—including shared, exclusive, intention, record, gap, next‑key, insert‑intention and auto‑increment locks—shows how they interact, and provides practical guidance for avoiding deadlocks and safely updating rows.

DeadlockInnoDBLocking

0 likes · 22 min read

Master MySQL Locking: From Row Locks to Deadlocks and How to Prevent Them

Architects Research Society

Jan 8, 2022 · Databases

Understanding Database Isolation Levels and Dirty Reads

This article explains database isolation levels, including read committed, repeatable read, serializable, and snapshot isolation, discusses dirty reads, phantom reads, and how various systems such as SQL Server, PostgreSQL, MySQL, Oracle, MongoDB, and others implement or differ in these isolation semantics.

SQLTransactiondatabase

0 likes · 19 min read

Understanding Database Isolation Levels and Dirty Reads

Full-Stack Internet Architecture

Oct 9, 2021 · Databases

Understanding MySQL Transaction Internals: MVCC, Isolation Levels, and Concurrency Control

This article explains how MySQL handles concurrent transactions using MVCC, lock mechanisms, and various isolation levels, detailing dirty writes, dirty reads, non‑repeatable reads, phantom reads, and the internal structures such as ReadView that enable reliable data consistency.

MVCCTransactiondatabase

0 likes · 16 min read

Understanding MySQL Transaction Internals: MVCC, Isolation Levels, and Concurrency Control

Aikesheng Open Source Community

Aug 20, 2021 · Databases

Understanding Phantom Reads and Isolation Levels in ANSI SQL and MySQL

This article explains the concept of phantom reads, distinguishes them from non‑repeatable reads, critiques the ANSI SQL isolation‑level definitions, and shows how MySQL implements repeatable‑read using locks and MVCC to prevent both strict and loosely defined phantom anomalies.

ANSI SQLLockingREPEATABLE READ

0 likes · 14 min read

Understanding Phantom Reads and Isolation Levels in ANSI SQL and MySQL

Full-Stack Internet Architecture

Jun 16, 2021 · Databases

Why MySQL Uses Repeatable Read as Its Default Isolation Level While Oracle Defaults to Read Committed

This article explains why MySQL chooses Repeatable Read as its default transaction isolation level, contrasting it with Oracle’s default Read Committed, and discusses how binlog formats, GAP locks, and historical bugs influence this design decision.

BinlogREPEATABLE READRead Committed

0 likes · 9 min read

Why MySQL Uses Repeatable Read as Its Default Isolation Level While Oracle Defaults to Read Committed

Full-Stack Internet Architecture

Jun 2, 2021 · Databases

Understanding Database Transaction Isolation Levels and MySQL Experiments

This article explains the concept of database transactions, the ACID properties, MySQL's four isolation levels, the phenomena they cause such as dirty reads, non‑repeatable reads and phantom reads, and provides step‑by‑step experiments demonstrating each isolation level in practice.

ACIDSQLTransaction

0 likes · 10 min read

Understanding Database Transaction Isolation Levels and MySQL Experiments

Code Ape Tech Column

Dec 31, 2020 · Databases

Understanding MySQL Transactions: Isolation Levels, MVCC, and Best Practices

This article explains MySQL transaction fundamentals, covering ACID concepts, isolation levels, MVCC implementation, transaction start methods, and practical examples that illustrate how InnoDB ensures atomicity, consistency, isolation, and durability while avoiding common pitfalls such as dirty reads and long‑running transactions.

InnoDBMVCCTransaction

0 likes · 23 min read

Understanding MySQL Transactions: Isolation Levels, MVCC, and Best Practices

Full-Stack Internet Architecture

Nov 27, 2020 · Backend Development

Understanding Transaction Isolation Levels and Propagation Behaviors in Spring

This article explains how to configure Spring transaction isolation levels and propagation behaviors, illustrates the effects of dirty read, non‑repeatable read, and phantom read with examples, and provides practical code solutions for handling rollback of failed sub‑tasks and self‑invocation issues.

JavaSpringTransaction

0 likes · 9 min read

Understanding Transaction Isolation Levels and Propagation Behaviors in Spring

Selected Java Interview Questions

Sep 27, 2020 · Databases

Understanding How MySQL InnoDB Solves Phantom Reads

This article explains the four transaction isolation levels, defines phantom reads, and details how MySQL's InnoDB engine uses MVCC snapshot reads and next‑key locking (including the next‑key principle and lock composition) to prevent phantom reads under the REPEATABLE READ isolation level.

InnoDBMVCCNext-Key Lock

0 likes · 2 min read

Understanding How MySQL InnoDB Solves Phantom Reads

Programmer DD

Sep 21, 2020 · Databases

How MySQL Prevents Phantom Reads: MVCC and Next‑Key Locks Explained

This article explains why phantom reads occur under MySQL's REPEATABLE READ isolation, how InnoDB uses MVCC for snapshot reads and next‑key locks for current reads, and demonstrates the mechanisms with code examples and version‑tracking diagrams.

MVCCNext-Key Lockdatabase

0 likes · 7 min read

How MySQL Prevents Phantom Reads: MVCC and Next‑Key Locks Explained

JavaEdge

Jul 15, 2020 · Databases

Understanding MySQL Transaction Isolation Levels and Best Practices

This article explains MySQL transaction isolation concepts, the four standard isolation levels, their effects on dirty, non‑repeatable, and phantom reads, practical configuration steps, when to use repeatable read, how InnoDB implements isolation, and tips for avoiding long transactions and planning backups.

InnoDBSQLTransaction

0 likes · 8 min read

Understanding MySQL Transaction Isolation Levels and Best Practices

Programmer DD

Jul 10, 2020 · Backend Development

Mastering Spring Boot Transactions: From Basics to Advanced Settings

This article explains what database transactions are, demonstrates how to use Spring Boot’s @Transactional annotation with unit tests, and dives into transaction isolation levels and propagation behaviors, providing code examples and guidance for effective transaction management in Java backend applications.

JavaSpring BootTransaction Management

0 likes · 13 min read

Mastering Spring Boot Transactions: From Basics to Advanced Settings

Architects Research Society

Jun 2, 2020 · Databases

Understanding Database Isolation Levels and Dirty Reads

This article explains the concepts of isolation levels, dirty reads, and phantom reads across various relational and NoSQL databases, describing how each system implements or lacks transaction isolation and the practical impact on data consistency and performance.

NoSQLSQLTransaction

0 likes · 17 min read

Programmer DD

Oct 11, 2019 · Databases

Understanding MySQL Transaction Isolation Levels: ACID, Tests, and Practical Guide

This article explains the concept of database transactions, the ACID properties, details MySQL’s four isolation levels—Read Uncommitted, Read Committed, Repeatable Read, and Serializable—and provides step‑by‑step command‑line experiments demonstrating phenomena such as dirty reads, non‑repeatable reads, phantom reads, and serialization effects.

ACIDSQLTransaction

0 likes · 9 min read

Understanding MySQL Transaction Isolation Levels: ACID, Tests, and Practical Guide

Aikesheng Open Source Community

Feb 28, 2019 · Databases

Performance Analysis of DBLE vs MyCat: Identifying Sorting and Isolation Level Issues

A detailed case study investigates why DBLE middleware achieves only about 70% of MyCat's performance, revealing that excessive sorting CPU usage, a cmp‑function inefficiency, and a delete‑loop bug under REPEATABLE_READ isolation cause the slowdown, and demonstrates how adjusting isolation levels and fixing the cmp implementation restores expected performance.

DBLEisolation-levelsorting

0 likes · 10 min read

Performance Analysis of DBLE vs MyCat: Identifying Sorting and Isolation Level Issues

JD Tech

Feb 22, 2019 · Databases

Issues When Using Transactions with Database Read/Write Splitting

This article examines the challenges of using transactions with database read/write splitting, including potential master‑slave switching errors, connection‑pool deadlocks caused by isolation levels and propagation, and presents Spring‑based dynamic data source and transaction management solutions.

Dynamic Data SourceRead‑Write SplittingSpring

0 likes · 6 min read

Issues When Using Transactions with Database Read/Write Splitting

Hujiang Technology

Sep 18, 2017 · Databases

Understanding the NOLOCK Hint in SQL Server and Its MySQL Equivalent

This article explains what the NOLOCK hint does in SQL Server, why it is used, how it relates to transaction isolation levels, presents practical tests, discusses the relevance of NOLOCK after newer SQL Server versions, and shows why MySQL does not need an equivalent hint, offering guidance on when to apply it.

NOLOCKSQL Serverisolation-level

0 likes · 17 min read

Understanding the NOLOCK Hint in SQL Server and Its MySQL Equivalent

ITPUB

Mar 5, 2017 · Databases

Database Transactions Demystified: ACID, Isolation Levels & Spring Propagation

This article explains the fundamental ACID properties of database transactions, details the four isolation levels—READ_UNCOMMITTED, READ_COMMITTED, REPEATABLE_READ, SERIALIZABLE—illustrates common concurrency issues like dirty, non‑repeatable, and phantom reads with examples, and shows how Spring’s transaction propagation and additional features can be leveraged to manage them effectively.

ACIDSpringdatabase

0 likes · 12 min read

Database Transactions Demystified: ACID, Isolation Levels & Spring Propagation

Java Backend Technology

Oct 24, 2016 · Databases

Understanding Database Isolation Levels and ACID Properties

This article explains the four MySQL isolation levels, their effects such as dirty reads, non‑repeatable reads and phantom reads, shows how to view and change the isolation level, and reviews the ACID principles of atomicity, consistency, isolation, and durability.

ACIDTransactionisolation-level

0 likes · 5 min read

Understanding Database Isolation Levels and ACID Properties

ITPUB

Oct 10, 2016 · Databases

Why MySQL Query Cache Slowed My Production Database and How We Fixed It

A production MySQL 5.5 instance suffered intermittent latency and bursts of slow queries, which were traced to an oversized enabled query cache that caused mutex contention during frequent DML operations, and disabling the cache resolved the issue.

Query CacheSlow Querydatabase optimization

0 likes · 6 min read

Why MySQL Query Cache Slowed My Production Database and How We Fixed It

Qunar Tech Salon

Jun 2, 2016 · Backend Development

Understanding Spring Declarative Transaction Propagation and Isolation Levels

This article explains Spring's declarative transaction mechanism, detailing transaction attributes such as propagation behavior, isolation levels, timeout and read‑only flags, and illustrates each propagation type with Java code examples to show how transactions are started, joined, suspended, or nested.

SpringTransaction Managementbackend

0 likes · 11 min read

Understanding Spring Declarative Transaction Propagation and Isolation Levels

21CTO

Apr 16, 2016 · Databases

How MySQL InnoDB Locks Work: From MVCC Basics to Deadlock Analysis

This article provides an in‑depth analysis of MySQL/InnoDB locking mechanisms, covering MVCC snapshot vs current reads, cluster indexes, two‑phase locking, isolation levels, lock behavior for simple and complex SQL statements, and practical deadlock diagnosis techniques.

Database ConcurrencyDeadlockInnoDB

0 likes · 26 min read

How MySQL InnoDB Locks Work: From MVCC Basics to Deadlock Analysis