MySQL Bugs: #69439: Documented minimal value of innodb_log_file

Bug #69439	Documented minimal value of innodb_log_file_size is wrong in 5.1 and 5.5
Submitted:	11 Jun 2013 9:00	Modified:	11 Jun 2013 14:15
Reporter:	Tsubasa Tanaka (OCA)	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Documentation	Severity:	S3 (Non-critical)
Version:	5.1.70, 5.5.32	OS:	Any
Assigned to:	Bugs System	CPU Architecture:	Any

Description:
The variable range of innodb_log_file_size is described 108576 .. 4294967295 in docs.
But actually, its lower limit is setted 1048576.

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

in mysql-5.1.70/storage/innobase/handler/ha_innodb.cc

   9283 static MYSQL_SYSVAR_LONGLONG(log_file_size, innobase_log_file_size,
   9284   PLUGIN_VAR_RQCMDARG | PLUGIN_VAR_READONLY,
   9285   "Size of each log file in a log group.",
   9286   NULL, NULL, 5*1024*1024L, 1*1024*1024L, LONGLONG_MAX, 1024*1024L);

in mysql-5.5.32/storage/innobase/handler/ha_innodb.cc

  11576 static MYSQL_SYSVAR_LONGLONG(log_file_size, innobase_log_file_size,
  11577   PLUGIN_VAR_RQCMDARG | PLUGIN_VAR_READONLY,
  11578   "Size of each log file in a log group.",
  11579   NULL, NULL, 5*1024*1024L, 1*1024*1024L, LONGLONG_MAX, 1024*1024L);

How to repeat:
Set --innodb-log-file-size=108576 and run mysqld, you can get as following in your error-log.

130611 17:55:37 [Warning] option 'innodb-log-file-size': signed value 108576 adjusted to 1048576

Suggested fix:
Fix docs.

Hello tsubasa,

Thank you for the report.
Verified as described.

5.5 docs need correction - http://dev.mysql.com/doc/refman/5.5/en/innodb-parameters.html#sysvar_innodb_log_file_size

Thanks,
Umesh

The minimum value for innodb_log_file_size in the 5.5 reference manual has been corrected.

Thank you for the bug report.