Posted inMySQL
Optimizing MySQL 8 Undo Tablespace: Controlling History List Length and Reclaiming Disk Space
A practical guide to dealing with MySQL 8 Undo Tablespace bloat caused by long-running transactions — from detecting high History List Length and configuring purge threads, to truncating undo tablespaces and reclaiming disk space in production.