Bug #70898 Manual declares size in KB valid for innodb_data_file_path, but it does not work
Submitted: 13 Nov 2013 16:37 Modified: 28 Nov 2013 19:30
Reporter: Elena Stepanova Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.1, 5.5, 5.6 OS:Any
Assigned to: Daniel Price CPU Architecture:Any

[13 Nov 2013 16:37] Elena Stepanova
Description:
The manual (http://dev.mysql.com/doc/refman/5.6/en/innodb-parameters.html#sysvar_innodb_data_file_path) says:

<quote>
innodb_data_file_path
...
The file sizes are specified in KB, MB, or GB (1024MB) by appending K, M, or G to the size value. 
</quote>

But it does not work. If the file is specified in KB, InnoDB fails to start with the error:

2013-11-13 20:35:26 6308 [ERROR] InnoDB: syntax error in innodb_data_file_path
2013-11-13 20:35:26 6308 [ERROR] Plugin 'InnoDB' init function returned error.
2013-11-13 20:35:26 6308 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

I set it as a documentation bug since I suppose it isn't really worth fixing on the server/InnoDB side. 

How to repeat:
start server with e.g. --innodb-data-file-path="ibdata1:20480K:autoextend"
[13 Nov 2013 18:14] MySQL Verification Team
This proved to be quite correct !!

Verified as described.
[15 Nov 2013 14:44] Daniƫl van Eeden
Isn't this a duplicate of Bug #68282?
[28 Nov 2013 19:30] Daniel Price
The documentation has been updated for 5.1, 5.5, 5.6, and 5.7 versions of the reference manual. Mention of support for specifying innodb_data_file_path size in KBs has been removed.  

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

The change will appear in the next day or so in the next published documentation build.

Thank you for the bug report.