Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
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!
Attachments
Issue Links
- blocks
-
-
- Closed
-
- is blocked by
-
-
- Closed
-
- relates to
-
-
- Closed
-
-
MDEV-33503 innodb_log_files_in_group is quietly ignored
-
- Confirmed
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Link |
This issue is blocked by |
| Link | This issue relates to MENT-290 [ MENT-290 ] |
| Link |
This issue blocks |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Fix Version/s | 10.5.0 [ 23709 ] | |
| Fix Version/s | 10.5 [ 23123 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | In Progress [ 3 ] | Closed [ 6 ] |
| Fixing Priority | 250 |
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.
| Link |
This issue relates to |
| Description |
Historically, InnoDB split the redo log into at least 2 files. 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. |
Historically, InnoDB split the redo log into at least 2 files. 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 |
| Workflow | MariaDB v3 [ 100633 ] | MariaDB v4 [ 134121 ] |
| Link | This issue relates to MDEV-33503 [ MDEV-33503 ] |
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.