Tag

UndoLog

0 views collected around this technical thread.

Aikesheng Open Source Community

Dec 11, 2024 · Databases

Understanding InnoDB Rollback Segment Allocation for Temporary and Regular Tables in MySQL 8.0.32

This article examines MySQL 8.0.32 InnoDB's rollback segment memory layout and details the algorithms used to allocate rollback segments for user temporary tables and regular tables, including the role of system variables, counters, and the distribution matrix across undo tablespaces.

DatabaseInternalsInnoDBMySQL

0 likes · 9 min read

Understanding InnoDB Rollback Segment Allocation for Temporary and Regular Tables in MySQL 8.0.32

Aikesheng Open Source Community

Sep 9, 2024 · Databases

AI‑Assisted Diagnosis of Long‑Running Undo Log Cleanup Causing MySQL Backup Failure

The article describes a MySQL 8.0.18 backup failure caused by an undo log remaining in cleanup state for over ten hours, details the error logs, shows how the ChatDBA AI tool analyses and resolves the issue, compares it with ChatGPT‑4o, and provides related activity previews.

AIChatDBADatabaseTroubleshooting

0 likes · 5 min read

AI‑Assisted Diagnosis of Long‑Running Undo Log Cleanup Causing MySQL Backup Failure