Out of space in the redo log

Products

• CA API Gateway

Issue/Introduction

The gateway service stopped and needed to be rebooted to start running again. The following errors were in the /var/log/mysqld.log:

[ERROR] [MY-013059] [InnoDB] Out of space in the redo log. Checkpoint LSN: 3874492737773. Consider increasing innodb_redo_log_capacity.
[ERROR] [MY-013059] [InnoDB] Out of space in the redo log. Checkpoint LSN: 3874492737773. Consider increasing innodb_redo_log_capacity.
[ERROR] [MY-013059] [InnoDB] Out of space in the redo log. Checkpoint LSN: 3874492737773. Consider increasing innodb_redo_log_capacity.
[ERROR] [MY-013059] [InnoDB] Out of space in the redo log. Checkpoint LSN: 3874492737773. Consider increasing innodb_redo_log_capacity.
[ERROR] [MY-013059] [InnoDB] Out of space in the redo log. Checkpoint LSN: 3874492737773. Consider increasing innodb_redo_log_capacity.
[ERROR] [MY-013059] [InnoDB] Out of space in the redo log. Checkpoint LSN: 3874492737773. Consider increasing innodb_redo_log_capacity.
[ERROR] [MY-013059] [InnoDB] Out of space in the redo log. Checkpoint LSN: 3874492737773. Consider increasing innodb_redo_log_capacity.
[ERROR] [MY-013059] [InnoDB] Out of space in the redo log. Checkpoint LSN: 3874492737773. Consider increasing innodb_redo_log_capacity.
.
.
.
.
[Warning] [MY-013907] [InnoDB] Deprecated configuration parameters innodb_log_file_size and/or innodb_log_files_in_group have been used to compute innodb_redo_log_capacity=33554432. Please use innodb_redo_log_capacity instead.

What are the recommended MySQL tuning parameters?

Environment

API Gateway 10.X

MySQL: 8.0.30

Cause

As of MySQL 8.0.30, the innodb_log_files_in_group and innodb_log_file_size parameters are deprecated. A new parameter, innodb_redo_log_capacity, is used to determine the redo log size. The default value is about 105 MB.

Resolution

Increase the size of the innodb_redo_log_capacity. This value will depend on how much disk you have allocated to /var/lib/mysql.

1. Log in to the MySQL database
2. Run the following command: SET GLOBAL innodb_redo_log_capacity = <value_in_bytes>;

EXAMPLES
SET GLOBAL innodb_redo_log_capacity = 2504401162; (about 2.5 GB)
SET GLOBAL innodb_redo_log_capacity = 4608802324; (about 4.5 GB)
SET GLOBAL innodb_redo_log_capacity = 8589934592; (about 8.5 GB)

NOTE: After updating this parameter, the change should take effect immediately but there may be some delay in the update to be fully implemented.

Additional Information

REF: https://dev.mysql.com/doc/refman/8.0/en/innodb-redo-log.html