Applicable To InnoDB Server Startup Option
--innodb_log_file_size=<value>Scope Global Dynamic Yes Possible Values Integer: Range: 1M - 4G
<1M will be adjusted to 1M Default Value 5M Category Performance, Maintenance
This variable defines the size of each log file in a log group. While setting this variable it should be noted that combined size of all log files should be less than 4GB.
InnoDB requires these logs for recovery in case of a crash. So how come the size of these logs effect server performance? As stated in MySQL manual "The larger the value, the less checkpoint flush activity is needed in the buffer pool, saving disk I/O.", these logs help InnoDB in running more [Read more...]