Re: InnoDB log group capacity error
Posted by:
Rick James
Date: February 27, 2009 12:09AM
10x seems extensive.
You must have some big MEDIUM/LONG BLOB/TEXT?
Anyway, to make the messages go away, do something like...
1. gracefully shutdown.
2. change my.cnf entry for innodb_log_file_size so that that the product of that value and innodb_log_files_in_group is more like what they recommend. (But the product must not be more than 4G.)
3. Remove the iblog* files (probably two)
4. Restart
With innodb_buffer_pool_size = 1920M , I assume you have at least 4GB of RAM?
Subject
Written By
Posted
February 26, 2009 01:58PM
Re: InnoDB log group capacity error
February 27, 2009 12:09AM
February 28, 2009 06:45AM
February 28, 2009 03:48PM
February 28, 2009 04:04PM
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.