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:
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.
Once the server has stopped, edit the configuration file and change the value of
innodb_log_file_size to your desired value.
Move the log file sizes
ib_log* to some place out of the the directory where the log files reside.
Now restart the server.
And you have successfully changed the log file size. Its not that difficult is it?