Tag: Transaction
16 articles
MySQL Transaction and Lock Mechanism: ACID Properties
ACID properties: atomicity, consistency, isolation, durability, WAL mechanism. This article provides in-depth analysis of principles and practical applications.
MySQL Undo/Redo Log: Transaction Rollback and Persistence
Undo Log for rollback, Redo Log for redo, transaction atomicity, durability, MVCC. This article provides in-depth analysis of principles and practical applications.
Distributed Services ACID: Three-Phase Commit 3PC vs 2PC
This article provides an in-depth analysis of the Three-Phase Commit protocol (3PC) and its differences from Two-Phase Commit (2PC) in distributed transaction processing.
Distributed Services ACID: Two-Phase Commit 2PC Protocol
This article provides an in-depth analysis of the Two-Phase Commit protocol (2PC) for distributed transactions, covering ACID properties and practical implementation.
Spring In-Depth: Declarative Transaction Support Transact...
In-depth guide to Spring declarative transaction support covering transaction configuration with XML mode and XML+annotation mode with practical examples.
Spring In-Depth: Declarative Transaction Support Transact...
In-depth introduction to Spring declarative transaction support covering transaction control, concepts, four characteristics, and isolation levels with practical examples.
Neo4j Transaction, Index and Constraint Practice: Syntax,...
Neo4j transaction handling, index creation, constraint settings and concurrency issue troubleshooting. This article deeply analyzes principles and practical applications.
MySQL Transactions: ACID Properties, Isolation Levels & U...
MySQL database transaction is a set of SQL operations executed as a single logical unit of work, following ACID principles: Atomicity, Consistency, Isolation and Durability.
MySQL Transaction Issues: Dirty Read, Non-Repeatable Read...
Common issues in database transactions include dirty read, non-repeatable read, and phantom read. These issues are closely related to database isolation levels.
Spring Boot Transaction Propagation: From REQUIRED to NESTED
Transaction propagation is an important mechanism in Spring for handling transaction boundaries, defining how methods interact with transaction context in the call chain.
Spring Boot Declarative vs Programmatic Transactions
Introduces declarative transaction and programmatic transaction concepts, usage methods and comparative analysis. Declarative transaction is implemented through @Transactional annotation, programma...
Spring Transaction Pitfalls Part 2: Common Issues & Solut...
Common Spring transaction pitfalls include non-public access modifiers, unsupported storage engines, incorrect readOnly configuration, transaction timeout too short, and incorrect propagation mecha...
Spring Boot @Transactional: Propagation, Isolation & Roll...
Detailed introduction to @Transactional annotation parameters in Spring Boot, including transaction propagation, isolation levels, and exception rollback strategies.
Spring Transaction Pitfalls Part 1: Common Issues & Solut...
Spring transaction pitfalls commonly occur in scenarios like classes not managed by Spring, transaction manager not started, improper method modifiers (final, static, private), and same-class inter...
Spring Transaction Pitfalls Part 3: Common Issues & Solut...
Spring transaction pitfalls include rollbackFor configuration errors, transaction annotation overrides, nested transaction issues and more.
Spring Transaction Pitfalls Part 4: Multi-threading & Exc...
Spring transaction pitfalls include multi-threaded calls, exception catching without rollback, manual exception throwing errors. In multi-threading scenarios, child threads cannot inherit parent th...