Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
10.11.10, 10.11.11
-
None
-
Red Hat Enterprise Linux 9.5, Rocky Linux 9.5
Description
According to https://mariadb.com/kb/en/innodb-system-variables/#innodb_log_buffer_size, the valid range for innodb_log_buffer_size is 262144 to 2147482624 (256KB to 2048MB). However when setting
innodb_log_buffer_size = 2147482624
|
in the configuration file, I receive during MariaDB restart the following message in the log file:
2025-02-26 22:50:54 0 [Warning] option 'innodb-log-buffer-size': unsigned value 2147482624 adjusted to 2147479552
|
And using
innodb_log_buffer_size = 2048M
|
in the configuration file leads to the following in the log file:
2025-02-26 22:54:32 0 [Warning] option 'innodb-log-buffer-size': unsigned value 2147483648 adjusted to 2147479552
|
Why is that? Is this a bug in the code or in the documentation? From my understanding 2G = 2048M = 2147483648
Attachments
Issue Links
- is caused by
-
MDEV-33585 The maximum innodb_log_buffer_size is too large
-
- Closed
-
Seems from the previous change in code https://github.com/MariaDB/server/pull/3172 , the maximum is what it is rounded to - 2GiB - 4KiB.
Updating the documentation now.
Thanks for the bug report.