MySQL Forums :: General :: innodb_log_file_size


Advanced Search

innodb_log_file_size
Posted by: rihad rihad ()
Date: September 10, 2010 11:52PM

Hello, I've set buffer pool settings like so:
innodb_buffer_pool_size = 6G
innodb_buffer_pool_instances = 2

Now I want to set the total log_file_size to 3G split across two files in the group. Is this a good idea? The MySQL 5.5.5 docs claim that long startup delays after a crash are no longer a problem:
Quote

It often makes sense to set the total size of the log files as large as the buffer pool or even larger. Although in the past large log files could make crash recovery take excessive time, starting with MySQL 5.5, performance enhancements to crash recovery make it possible to use large log files with fast startup after a crash.
I can't set the total log file size to 6G as it's limited to <4G, but 3G seems nice. I hope the author wasn't implying a 256M or so buffer pool sizes and 3G is waaaaaay too much LOL.

TIA

Options: ReplyQuote


Subject Written By Posted
innodb_log_file_size rihad rihad 09/10/2010 11:52PM
Re: innodb_log_file_size Rick James 09/17/2010 06:51PM
Re: innodb_log_file_size rihad rihad 09/17/2010 10:57PM
Re: innodb_log_file_size abilash vs 10/27/2010 08:33PM
Re: innodb_log_file_size Rick James 10/27/2010 11:06PM
Re: innodb_log_file_size abilash vs 10/28/2010 08:40AM
Re: innodb_log_file_size abilash vs 11/01/2010 09:53AM
Re: innodb_log_file_size Rick James 11/02/2010 12:51PM
Re: innodb_log_file_size abilash vs 11/05/2010 10:55PM
Re: innodb_log_file_size Rick James 11/06/2010 08:07AM


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.