The ib_logfile0
file and ib_logfile1
are the default InnoDB
redo log files created inside the data directory
, with 48 MB each. If you wish to change the size of the redo log files, you can simply change it in the configuration file and restart MySQL. In previous versions, you had to do a slow shutdown of MySQL server, remove the redo log files, change the config file, and then start MySQL server.
As of MySQL 8, InnoDB
detects that the innodb_log_file_size
differs from the redo log file size. It writes a log checkpoint, closes and removes the old log files, creates new log files at the requested size, and opens the new log files.
- Check the sizes of the current files:
shell> sudo ls -lhtr /var/lib/mysql/ib_logfile* -rw-r-----. 1 mysql mysql 48M Oct 7 10:16 /var/lib/mysql/ib_logfile1 -rw-r-----. 1 mysql mysql 48M Oct 7 10:18 /var/lib/mysql/ib_logfile0
shell...