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
-
Activity
Field | Original Value | New Value |
---|---|---|
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
{noformat} innodb_log_buffer_size = 2147482624 {noformat} 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 {noformat} innodb_log_buffer_size = 2048M {noformat} in the configuration file leads to the following in the log file: {noformat} 2025-02-26 22:54:32 0 [Warning] option 'innodb-log-buffer-size': unsigned value 2147483648 adjusted to 2147479552 {noformat} Why is that? Is this a bug in the code or in the documentation? From my understanding 2G = 2048M = 2147483648 |
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
{noformat} innodb_log_buffer_size = 2147482624 {noformat} 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 {noformat} innodb_log_buffer_size = 2048M {noformat} in the configuration file leads to the following in the log file: {noformat} 2025-02-26 22:54:32 0 [Warning] option 'innodb-log-buffer-size': unsigned value 2147483648 adjusted to 2147479552 {noformat} Why is that? Is this a bug in the code or in the documentation? From my understanding 2G = 2048M = 2147483648 |
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
{noformat} innodb_log_buffer_size = 2147482624 {noformat} 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 {noformat} innodb_log_buffer_size = 2048M {noformat} in the configuration file leads to the following in the log file: {noformat} 2025-02-26 22:54:32 0 [Warning] option 'innodb-log-buffer-size': unsigned value 2147483648 adjusted to 2147479552 {noformat} Why is that? Is this a bug in the code or in the documentation? From my understanding 2G = 2048M = 2147483648 |
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
{noformat} innodb_log_buffer_size = 2147482624 {noformat} in the configuration file, I receive during MariaDB restart the following message in the log file: {noformat} 2025-02-26 22:50:54 0 [Warning] option 'innodb-log-buffer-size': unsigned value 2147482624 adjusted to 2147479552 {noformat} And using {noformat} innodb_log_buffer_size = 2048M {noformat} in the configuration file leads to the following in the log file: {noformat} 2025-02-26 22:54:32 0 [Warning] option 'innodb-log-buffer-size': unsigned value 2147483648 adjusted to 2147479552 {noformat} Why is that? Is this a bug in the code or in the documentation? From my understanding 2G = 2048M = 2147483648 |
Link |
This issue is caused by |
Assignee | Daniel Black [ danblack ] |
issue.field.resolutiondate | 2025-02-26 22:32:41.0 | 2025-02-26 22:32:41.023 |
Component/s | Documentation [ 10903 ] | |
Fix Version/s | N/A [ 14700 ] | |
Resolution | Fixed [ 1 ] | |
Status | Open [ 1 ] | Closed [ 6 ] |