Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.6, 10.11, 11.0(EOL), 11.1(EOL), 11.2(EOL), 11.3(EOL), 11.4
-
None
-
None
-
Ubuntu 22.04
Description
Docs claim that innodb_log_files_in_group was removed in 10.6:
https://mariadb.com/kb/en/innodb-system-variables/#innodb_log_files_in_group
But I can start 11.4.1 with the following in my.cnf:
innodb_log_files_in_group=16
innodb_log_file_size=1G
When I use the above I expect 16 1G files and 16G in total for redo, but I only get 1 1G file. This is bad for performance. MySQL and MariaDB have a way to deal with possibly unsupported options via the "skip_" prefix. I don't want MariaDB also quietly ignoring options that are not supported.
Attachments
Issue Links
- relates to
-
MDEV-20907 Set innodb_log_files_in_group=1 by default
-
- Closed
-
-
MDEV-21990 Issue a message on changing deprecated innodb_log_files_in_group
-
- Closed
-
-
MDEV-23397 Remove deprecated InnoDB options in 10.6
-
- Closed
-
-
MDEV-28671 Presentation of aliases in `mariadbd --verbose --help` is highly redundant
-
- Stalled
-
-
MDEV-30731 Deprecated variables are not consistently highlighted
-
- Open
-
-
MDEV-32745 config upgrade helper tool
-
- Open
-
Activity
Field | Original Value | New Value |
---|---|---|
Link |
This issue relates to |
Link |
This issue relates to |
Link |
This issue relates to |
Link | This issue relates to MDEV-30731 [ MDEV-30731 ] |
Link | This issue relates to MDEV-28671 [ MDEV-28671 ] |
Assignee | Michael Widenius [ monty ] |
Priority | Minor [ 4 ] | Major [ 3 ] |
Fix Version/s | 10.6 [ 24028 ] | |
Fix Version/s | 10.11 [ 27614 ] | |
Fix Version/s | 11.0 [ 28320 ] | |
Fix Version/s | 11.1 [ 28549 ] | |
Fix Version/s | 11.2 [ 28603 ] |
Affects Version/s | 10.6 [ 24028 ] | |
Affects Version/s | 10.11 [ 27614 ] | |
Affects Version/s | 11.0 [ 28320 ] | |
Affects Version/s | 11.1 [ 28549 ] | |
Affects Version/s | 11.2 [ 28603 ] | |
Affects Version/s | 11.3 [ 28565 ] | |
Affects Version/s | 11.4 [ 29301 ] | |
Affects Version/s | 11.4.1 [ 29523 ] |
Link | This issue relates to MDEV-32745 [ MDEV-32745 ] |
Fix Version/s | 11.0 [ 28320 ] |
Status | Open [ 1 ] | Confirmed [ 10101 ] |
Fix Version/s | 11.1 [ 28549 ] |
Fix Version/s | 11.2(EOL) [ 28603 ] |
MariaDB was changed to use a single log file in
MDEV-20907(MariaDB Server 10.5). A deprecation warning was added to InnoDB startup in 10.5.2, but it was lost when the deprecated setting was removed byMDEV-23397in 10.6.0.The reason why the parameter is quietly ignored is that someone wanted to be old configuration files to "work" without any modification. That is why the MARIADB_REMOVED_OPTION was introduced in 10.5.
Similar to the PLUGIN_VAR_DEPRECATED that was added in
MDEV-27730, there is no consistent and prominent flagging about the use of any MARIADB_REMOVED_OPTION parameters. I did not find a bug specifically about this; maybe serg could retitle this bug and target the fix for the earliest affected version series, which would be 10.6.By the way, starting with
MDEV-27812, you can SET GLOBAL innodb_log_file_size while the server is running. But unlike MySQL, there is no SET PERSISTENT in MariaDB Server.