Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-36185

MariaDB 10.11: option 'innodb-log-buffer-size': unsigned value 2147482624 adjusted to 2147479552

Details

    Description

      According to https://mariadb.com/kb/en/innodb-system-variables/#innodb_log_buffer_size, the valid range for innodb_log_buffer_size is 262144 to 2147482624 (256KB to 2048MB). However when setting

      innodb_log_buffer_size = 2147482624
      

      in the configuration file, I receive during MariaDB restart the following message in the log file:

      2025-02-26 22:50:54 0 [Warning] option 'innodb-log-buffer-size': unsigned value 2147482624 adjusted to 2147479552
      

      And using

      innodb_log_buffer_size = 2048M
      

      in the configuration file leads to the following in the log file:

      2025-02-26 22:54:32 0 [Warning] option 'innodb-log-buffer-size': unsigned value 2147483648 adjusted to 2147479552
      

      Why is that? Is this a bug in the code or in the documentation? From my understanding 2G = 2048M = 2147483648

      Attachments

        Issue Links

          Activity

            danblack Daniel Black added a comment -

            Seems from the previous change in code https://github.com/MariaDB/server/pull/3172 , the maximum is what it is rounded to - 2GiB - 4KiB.

            Updating the documentation now.

            Thanks for the bug report.

            danblack Daniel Black added a comment - Seems from the previous change in code https://github.com/MariaDB/server/pull/3172 , the maximum is what it is rounded to - 2GiB - 4KiB. Updating the documentation now. Thanks for the bug report.
            danblack Daniel Black added a comment -

            Documented.

            danblack Daniel Black added a comment - Documented.

            People

              danblack Daniel Black
              rsc Robert Scheck
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.