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

innodb to enfore the minimum innodb_buffer_pool_size in SET (resize) the same as startup

    XMLWordPrintable

    Details

      Description

      The innodb buffer pool size on startup has a defined minimum value

      $ mariadblocal --innodb-buffer-pool-size=1M
      2022-01-11 18:01:59 0 [Note] sql/mysqld (server 10.8.0-MariaDB) starting as process 269909 ...
      2022-01-11 18:01:59 0 [Warning] option 'innodb-buffer-pool-size': unsigned value 1048576 adjusted to 5242880
      

      $ mariadblocal --innodb-buffer-pool-size=1M --innodb-page-size=64k
      2022-01-11 18:03:45 0 [Warning] option 'innodb-buffer-pool-size': unsigned value 1048576 adjusted to 5242880
      2022-01-11 18:03:45 0 [ERROR] InnoDB: innodb_page_size=65536 requires innodb_buffer_pool_size > 24M current 5242880
      

      The same values should be enforced for runtime resizing of innodb.

      With really small chunk sizes this results an impossibly small size as MDEV-27461 indicates.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              danblack Daniel Black
              Reporter:
              danblack Daniel Black
              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.