InnoDB engine redo file maintenance method

If you want to adjust the size and number of InnoDB redo log files, you can use the following steps:

1. Close mysql

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

2. Modify innodb_log_file_size and innodb_log_files_in_group in the configuration file

3. Start mysql

service mysqld start

According to the official documentation, MySQL will perform a checkpoint after completing the recovery operation, so delete all old log files and restart according to the new configuration file.

Generate redo files

The above InnoDB engine redo file maintenance method is all the content that the editor shares with you. I hope it can give you a reference. I also hope that you will support 123WORDPRESS.COM.