Beware of setting innodb_log_file_size too high on mysql!

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.

Jens Grassel Written by:

Solving problems and burning chrome for fun and profit.