Fixing “InnoDB: Error: log file ./ib_logfile0 is of different size” Error

After changing INODDB parameters (at /etc/my.cnf) there might be an error starting MYSQL.

Jun 12 2012

So you wanted to change the value of “innodb_log_file_size” on your mysql server.

As it happens, you can’t just change it the “my.cnf” file, restart and make it work. If you do, Mysql will refuse to start and throw this error instead. You can the details of the startup error in your mysql error log file. 

To safely change this setting follow these steps

Make sure if you are changing things on a production server, you take due care of the mysql downtime due to the changes and restart, and have backups to recover quickly in case something goes wrong.

Step-by-step guide

  1. Shutdown your mysql server, make sure to check the error log that the shutdown had no issues
  2. Move the “ib_logfile0″ and “ib_logfile1″ files from your mysql data directory.
  3. Change “innodb_log_file_size” to your desired setting.
  4. Restart mysql. Check the error log to make sure everything started successfully, mysql may complain that the log files don’t exist, it will make new ones and start. rendering macro ‘contentbylabel’ : parameters should not be empty

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.