Bug #72534 InnoDB max index length not correct
Submitted: 4 May 2014 19:40 Modified: 8 May 2014 13:33
Reporter: Daniël van Eeden (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.6 OS:Any
Assigned to: Daniel Price CPU Architecture:Any
Tags: INDEX, innodb

[4 May 2014 19:40] Daniël van Eeden 
Description:
This page:
http://dev.mysql.com/doc/refman/5.6/en/charset-unicode-upgrading.html
claims:
"InnoDB has a maximum index length of 767 bytes"

But this page 
http://dev.mysql.com/doc/refman/5.6/en/innodb-parameters.html#sysvar_innodb_large_prefix
claims:

"Enable this option to allow index key prefixes longer than 767 bytes (up to 3072 bytes), for InnoDB tables that use the DYNAMIC and COMPRESSED row formats."

So I presume the first one needs updating.

How to repeat:
Compare the two pages.
[5 May 2014 4:26] MySQL Verification Team 
Hello Daniel,

Thank you for the report.

Thanks,
Umesh
[8 May 2014 13:33] Daniel Price 
The documentation has been updated. The revised documentation will appear soon, with the next published documentation build.

http://dev.mysql.com/doc/refman/5.6/en/charset-unicode-upgrading.html
http://dev.mysql.com/doc/refman/5.7/en/charset-unicode-upgrading.html

Thank you for the bug report.