BestHub
Sign in
Tag

database transactions

1 views collected around this technical thread.

Full-Stack Internet Architecture
Full-Stack Internet Architecture
Nov 27, 2024 · Databases

Understanding MySQL Database Transactions: ACID Properties, Control Statements, and Isolation Levels

This article explains the concept and importance of MySQL database transactions, describes the ACID properties, shows how to use transaction control statements and savepoints, and demonstrates each isolation level (read uncommitted, read committed, repeatable read, serializable) with practical SQL examples.

ACIDIsolation LevelsMySQL
0 likes · 10 min read
Understanding MySQL Database Transactions: ACID Properties, Control Statements, and Isolation Levels
Architect's Tech Stack
Architect's Tech Stack
May 17, 2024 · Databases

Understanding MySQL SELECT ... FOR UPDATE Locking: Row vs. Table Locks

This article explains how MySQL's SELECT ... FOR UPDATE statement acquires either row-level or table-level locks depending on the presence of indexes or primary keys, and demonstrates the behavior with multiple transaction examples and a sample table definition.

IndexesMySQLRow Lock
0 likes · 4 min read
Understanding MySQL SELECT ... FOR UPDATE Locking: Row vs. Table Locks
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Oct 28, 2023 · Databases

Understanding Database Transactions and MySQL Transaction Control

This article explains the concept of database transactions, the ACID properties, how MySQL implements transactions with InnoDB, how to manage autocommit, the essential transaction control statements, a practical example using savepoints, and the four isolation levels supported by MySQL.

ACIDIsolation LevelsMySQL
0 likes · 7 min read
Understanding Database Transactions and MySQL Transaction Control
Laravel Tech Community
Laravel Tech Community
Jun 22, 2022 · Databases

Understanding MySQL SELECT ... FOR UPDATE: When It Locks Rows vs. Tables

This article explains how a plain SELECT does not lock data, while SELECT … FOR UPDATE adds a pessimistic lock whose scope—row or table—depends on whether the query uses an indexed or primary‑key column, and demonstrates the behavior with SQL examples and transaction scenarios.

MySQLRow LockSELECT FOR UPDATE
0 likes · 4 min read
Understanding MySQL SELECT ... FOR UPDATE: When It Locks Rows vs. Tables
High Availability Architecture
High Availability Architecture
Sep 20, 2019 · Backend Development

Ensuring Idempotency and Preventing Double Payments in a Distributed Payments System

The article explains how Airbnb’s payment platform uses a generic idempotency library called Orpheus, combined with Java lambda‑driven transaction composition, to guarantee data consistency, avoid double charges, and handle retries in a low‑latency micro‑service architecture.

IdempotencyJavadatabase transactions
0 likes · 19 min read
Ensuring Idempotency and Preventing Double Payments in a Distributed Payments System
AntTech
AntTech
Aug 7, 2018 · Databases

A Timeline Review of Optimistic Concurrency Control (OCC) from Theory to Production Systems

This article presents a chronological overview of Optimistic Concurrency Control (OCC), covering its early theoretical foundations, key research papers, prototype implementations such as MVCC+OCC+2PC and Hekaton, and its adoption in modern distributed NewSQL databases like Megastore, F1, and MaaT, highlighting both advantages and challenges.

NewSQLOCCOptimistic Concurrency Control
0 likes · 33 min read
A Timeline Review of Optimistic Concurrency Control (OCC) from Theory to Production Systems