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