How to resize Innodb log files?

Just in case you don’t know resizing Innodb log file is not just simple as changing the value of innodb_log_file_size in the MySQL configuration file. But its even more simpler. Follow the following steps and you will be done with the resizing:

Step 1

Stop the MySQL server and make sure it shuts down without any errors. You can have a look at the error log to see if there are no errors.

Step 2

Once the server has stopped, edit the configuration file and change the value of innodb_log_file_size to your desired value.

Step 3

Move the log file sizes ib_log* to some place out of the the directory where the log files reside.

Step 4

Now restart the server.

And you have successfully changed the log file size. Its not that difficult is it?