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

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

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-28471 INSTALL ERROR Innodb engine settings Page size 64KiB causing error

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-27461 Server hangs when the bufferpool is shrunk to 8M and innodb_page_size=64K

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35889 set information_schema.system_variables NUMERIC_MIN_VALUE for innodb_buffer_pool system variable based on innodb_page_size

          • Trivial - Cosmetic problem like misspelt words or misaligned text.
          • In Review

          Activity

            Ascending order - Click to sort in descending order
            danblack Daniel Black created issue -
            danblack Daniel Black made changes -
            Field Original Value New Value
            danblack Daniel Black made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            danblack Daniel Black added a comment -

            Implementation based on https://jira.mariadb.org/browse/MDEV-27461?focusedCommentId=211139&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-211139 in pr 1987

            danblack Daniel Black added a comment - Implementation based on https://jira.mariadb.org/browse/MDEV-27461?focusedCommentId=211139&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-211139 in pr 1987
            danblack Daniel Black made changes -
            Assignee Daniel Black [ danblack ] Marko Mäkelä [ marko ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            marko Marko Mäkelä added a comment -

            Thank you, the revised version looks much better. OK to push after addressing my remaining comments.

            marko Marko Mäkelä added a comment - Thank you, the revised version looks much better. OK to push after addressing my remaining comments.
            marko Marko Mäkelä made changes -
            Assignee Marko Mäkelä [ marko ] Daniel Black [ danblack ]
            Status In Review [ 10002 ] Stalled [ 10000 ]
            danblack Daniel Black made changes -
            Fix Version/s 10.2.42 [ 26803 ]
            Fix Version/s 10.3.33 [ 26805 ]
            Fix Version/s 10.4.23 [ 26807 ]
            Fix Version/s 10.5.14 [ 26809 ]
            Fix Version/s 10.6.6 [ 26811 ]
            Fix Version/s 10.7.2 [ 26813 ]
            Fix Version/s 10.2 [ 14601 ]
            Resolution Fixed [ 1 ]
            Status Stalled [ 10000 ] Closed [ 6 ]
            danblack Daniel Black made changes -
            danblack Daniel Black made changes -

            People

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