MySQL Transaction Isolation Testing
MySQL Transaction Testing
Configure MySQL transaction settings:
-- Check autocommit status (1=on, 0=off)
SELECT @@autocommit;
-- Disable autocommit
SET autocommit = 0;
Prepare test data:
CREATE DATABASE transaction_test;
USE transaction_test;
CREATE TABLE users(id INT PRIMARY KEY, name VARCHAR(10)) ENGINE=InnoDB;
INSERT INTO users VALUES(1 ...
Posted on Tue, 25 Aug 2026 16:13:41 +0000 by zbert
Timestamp Ordering for Concurrent Transaction Management
The previous lecture discussed Two-Phase Locking (2PL), a pessimistic concurrency control method. This lecture introduces Timestamp Ordering (T/O), an optimistic approach where transactions do not require explicit locking during data access.
The core concept of T/O uses timestamps to define a serial execution order for transactions: if TS(T_i) ...
Posted on Sun, 14 Jun 2026 17:35:33 +0000 by yuan22m