Beware of setting innodb_log_file_size too high on mysql!
2012-06-13
If you run MySQL you probably use the innodb storage engine because it provides a number of advantages over MyIsam.
The official documentation recommends giving 50-80% of your ram to
innodb_buffer_pool_size which can easily go above 10 gb because ram is
cheap nowadays.
The same documentation recommends settings innodb_log_file_size to 25% of
innodb_buffer_pool_size meaning this can easily be 2 or more gb.
However MySQL is only able to handle a combined log file size (Yes, there
are 2 of them.) of 4095 mb! Therefore you can only set a maximum
innodb_log_file_size of 2047 mb.