Skip to content

Out of space in the redo log. Consider increasing innodb_redo_log_capacity. #403

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Open
kochetovd opened this issue May 5, 2025 · 0 comments

Comments

@kochetovd
Copy link
Collaborator

Also I see it recommending I change my innodb_redo_log_capacity to 8MB, which is very very low for my loads, I recently changed it to 4G, because of the 8MB Releem configuration change in a prior week (I believe the default is 100M) which caused an outage last Saturday when something failed with a process and a bunch of data had to be rolled back in the largest table we have

2025-05-01T05:37:40.905511Z 0 [ERROR] [MY-013059] [InnoDB] Out of space in the redo log. Checkpoint LSN: 161756683637. Consider increasing innodb_redo_log_capacity.
2025-05-01T05:37:45.905664Z 0 [ERROR] [MY-013059] [InnoDB] Out of space in the redo log. Checkpoint LSN: 161756683637. Consider increasing innodb_redo_log_capacity.
2025-05-01T05:37:50.905885Z 0 [ERROR] [MY-013059] [InnoDB] Out of space in the redo log. Checkpoint LSN: 161756683637. Consider increasing innodb_redo_log_capacity.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant