BestHub
Sign in
Tagged articles

Read Committed

8 articles · Page 1 of 1
liandk
liandk
Sep 6, 2026 · Databases

MySQL Transaction Isolation Levels & Lock Mechanisms: Dirty Reads, Phantom Reads, Deadlocks Explained

This comprehensive guide explains MySQL transaction isolation levels (Read Uncommitted, Read Committed, Repeatable Read, Serializable) and lock mechanisms (table, row, gap, next-key locks), demonstrating how dirty reads, non-repeatable reads, and phantom reads occur, with practical deadlock prevention strategies and enterprise-level isolation level selection guidelines.

ACIDDeadlockGap Lock
0 likes · 12 min read
MySQL Transaction Isolation Levels & Lock Mechanisms: Dirty Reads, Phantom Reads, Deadlocks Explained
ITPUB
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.

Isolation LevelMySQLRead Committed
0 likes · 8 min read
Why Some Companies Switch MySQL from Repeatable Read to Read Committed
Pan Zhi's Tech Notes
Pan Zhi's Tech Notes
Feb 8, 2025 · Databases

How to Choose the Right Database Transaction Isolation Level

This article explains MySQL’s transaction isolation mechanisms, compares the four isolation levels with concrete examples, shows how they affect phenomena like dirty reads, non‑repeatable reads and phantom reads, and provides practical guidance on configuring and avoiding long transactions.

MVCCMySQLRead Committed
0 likes · 15 min read
How to Choose the Right Database Transaction Isolation Level
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Nov 21, 2023 · Databases

Demonstrating MySQL Transaction Isolation Levels with Practical Examples

This article explains MySQL's four transaction isolation levels—READ UNCOMMITTED, READ COMMITTED, REPEATABLE READ, and SERIALIZABLE—by creating a simple table, inserting test data, and running step‑by‑step SQL scripts that illustrate the behavior of each level, including phenomena such as dirty reads, non‑repeatable reads, phantom reads, and locking.

InnoDBMySQLREAD UNCOMMITTED
0 likes · 11 min read
Demonstrating MySQL Transaction Isolation Levels with Practical Examples