Description: 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