Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

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

Aaditya Dubey 
May 27, 2025 at 11:44 AM
(edited)

Hi

Thank you for the report.

[vagrant@rocky8 ~]$ pt-variable-advisor --version pt-variable-advisor 3.7.0 [vagrant@rocky8 ~]$ pt-variable-advisor --user=root --password='XXXX' --host=localhost --port=3306 --source-of-variables=mysql Usage: pt-variable-advisor [OPTIONS] [DSN] Errors in command-line arguments: * A DSN must be specified when --source-of-variables=mysql pt-variable-advisor analyzes variables and advises on possible problems. For more details, please use the --help option, or try 'perldoc /usr/bin/pt-variable-advisor' for complete documentation. [vagrant@rocky8 ~]$ pt-variable-advisor --source-of-variables=mysql h=localhost,P=3306,u=root,p='Test123!' WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. # WARN delay_key_write: MyISAM index blocks are never flushed until necessary. # WARN innodb_buffer_pool_size: The InnoDB buffer pool size is unconfigured. # WARN innodb_log_file_size: The InnoDB log file size is set to its default value, which is not usable on production systems. ...

Technically, innodb-log-file-size is not deprecated; please check the note from upstream:
innodb_log_file_size and innodb_log_files_in_group have been superseded by innodb_redo_log_capacity; see Section 17.6.5, “Redo Log”.

However, I’m sending the request to our engineering team for further review and updates.

Details

Assignee

Reporter

Priority

Affects versions

Needs QA

Created February 17, 2025 at 2:56 PM
Updated May 27, 2025 at 11:51 AM

Flag notifications