BestHub
Sign in
Tag

Transaction Isolation

1 views collected around this technical thread.

Full-Stack Internet Architecture
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
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.

InnoDBMySQLTransaction Isolation
0 likes · 9 min read
Mastering MySQL Locks: Types, Mechanisms, and Best Practices
Cognitive Technology Team
Cognitive Technology Team
Apr 11, 2025 · Databases

Understanding MySQL Concurrency: Read/Write Conflicts, MVCC, and Locking Strategies

This article explains MySQL's three concurrency types—read‑read, read‑write, and write‑write—describes how InnoDB uses MVCC, shared and exclusive locks, and provides practical examples and code for handling update‑loss and write‑write conflicts with optimistic and pessimistic locking.

DatabaseMVCCMySQL
0 likes · 8 min read
Understanding MySQL Concurrency: Read/Write Conflicts, MVCC, and Locking Strategies
Top Architect
Top Architect
Jan 12, 2025 · Databases

Understanding MySQL Indexes, Execution Plans, Transaction Isolation, MVCC, and Buffer Pool

This comprehensive guide explains MySQL's underlying index structures (B‑tree, B+‑tree, hash), how execution plans are generated and interpreted, the mechanics of query execution, the role of locks and transaction isolation levels, the MVCC model, and the InnoDB buffer‑pool caching strategy.

Buffer PoolIndexesMVCC
0 likes · 19 min read
Understanding MySQL Indexes, Execution Plans, Transaction Isolation, MVCC, and Buffer Pool
Selected Java Interview Questions
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
Aikesheng Open Source Community
Nov 13, 2024 · Databases

InnoDB Locking Analysis for INSERT … ON DUPLICATE KEY under REPEATABLE‑READ and READ‑COMMITTED

This article examines how InnoDB acquires row‑level locks during INSERT … ON DUPLICATE KEY operations under REPEATABLE‑READ and READ‑COMMITTED isolation levels, explains the lock types on primary and unique indexes, and shows the rollback and lock‑conversion process with concrete SQL examples.

InnoDBMySQLRead Committed
0 likes · 11 min read
InnoDB Locking Analysis for INSERT … ON DUPLICATE KEY under REPEATABLE‑READ and READ‑COMMITTED
Aikesheng Open Source Community
Aikesheng Open Source Community
Oct 23, 2024 · Databases

Analyzing InnoDB Locking Behavior under REPEATABLE‑READ and READ‑COMMITTED Isolation Levels

This article demonstrates how InnoDB acquires and releases row‑level locks for a sample table under REPEATABLE‑READ and READ‑COMMITTED isolation levels, showing the SQL statements used, the lock types observed in the performance_schema, and the reasons behind the observed locking patterns.

InnoDBMySQLRead Committed
0 likes · 10 min read
Analyzing InnoDB Locking Behavior under REPEATABLE‑READ and READ‑COMMITTED Isolation Levels
Top Architect
Top Architect
Oct 12, 2024 · Databases

Understanding MySQL Index Structures, Execution Plans, Transaction Isolation Levels, MVCC, and Buffer Pool Mechanisms

This article provides a comprehensive technical guide on MySQL internals, covering the underlying data structures of indexes (B‑tree, B+‑tree, hash), how execution plans are generated and interpreted, the four transaction isolation levels, MVCC implementation, and the InnoDB buffer‑pool architecture.

Buffer PoolIndexingMVCC
0 likes · 22 min read
Understanding MySQL Index Structures, Execution Plans, Transaction Isolation Levels, MVCC, and Buffer Pool Mechanisms
Aikesheng Open Source Community
Aikesheng Open Source Community
Oct 9, 2024 · Databases

Understanding InnoDB Locking: Repeatable Read vs. Read Committed Isolation Levels

This article demonstrates how InnoDB acquires different types of row and gap locks under REPEATABLE-READ and READ-COMMITTED isolation levels by creating a test table, inserting data, setting transaction isolation, executing SELECT ... FOR SHARE statements, and inspecting lock information from performance_schema.

InnoDBMySQLRead Committed
0 likes · 9 min read
Understanding InnoDB Locking: Repeatable Read vs. Read Committed Isolation Levels
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 25, 2024 · Databases

Analysis of Lock Behavior under REPEATABLE-READ and READ-COMMITTED Isolation Levels

This tutorial demonstrates, using MySQL 8.0.32 InnoDB source code, how REPEATABLE-READ and READ-COMMITTED isolation levels affect the locking behavior of SELECT ... FOR SHARE statements on primary‑key rows, including preparation, execution, and detailed lock analysis.

InnoDBMySQLRead Committed
0 likes · 7 min read
Analysis of Lock Behavior under REPEATABLE-READ and READ-COMMITTED Isolation Levels
Architect
Architect
Sep 19, 2024 · Databases

Phantom Read Verification and Analysis in InnoDB REPEATABLE‑READ Isolation

This article investigates whether the REPEATABLE‑READ isolation level in InnoDB fully prevents phantom reads by conducting a series of current‑read and snapshot‑read experiments, analyzing transaction behavior, MVCC mechanisms, and offering recommendations to avoid phantom anomalies.

InnoDBMVCCMySQL
0 likes · 19 min read
Phantom Read Verification and Analysis in InnoDB REPEATABLE‑READ Isolation
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 18, 2024 · Databases

InnoDB Locking Behavior for Unique Index Conflicts under READ‑COMMITTED Isolation

This article examines how MySQL 8.0.32 InnoDB handles locking when inserting a row that violates a unique index under the READ‑COMMITTED isolation level, detailing the preparation steps, observed lock types, the underlying mechanism, and the final cleanup actions.

InnoDBMySQLRead Committed
0 likes · 8 min read
InnoDB Locking Behavior for Unique Index Conflicts under READ‑COMMITTED Isolation
Zhuanzhuan Tech
Zhuanzhuan Tech
Aug 30, 2024 · Databases

Investigating Phantom Reads in InnoDB REPEATABLE-READ Isolation Level: Experiments and Analysis

This article examines whether the REPEATABLE‑READ isolation level in InnoDB fully prevents phantom reads by conducting systematic current‑read and snapshot‑read experiments, analyzing lock mechanisms, MVCC behavior, and presenting detailed SQL scripts, results, and recommendations for avoiding phantom reads.

InnoDBMVCCMySQL
0 likes · 18 min read
Investigating Phantom Reads in InnoDB REPEATABLE-READ Isolation Level: Experiments and Analysis
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 27, 2024 · Databases

Understanding Repeatable Read in OceanBase Oracle Mode and the Correct JDBC Configuration

This article explains why the OBOracle "set transaction read only" command provides repeatable‑read semantics, evaluates the behavior of the JDBC conn.setReadOnly(true) setting, and shows how to achieve true repeatable‑read isolation by enabling the oracleChangeReadOnlyToRepeatableRead option in the OceanBase client.

DatabaseJDBCOceanBase
0 likes · 8 min read
Understanding Repeatable Read in OceanBase Oracle Mode and the Correct JDBC Configuration
Top Architect
Top Architect
Jul 10, 2024 · Databases

Understanding MySQL Index Structures, Execution Plans, Transactions, and MVCC

This article provides a comprehensive overview of MySQL internals, covering index data structures such as B‑tree and B+‑tree, the differences between MyISAM and InnoDB indexes, SQL execution plan analysis, transaction isolation levels, lock mechanisms, MVCC implementation, and the InnoDB buffer‑pool caching process.

Buffer PoolIndexesMVCC
0 likes · 19 min read
Understanding MySQL Index Structures, Execution Plans, Transactions, and MVCC
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 25, 2024 · Databases

Analyzing a BenchmarkSQL‑Induced Infinite Loop in MySQL under REPEATABLE‑READ Isolation

This article investigates why BenchmarkSQL stalls during MySQL performance testing, tracing the issue to REPEATABLE‑READ isolation causing a dead‑loop in delete‑select transactions, and demonstrates how switching to READ‑COMMITTED resolves the problem through detailed code inspection and experimental verification.

BenchmarkSQLMySQLRead Committed
0 likes · 8 min read
Analyzing a BenchmarkSQL‑Induced Infinite Loop in MySQL under REPEATABLE‑READ Isolation
Java Architect Essentials
Java Architect Essentials
May 30, 2024 · Databases

Beware of INSERT INTO SELECT: A MySQL Data Migration Incident and Lessons Learned

This article recounts a costly MySQL data‑migration failure caused by an unchecked INSERT INTO SELECT operation, analyzes why full‑table scans and transaction isolation led to payment‑record loss, and offers practical safeguards such as proper indexing and careful use of the statement.

INSERT INTO SELECTIndexingMySQL
0 likes · 7 min read
Beware of INSERT INTO SELECT: A MySQL Data Migration Incident and Lessons Learned
Top Architect
Top Architect
May 28, 2024 · Databases

Lessons Learned from Using INSERT INTO SELECT for MySQL Data Migration

This article recounts a real-world MySQL data migration incident where using INSERT INTO SELECT caused out‑of‑memory errors and data loss, analyzes why full table scans and transaction locking led to failures, and offers practical recommendations such as indexing and avoiding bulk inserts for large tables.

Full Table ScanINSERT INTO SELECTMySQL
0 likes · 8 min read
Lessons Learned from Using INSERT INTO SELECT for MySQL Data Migration