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

          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

          Activity

            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.