Bug #68959 minimal value of innodb_buffer_pool_size is 5MB
Submitted: 15 Apr 2013 5:00 Modified: 17 Apr 2013 14:10
Reporter: tsubasa tanaka (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.5.30, 5.6.10 OS:Any
Assigned to: Paul DuBois CPU Architecture:Any

[15 Apr 2013 5:00] tsubasa tanaka
Description:
Minimal value of innodb_buffer_pool_size is described 1MB in Docs.

http://dev.mysql.com/doc/refman/5.6/en/innodb-parameters.html#sysvar_innodb_buffer_pool_si...

http://dev.mysql.com/doc/refman/5.5/en/innodb-parameters.html#sysvar_innodb_buffer_pool_si...

But its minimal size is defined 5 * 1024 * 1025 in storage/innobase/handler/ha_innodb.cc.

static MYSQL_SYSVAR_LONGLONG(buffer_pool_size, innobase_buffer_pool_size,
  PLUGIN_VAR_RQCMDARG | PLUGIN_VAR_READONLY,
  "The size of the memory buffer InnoDB uses to cache data and indexes of its tables.",
  NULL, NULL, 128*1024*1024L, 5*1024*1024L, LONGLONG_MAX, 1024*1024L);

How to repeat:
See description.

Suggested fix:
Fix docs describe.
[15 Apr 2013 6:37] tsubasa tanaka
> But its minimal size is defined 5 * 1024 * 1025 in storage/innobase/handler/ha_innodb.cc.

It's my mistake of 5 * 1024 * 1024.

Error log.
130415 13:08:06 [Warning] option 'innodb-buffer-pool-size': signed value 1048576 adjusted to 5242880

(gdb) p *optp
$11 = {name = 0xf93e58 "innodb-buffer-pool-size", id = 0, 
  comment = 0x9d0278 "The size of the memory buffer InnoDB uses to cache data and indexes of its tables.", value = 0xf5cdc8, 
  u_max_value = 0xf5cdc8, typelib = 0x0, var_type = 7, arg_type = REQUIRED_ARG, def_value = 134217728, min_value = 5242880, 
  max_value = 9223372036854775807, sub_size = 0, block_size = 1048576, app_type = 0xebc3c0}
[15 Apr 2013 7:42] MySQL Verification Team
Hello tsubasa,

Thank you for the report.
Verified as described.

Regards,
Umesh
[17 Apr 2013 14:10] Paul DuBois
Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly, and will be included in the next release of the relevant products.