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

set information_schema.system_variables NUMERIC_MIN_VALUE for innodb_buffer_pool system variable based on innodb_page_size

Details

    • Sprint 7 (07.04.2025), Sprint 8 (21.04.2025)

    Description

      When reviewing the minimum values for variables in information_schema.system_variables.NUMERIC_MIN_VALUE the value displayed doesn't take into account the innodb page size.

      eg. information_schema.system_variables.NUMERIC_MIN_VALUE for innodb_buffer_pool_size is 2MB, but using this value for innodb_buffer_pool_size produces an error message if your innodb page size is not 4kb.

      [ERROR] InnoDB: innodb_page_size=16384 requires innodb_buffer_pool_size >= 5MiB current 2MiB

      Attachments

        Issue Links

          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-27467 innodb to enfore the minimum innodb_buffer_pool_size in SET (resize) the same as startup

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            richmeese Rich Meese created issue -
            danblack Daniel Black made changes -
            Field Original Value New Value
            danblack Daniel Black made changes -
            Affects Version/s 10.5 [ 23123 ]
            danblack Daniel Black made changes -
            Component/s Storage Engine - InnoDB [ 10129 ]
            danblack Daniel Black made changes -
            Assignee Daniel Black [ danblack ]
            danblack Daniel Black made changes -
            danblack Daniel Black made changes -
            Summary set minimum parameter values based on block size set information_schema.system_variables NUMERIC_MIN_VALUE for innodb_buffer_pool system variable based on innodb_page_size
            danblack Daniel Black made changes -
            Fix Version/s 10.5 [ 23123 ]
            danblack Daniel Black made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            danblack Daniel Black added a comment -

            serg - are the plugin interface changes in https://github.com/MariaDB/server/pull/3777 acceptable?

            marko, is the rest of it ok?

            danblack Daniel Black added a comment - serg - are the plugin interface changes in https://github.com/MariaDB/server/pull/3777 acceptable? marko , is the rest of it ok?
            danblack Daniel Black made changes -
            Assignee Daniel Black [ danblack ] Sergei Golubchik [ serg ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            danblack Daniel Black made changes -
            Description When reviewing the minimum values for variables in information_schema.system_variables.NUMERIC_MIN_VALUE the value displayed doesn't take into account the block size.

            eg. information_schema.system_variables.NUMERIC_MIN_VALUE for innodb_buffer_pool_size is 2MB, but using this value produces an error message if your blocksize is not 4kb.

            [ERROR] InnoDB: innodb_page_size=16384 requires innodb_buffer_pool_size >= 5MiB current 2MiB             		When reviewing the minimum values for variables in information_schema.system_variables.NUMERIC_MIN_VALUE the value displayed doesn't take into account the innodb page size.

            eg. information_schema.system_variables.NUMERIC_MIN_VALUE for innodb_buffer_pool_size is 2MB, but using this value for innodb_buffer_pool_size produces an error message if your innodb page size is not 4kb.

            [ERROR] InnoDB: innodb_page_size=16384 requires innodb_buffer_pool_size >= 5MiB current 2MiB
            marko Marko Mäkelä added a comment -

            In the current patch revision, I do not see any changes to InnoDB code, only to the test case innodb.restart, so there is not much for me to review.

            marko Marko Mäkelä added a comment - In the current patch revision, I do not see any changes to InnoDB code, only to the test case innodb.restart , so there is not much for me to review.
            danblack Daniel Black made changes -
            Assignee Sergei Golubchik [ serg ] Daniel Black [ danblack ]
            danblack Daniel Black made changes -
            Labels foundation
            danblack Daniel Black made changes -
            Sprint Sprint 7 (07.04.2025) [ 796 ]
            vlad.radu Vlad Radu made changes -
            Sprint Sprint 7 (07.04.2025) [ 796 ] Sprint 7 (07.04.2025), Sprint 8 (21.04.2025) [ 796, 800 ]

            People

              danblack Daniel Black
              richmeese Rich Meese
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start 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.