Posted about 8 years ago. Visible to the public.

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.

Owner of this card:

Last edit:
about 8 years ago
Posted by jan0sch to jan0sch's deck
This website uses short-lived cookies to improve usability.
Accept or learn more