[MDEV-27467] innodb to enfore the minimum innodb_buffer_pool_size in SET (resize) the same as startup Created: 2022-01-11  Updated: 2022-05-05  Resolved: 2022-01-19

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB
Affects Version/s: 10.2.41
Fix Version/s: 10.2.42, 10.3.33, 10.4.23, 10.5.14, 10.6.6, 10.7.2

Type: Bug Priority: Major
Reporter: Daniel Black Assignee: Daniel Black
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Problem/Incident
causes MDEV-28471 INSTALL ERROR Innodb engine settings ... Closed
Relates
relates to MDEV-27461 Server hangs when the bufferpool is s... Closed

 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.



 Comments   
Comment by Daniel Black [ 2022-01-18 ]

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

Comment by Marko Mäkelä [ 2022-01-18 ]

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

Generated at Thu Feb 08 09:53:08 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.