BestHub
Sign in
Tag

Lost Update

1 views collected around this technical thread.

Cognitive Technology Team
Cognitive Technology Team
Feb 2, 2024 · Databases

Read and Write Anomalies in Concurrent Transactions and Their Mitigation Strategies

This article explains the various read and write anomalies that can occur during concurrent database transactions—such as dirty reads, nonrepeatable reads, phantom reads, lost updates, dirty writes, and write skew—and outlines isolation levels and practical techniques like MVCC, atomic updates, explicit locking, and compare‑and‑set to prevent them.

ConcurrencyInnoDBLost Update
0 likes · 7 min read
Read and Write Anomalies in Concurrent Transactions and Their Mitigation Strategies
Top Architect
Top Architect
Oct 13, 2022 · Databases

Understanding Transaction Isolation Levels and Concurrency Issues in MySQL

The article explains why transaction isolation is needed, describes common concurrency problems such as lost updates, dirty reads, non‑repeatable reads and phantom reads, outlines the ACID properties of a transaction, and details MySQL's four isolation levels with their effects and default settings.

ACIDConcurrencyDatabase
0 likes · 8 min read
Understanding Transaction Isolation Levels and Concurrency Issues in MySQL