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