Innodb_log_file_size => innodb_redo_log_capacity

Description

In pt-variable-advisor:

WARN innodb_log_file_size: The InnoDB log file size is set to its default value, which is not usable on production systems.

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!!

Environment

None

Activity

Show:

Details

Assignee

Reporter

Priority

Needs QA

Yes

Smart Checklist

Created February 17, 2025 at 2:56 PM
Updated February 17, 2025 at 2:56 PM