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-20907Set innodb_log_files_in_group=1 by default
Closed
MDEV-21990Issue a message on changing deprecated innodb_log_files_in_group
Closed
MDEV-23397Remove deprecated InnoDB options in 10.6
Closed
MDEV-28671Presentation of aliases in `mariadbd --verbose --help` is highly redundant
Stalled
MDEV-30731Deprecated variables are not consistently highlighted
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 by MDEV-23397 in 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.
Marko Mäkelä
added a comment - 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 by MDEV-23397 in 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.
The impact here is that the InnoDB redo log would have been 1/16th the size that I requested and nothing in MariaDB warned me about that.
Mark Callaghan
added a comment - This is dangerous and/or unfriendly.
The impact here is that the InnoDB redo log would have been 1/16th the size that I requested and nothing in MariaDB warned me about that.
This is intentional behavior that monty wanted. Removing any command line option could make the server to fail to start after an upgrade, unlike replacing an option with a dummy that does nothing. The argument was that failing to start after an upgrade is unfriendly.
Sergei Golubchik
added a comment - This is intentional behavior that monty wanted. Removing any command line option could make the server to fail to start after an upgrade, unlike replacing an option with a dummy that does nothing. The argument was that failing to start after an upgrade is unfriendly.
MySQL and MariaDB have a way to deal with possibly unsupported options via the skip_ loose_ prefix.
loose- , not skip-
Vladislav Vaintroub
added a comment - - edited MySQL and MariaDB have a way to deal with possibly unsupported options via the skip_ loose_ prefix.
loose- , not skip-
+1 for a fatal error if redo log size is going to decrease according to the config of innodb_log_files_in_group >1 instead of deprecate and continue. thinking all those benchmark around that simple use same config to compare flavors. looks like a task for the upcoming mariadb-config-upgrade client
VAROQUI Stephane
added a comment - - edited +1 for a fatal error if redo log size is going to decrease according to the config of innodb_log_files_in_group >1 instead of deprecate and continue. thinking all those benchmark around that simple use same config to compare flavors. looks like a task for the upcoming mariadb-config-upgrade client
The configuration upgrade helper tool is covered by MDEV-32745.
There are a number of removed InnoDB options listed in sql/mysqld.cc.
Performance-related would be also innodb_idle_flush_pct (10.1), which was documented as deprecated and having no effect already in 10.2. I see that it had been originally added in MDEV-6932 and the idea reimplemented in a different way in MDEV-26055.
Most removed InnoDB parameters are really meaningless and the result of some cleanup such as MDEV-23379. For example, innodb_undo_logs a.k.a. innodb_rollback_segments is now hard-coded to the maximum value 128.
I went through the list, and in addition to innodb_log_files_in_group I found only one InnoDB related MARIADB_REMOVED_OPTION that could cause surprises:innodb_stats_sample_pages should have been replaced to innodb_stats_transient_sample_pages but is now being ignored.
Marko Mäkelä
added a comment - The configuration upgrade helper tool is covered by MDEV-32745 .
There are a number of removed InnoDB options listed in sql/mysqld.cc .
Performance-related would be also innodb_idle_flush_pct (10.1), which was documented as deprecated and having no effect already in 10.2. I see that it had been originally added in MDEV-6932 and the idea reimplemented in a different way in MDEV-26055 .
Most removed InnoDB parameters are really meaningless and the result of some cleanup such as MDEV-23379 . For example, innodb_undo_logs a.k.a. innodb_rollback_segments is now hard-coded to the maximum value 128.
I went through the list, and in addition to innodb_log_files_in_group I found only one InnoDB related MARIADB_REMOVED_OPTION that could cause surprises: innodb_stats_sample_pages should have been replaced to innodb_stats_transient_sample_pages but is now being ignored.
People
Michael Widenius
Mark Callaghan
Votes:
0Vote for this issue
Watchers:
5Start watching this issue
Dates
Created:
Updated:
Git Integration
Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.
{"report":{"fcp":946.1999999880791,"ttfb":214.10000002384186,"pageVisibility":"visible","entityId":128000,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"6d3824b2-84f3-4b11-93db-9642965cc55b","navigationType":0,"readyForUser":1039.199999988079,"redirectCount":0,"resourceLoadedEnd":1068.300000011921,"resourceLoadedStart":222.5,"resourceTiming":[{"duration":45.5,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":222.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":222.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":268,"responseStart":0,"secureConnectionStart":0},{"duration":45.5,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2bu7/820016/12ta74/8679b4946efa1a0bb029a3a22206fb5d/_/download/contextbatch/css/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":222.69999998807907,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":222.69999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":268.19999998807907,"responseStart":0,"secureConnectionStart":0},{"duration":114,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":222.89999997615814,"connectEnd":222.89999997615814,"connectStart":222.89999997615814,"domainLookupEnd":222.89999997615814,"domainLookupStart":222.89999997615814,"fetchStart":222.89999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":222.89999997615814,"responseEnd":336.89999997615814,"responseStart":336.89999997615814,"secureConnectionStart":222.89999997615814},{"duration":191,"initiatorType":"script","name":"https://jira.mariadb.org/s/099b33461394b8015fc36c0a4b96e19f-CDN/lu2bu7/820016/12ta74/8679b4946efa1a0bb029a3a22206fb5d/_/download/contextbatch/js/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true","startTime":223.10000002384186,"connectEnd":223.10000002384186,"connectStart":223.10000002384186,"domainLookupEnd":223.10000002384186,"domainLookupStart":223.10000002384186,"fetchStart":223.10000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":223.10000002384186,"responseEnd":414.10000002384186,"responseStart":414.10000002384186,"secureConnectionStart":223.10000002384186},{"duration":197.0999999642372,"initiatorType":"script","name":"https://jira.mariadb.org/s/94c15bff32baef80f4096a08aceae8bc-CDN/lu2bu7/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":223.30000001192093,"connectEnd":223.30000001192093,"connectStart":223.30000001192093,"domainLookupEnd":223.30000001192093,"domainLookupStart":223.30000001192093,"fetchStart":223.30000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":223.30000001192093,"responseEnd":420.39999997615814,"responseStart":420.39999997615814,"secureConnectionStart":223.30000001192093},{"duration":199.19999998807907,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":223.5,"connectEnd":223.5,"connectStart":223.5,"domainLookupEnd":223.5,"domainLookupStart":223.5,"fetchStart":223.5,"redirectEnd":0,"redirectStart":0,"requestStart":223.5,"responseEnd":422.69999998807907,"responseStart":422.69999998807907,"secureConnectionStart":223.5},{"duration":201.30000001192093,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":223.5,"connectEnd":223.5,"connectStart":223.5,"domainLookupEnd":223.5,"domainLookupStart":223.5,"fetchStart":223.5,"redirectEnd":0,"redirectStart":0,"requestStart":223.5,"responseEnd":424.80000001192093,"responseStart":424.80000001192093,"secureConnectionStart":223.5},{"duration":292.80000001192093,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2bu7/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":223.69999998807907,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":223.69999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":516.5,"responseStart":0,"secureConnectionStart":0},{"duration":203.60000002384186,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":223.89999997615814,"connectEnd":223.89999997615814,"connectStart":223.89999997615814,"domainLookupEnd":223.89999997615814,"domainLookupStart":223.89999997615814,"fetchStart":223.89999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":223.89999997615814,"responseEnd":427.5,"responseStart":427.5,"secureConnectionStart":223.89999997615814},{"duration":292.5,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2bu7/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/css/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.css?jira.create.linked.issue=true","startTime":224.19999998807907,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":224.19999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":516.6999999880791,"responseStart":0,"secureConnectionStart":0},{"duration":205,"initiatorType":"script","name":"https://jira.mariadb.org/s/3339d87fa2538a859872f2df449bf8d0-CDN/lu2bu7/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/js/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.js?jira.create.linked.issue=true&locale=en","startTime":224.19999998807907,"connectEnd":224.19999998807907,"connectStart":224.19999998807907,"domainLookupEnd":224.19999998807907,"domainLookupStart":224.19999998807907,"fetchStart":224.19999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":224.19999998807907,"responseEnd":429.19999998807907,"responseStart":429.19999998807907,"secureConnectionStart":224.19999998807907},{"duration":421.89999997615814,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":238,"connectEnd":238,"connectStart":238,"domainLookupEnd":238,"domainLookupStart":238,"fetchStart":238,"redirectEnd":0,"redirectStart":0,"requestStart":238,"responseEnd":659.8999999761581,"responseStart":659.8999999761581,"secureConnectionStart":238},{"duration":681.3999999761581,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":238.10000002384186,"connectEnd":238.10000002384186,"connectStart":238.10000002384186,"domainLookupEnd":238.10000002384186,"domainLookupStart":238.10000002384186,"fetchStart":238.10000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":238.10000002384186,"responseEnd":919.5,"responseStart":919.5,"secureConnectionStart":238.10000002384186},{"duration":130.30000001192093,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":530.3999999761581,"connectEnd":530.3999999761581,"connectStart":530.3999999761581,"domainLookupEnd":530.3999999761581,"domainLookupStart":530.3999999761581,"fetchStart":530.3999999761581,"redirectEnd":0,"redirectStart":0,"requestStart":530.3999999761581,"responseEnd":660.6999999880791,"responseStart":660.6999999880791,"secureConnectionStart":530.3999999761581},{"duration":228,"initiatorType":"link","name":"https://jira.mariadb.org/s/d5715adaadd168a9002b108b2b039b50-CDN/lu2bu7/820016/12ta74/be4b45e9cec53099498fa61c8b7acba4/_/download/contextbatch/css/jira.project.sidebar,-_super,-project.issue.navigator,-jira.general,-jira.browse.project,-jira.view.issue,-jira.global,-atl.general,-com.atlassian.jira.projects.sidebar.init/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":840.3000000119209,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":840.3000000119209,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1068.300000011921,"responseStart":0,"secureConnectionStart":0},{"duration":198.79999995231628,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/e65b778d185daf5aee24936755b43da6/_/download/contextbatch/js/browser-metrics-plugin.contrib,-_super,-project.issue.navigator,-jira.view.issue,-atl.general/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":841.6000000238419,"connectEnd":841.6000000238419,"connectStart":841.6000000238419,"domainLookupEnd":841.6000000238419,"domainLookupStart":841.6000000238419,"fetchStart":841.6000000238419,"redirectEnd":0,"redirectStart":0,"requestStart":841.6000000238419,"responseEnd":1040.3999999761581,"responseStart":1040.3999999761581,"secureConnectionStart":841.6000000238419},{"duration":203.10000002384186,"initiatorType":"script","name":"https://jira.mariadb.org/s/f51ef5507eea4c158f257c66c93b2a3f-CDN/lu2bu7/820016/12ta74/be4b45e9cec53099498fa61c8b7acba4/_/download/contextbatch/js/jira.project.sidebar,-_super,-project.issue.navigator,-jira.general,-jira.browse.project,-jira.view.issue,-jira.global,-atl.general,-com.atlassian.jira.projects.sidebar.init/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true","startTime":842,"connectEnd":842,"connectStart":842,"domainLookupEnd":842,"domainLookupStart":842,"fetchStart":842,"redirectEnd":0,"redirectStart":0,"requestStart":842,"responseEnd":1045.1000000238419,"responseStart":1045.1000000238419,"secureConnectionStart":842},{"duration":177.69999998807907,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":933,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":933,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1110.699999988079,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":20,"responseStart":214,"responseEnd":230,"domLoading":220,"domInteractive":1123,"domContentLoadedEventStart":1123,"domContentLoadedEventEnd":1190,"domComplete":1406,"loadEventStart":1406,"loadEventEnd":1406,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1079.800000011921},{"name":"bigPipe.sidebar-id.end","time":1080.5},{"name":"bigPipe.activity-panel-pipe-id.start","time":1080.699999988079},{"name":"bigPipe.activity-panel-pipe-id.end","time":1082.699999988079},{"name":"activityTabFullyLoaded","time":1211.300000011921}],"measures":[],"correlationId":"2fc79678fcd3cd","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":136,"dbReadsTimeInMs":28,"dbConnsTimeInMs":39,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
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.