Innodb_log_file_size dictates the size in bytes of the commit log files stored by MySQL.
Remember that these log files will protect database data during power loss events or crashes. For servers, with write-intensive workloads, the configuration of innodb_log_file_size is very important to performance. But in most cases, your innodb_log_file_size does not need to be larger than your buffer pool.
Releem automatically tunes innodb_log_file_size and 44 other variables
to improve MySQL performance. Try Releem for Free
, or deepen your understanding by reading our detailed article.