Inside an InnoDB Update Transaction: From SQL Execution to Disk Persistence
Scenario Setup
Consider the following table and update operation for our analysis:
-- Table definition with clustered and secondary indexes
CREATE TABLE `products` (
`product_id` int NOT NULL AUTO_INCREMENT,
`sku` varchar(32) NOT NULL,
`quantity` int NOT NULL DEFAULT 0,
`cost` decimal(10,2) NOT NULL,
PRIMARY KEY (`product_id`),
UNIQ ...
Posted on Tue, 03 Nov 2026 16:48:16 +0000 by exasp