out of space in the redo log...error below mysql 8.0.30
search cancel

out of space in the redo log...error below mysql 8.0.30

book

Article ID: 256373

calendar_today

Updated On:

Products

CA API Gateway

Issue/Introduction

We are running on a 10.1 CR02 with physical appliance machine that has the CR02 patch RPM fix applied.  Our MySQL database version is 8.0.25.  

Below shows how to change the redo log in 8.0.30 and above

https://knowledge.broadcom.com/external/article/249727/out-of-space-in-the-redo-log.html

How do we change this in below 8.0.30?

Environment

Release : 10.1

Resolution

 For Below 8.0.30 

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

"Stop the MySQL server and make sure that it shuts down without errors.

Edit my.cnf to change the redo log file configuration. To change the redo log file size, configure innodb_log_file_size. To increase the number of redo log files, configure innodb_log_files_in_group.

Start the MySQL server again."

The default OVA value

# more /etc/my.cnf | grep 'log_file';
innodb_log_file_size=16M

If you want larger files you can set these to 32M (a larger size).
Or you can set the log_files_in_group to be greater then 2 (a larger number of files).