How can I change MySQL?s innodb_log_file_size parameter?

book

Article ID: 15663

calendar_today

Updated On:

Products

CA Spectrum

Issue/Introduction

We are trying to fine tune our mySql server and so are making changes to the mySql configuration file.

When we try to change the innodb_log_file_size parameter we get the follwoing error:

ERROR 1033 (HY000): Incorrect information in file.

 

 

The default settings in 10.x are as follows:

innodb_file_per_table 

innodb_buffer_pool_size = 256M 

innodb_log_file_size = 256M 

innodb_log_buffer_size = 4M 

 



How to change MySQL’s innodb_log_file_size parameter?

Environment

Release:
Component:

Resolution

We do not recommend to change MySQL’s innodb_log_file_size parameter, but if you need to, you can’t just change the parameter it in the my.cnf file and restart the server. 

If you do, InnoDB will refuse to start, because the existing log files don’t match the configured size. 

 

To do so, you can follow these steps.

Please back up your mySql database before attempting to make any such changes.

Shut the server down cleanly and normally.

Move away (don’t delete) the log files, which are named ib_logfile0, ib_logfile1, etc.

Check the error log, to ensure there was no problem shutting down. 

Restart the server and watch the error log output carefully. 

You should see InnoDB print messages, saying that the log files don’t exist. It will create new ones and then start. 

Verify that InnoDB is working, before deleting the old log files. 

Additional Information

The official mySql documentation: 

https://dev.mysql.com/doc/refman/5.5/en/innodb-data-log-reconfiguration.html 

 

How to find the mySQL configuration file "my.cnf".

https://comm.support.ca.com/kb/How-to-find-the-mySQL-configuration-file-mycnf/KB000015656