innodb Engine redo File Maintenance Method

If you want to adjust the size and number of redo log files for innodb, you can take the following steps:

1. Turn off mysql

mysqladmin -h127.0.0.1 -P3306 -uroot -p shutdown

2. Modify innodb_log_file_size, innodb_log_files_in_group in the configuration file

3. Start mysql

service mysqld start

According to the official document, mysql will complete the recovery operation after the next checkpoint, so the old log files are deleted, according to the new configuration file

Generate an redo file