MySQL Forums
Forum List  »  InnoDB

innodb_log_file_size parameter
Posted by: Mark Rigney
Date: June 28, 2005 01:07PM

Hi,
I posted this originally on the newbie page but I thought I might get a better response here.

This morning my db crashed due to a power outage. I was unable to restart the db and after checking the log I had the following error:

InnoDB: Error: log file .\ib_logfile0 is of different size 0 10485760 bytes
InnoDB: than specified in the .cnf file 0 104857600 bytes!
050628 10:11:48 [ERROR] Can't init databases
050628 10:11:48 [ERROR] Aborting

Prior to the db crash ( a day or 2 earlier ) I had changed the innodb_log_file_size parameter from 10M to 100M and restarted the db. To recover from the crash I changed the parameter back to 10m and that let me get past the above error and restore the db.

My question now is why was this the case? Should'nt it have adjusted after the last successful db startup? What am I missing? Furthermore, what should my process be to change back to a 100m innodb_log_file_size? Should I change the parameter and then cycle the server? What am I missing?

Thanks in advance.

Options: ReplyQuote


Subject
Views
Written By
Posted
innodb_log_file_size parameter
9495
June 28, 2005 01:07PM
17177
June 28, 2005 01:51PM
5149
June 28, 2005 01:53PM
5218
November 23, 2008 03:30AM


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.