Innodb Engine redo file maintenance method, innodb Engine redo Maintenance

Innodb Engine redo file maintenance method, innodb Engine redo Maintenance

To adjust the size and number of redo log files of innodb, follow these steps:

1. Disable 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 instructions in the official documentation, mysql will next checkpoint after the recovery operation is completed. Therefore, all the old log files will be deleted from the new configuration files.

Generate redo files

The above innodb Engine redo file maintenance method is all the content shared by the editor. I hope you can give us a reference and support the help house.