Re: innodb_log_file_size

[abilash vs]

Rick,I too have a query on innodb log file size.

I have not set any default size for the variable innodb_log_file_size for my server,hence by default MySql has taken the value to 5M (5242880).Today I got the below error in the error logs and saw that both of my log files(ib_logfile0 and ib_logfile1) have reached the size 5242880.

Error Message:
InnoDB: ERROR: the age of the last checkpoint is 9433744,
InnoDB: which exceeds the log group capacity 9433498.
InnoDB: If you are using big BLOB or TEXT rows, you must set the
InnoDB: combined size of log files at least 10 times bigger than the
InnoDB: largest such row.


I got to know that a higher value of innodb_log_file_size needs to be specified in my.cnf file ,however I could not do a server restart at this point of time.I understand it should not be ignored,but my question what will be the impact if I leave it like that for a day or so ?I am seeing my application up and running without any issues..