Innodb_log_file_size => innodb_redo_log_capacity
General
Escalation
General
Escalation
Description
Environment
None
Activity
Show:
Details
Details
Assignee
Unassigned
UnassignedReporter

Priority
Needs QA
Yes
Smart Checklist
Open Smart Checklist
Smart Checklist

Open Smart Checklist
Created February 17, 2025 at 2:56 PM
Updated February 17, 2025 at 2:56 PM
In
pt-variable-advisor
:innodb_log_file_size
is deprecated, and this is what we should use now:innodb_redo_log_capacity = ...
However, the warning still appears, because I'm not setting
innodb_log_file_size
.I believe this should be updated.
And it can probably suggest that the formula should be (25% of buffer pool size) * innodb_log_files_in_group (default/recommended = 2)
(if you agree, of course)
Thanks!!