MySQL Forums
Forum List  »  InnoDB

Re: change value of innodb_log_file_size
Posted by: James Day
Date: April 27, 2005 01:04AM

Don't delete the current log files. Rename them instead.

Once you have the log files renamed you can change the log file size in my.cnf and start MySQL. The log files will be created with the new size. Once MySQL has started correctly you can delete the old log files.

If you have deleted the log files already and MySQL is running normally you're OK and haven't lost any data.

InnoDB normally saves some work for background processing if it is very busy and that in progress work is in the InnoDB log files. This makes it faster when under high load but it means that you must save the log files until that succesful restart has proved that there was no incomplete work in them.

Options: ReplyQuote

Written By
Re: change value of innodb_log_file_size
April 27, 2005 01:04AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.