[MDEV-35889] set information_schema.system_variables NUMERIC_MIN_VALUE for innodb_buffer_pool system variable based on innodb_page_size - Jira

XML

Word

Printable

Details

Type: Bug
Status: In Review (View Workflow)
Priority: Trivial
Resolution: Unresolved
Affects Version/s: 10.5(EOL)
Fix Version/s: 10.6
Component/s: Server, Storage Engine - InnoDB
Labels:
- foundation

Sprint:
Sprint 7 (07.04.2025), Sprint 8 (21.04.2025), Sprint 9 (05.05.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

MDEV-27461 Server hangs when the bufferpool is shrunk to 8M and innodb_page_size=64K

Closed

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

Closed

Activity

People

Assignee:: Daniel Black

Reporter:: Rich Meese

Votes:: 0 Vote for this issue

Watchers:: 4 Start watching this issue

Dates

Created:: 2025-01-20 11:30

Updated:: 2025-06-12 13:28

Time Tracking

Estimated:

Remaining:

Logged:

Git Integration

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