MySQL 8 Cookbook

innodb_log_file_size

This is the size of the redo log space used to replay committed transactions in case of a database crash. The default is 48 MB, which may not be sufficient for production workloads. To start with, you can set 1 GB or 2 GB. This change requires a restart. Stop the MySQL server and make sure that it shuts down without errors. Make the changes in my.cnf and start the server. In earlier versions, you need to stop the server, remove the log files, and then start the server. In MySQL 8, it is automatic. Modifying the redo log files is explained in Chapter 11, Managing Tablespace, in the Changing the number or size of InnoDB redo log files section.