[MDEV-20907] Set innodb_log_files_in_group=1 by default Created: 2019-10-28  Updated: 2020-05-28  Resolved: 2019-10-29

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB
Fix Version/s: 10.5.0

Type: Task Priority: Major
Reporter: Marko Mäkelä Assignee: Marko Mäkelä
Resolution: Fixed Votes: 0
Labels: performance

Issue Links:
Blocks
blocks MDEV-14425 Change the InnoDB redo log format to ... Closed
is blocked by MDEV-12061 Allow innodb_log_files_in_group=1 Closed
Relates
relates to MDEV-21990 Issue a message on changing deprecate... Closed

 Description   

Historically, InnoDB split the redo log into at least 2 files. MDEV-12061 allowed the minimum to be innodb_log_files_in_group=1, but it kept the default at innodb_log_files_in_group=2.

Because performance seems to be slightly better with only one log file, and because implementing an append-only variant of the log would require a single file, let us define the default to be 1, and have innodb_log_file_size=96M, to retain the same default total size of 2×48MiB.

Note that this variable will be deleted by MDEV-14425!

 Comments   
Comment by Marko Mäkelä [ 2020-03-06 ]

In MariaDB Server 10.5.1, the option was deprecated and ignored. That is, MariaDB 10.5 will only support innodb_log_files_in_group=1 and a single redo log file, ib_logfile0.

Comment by Marko Mäkelä [ 2020-03-26 ]

As part of MDEV-14425 preparations, MariaDB 10.5.1 deprecated the parameter innodb_log_files_in_group and hard-coded the value to 1. The deprecation logic was improved in MDEV-21990.

Generated at Thu Feb 08 09:03:06 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.