Shulou(Shulou.com)05/31 Report--

Today, I will talk to you about the specific methods and steps of adjusting the number and size of innodb redo log files, which may not be well understood by many people. in order to make you understand better, the editor has summarized the following contents for you. I hope you can get something according to this article.

Compared with Oracle's online adjustment of the number and size of redo logs, mysql lacks this point. Even with the current mysql80 version, it is not possible to adjust the number and size of innodb redo logs online. Here are only the specific methods and steps for mysql to adjust the number and size of innodb redo log files.

1. Stop the mysql server and make sure it is shut down properly

two。 Edit the my.cnf file to adjust the redo log file-related configuration in it.

To change the size of the redo log file, the option innodb_log_file_size needs to be configured.

To change the number of redo log files, the option innodb_log_files_in_group needs to be configured.

3. Start the mysql server again.

When innodb detects that the option innodb_log_file_size is different from the actual redo log file size, it first completes a checkpoint, closes and removes the old redo log file, then creates a new redo log files with the desired size, and opens these new redo log files.

After reading the above, do you have any further understanding of the specific methods and steps for adjusting the number and size of innodb redo log files? If you want to know more knowledge or related content, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.