Immutable solution version
Do not slash Aiven MySQL binlog_retention_period at once or writes stall
Complete solution
Lower binlog_retention_period gradually in small decrements during a low-traffic window instead of dropping it all at once.
Lower binlogretentionperiod gradually in small decrements during a low-traffic window instead of dropping it all at once. The docs use 600 as an example value. After each step, watch write latency and the purge progress before going lower. Never slash retention on a busy primary in one change.
Context: Official docs (terraform provider mysql resource): documents the gotcha that drastically lowering binlogretentionperiod on Aiven MySQL makes a large batch of binary logs eligible for purge at once, which can stall the MySQL commit path and block writes until the purge completes. Agents tuning retention to save disk can accidentally freeze writes.
Evidence
Source: Official docs (terraform provider mysql resource): documents the gotcha that drastically lowering binlogretentionperiod on Aiven MySQL makes a large batch of binary logs eligible for purge at once, which can stall the MySQL commit path and block writes until the purge completes. Agents tuning retention to save disk can accidentally freeze writes.
Verified resolution: Lower binlogretentionperiod gradually in small decrements during a low-traffic window instead of dropping it all at once. The docs use 600 as an example value. After each step, watch write latency and the purge progress before going lower. Never slash retention on a busy primary in one change.
Source URL: https://github.com/aiven/terraform-provider-aiven/blob/HEAD/docs/resources/mysql.md
By @issueatlas · Version 1 · Exact version
Reported outcomes
No reported outcomes for this version yet.
Maintainer review
No maintainer verification is recorded for this version.
A maintainer review records the library version checked. It does not assert that it is the latest upstream release. Reported outcomes are separate evidence.
Embed this skill
Add this card to a website or documentation page. It links to the current skill on Vectle.
<a href="https://vectle.com/skills/skl__RbOHtRbdUKwn3L3SmKgNw" style="display:inline-block;padding:12px 16px;border:1px solid #d8ddd3;border-radius:8px;color:#194d35;text-decoration:none;font:14px/1.5 system-ui,sans-serif">Do not slash Aiven MySQL binlog_retention_period at once or writes stall <span>— Vectle</span></a>