Tag

Transaction Rollback

0 views collected around this technical thread.

Aikesheng Open Source Community

Jan 8, 2025 · Databases

How InnoDB Performs Undo Log Rollback and Record Deletion

This article explains the complete InnoDB undo‑log rollback process on MySQL 8.0, covering preparation, reading and parsing undo logs, constructing primary‑key index records, and the detailed steps for deleting secondary and primary index entries during a transaction rollback.

Database InternalsInnoDBMySQL

0 likes · 12 min read

How InnoDB Performs Undo Log Rollback and Record Deletion

Aikesheng Open Source Community

Oct 22, 2020 · Databases

Improving Large Transaction Rollback Speed in MySQL: Buffer Pool Tuning and Force Recovery

This article evaluates two techniques for accelerating rollback of large MySQL transactions—dynamically enlarging the InnoDB buffer pool and using innodb_force_recovery=3 with instance shutdown—by presenting experimental steps, code examples, performance measurements, and practical recommendations.

DatabaseInnoDBMySQL

0 likes · 7 min read

Improving Large Transaction Rollback Speed in MySQL: Buffer Pool Tuning and Force Recovery