Bug #89994 INDEX DIRECTORY shown as valid option for InnoDB table creation
Submitted: 9 Mar 17:17 Modified: 4 Jun 18:34
Reporter: Claudio Nanni Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.7 OS:Any
Assigned to: CPU Architecture:Any

[9 Mar 17:17] Claudio Nanni
Description:
The page: https://dev.mysql.com/doc/refman/5.7/en/partitioning-overview.html

Claims:

"DATA DIRECTORY and INDEX DIRECTORY are not supported for individual partitions or subpartitions of MyISAM tables on Windows. They are supported for individual partitions and subpartitions of InnoDB tables (as on all platforms)."

But InnoDB doesn't have separate files for INDEX.

mysql> SELECT VERSION();
+------------+
| VERSION()  |
+------------+
| 5.7.10-log |
+------------+
1 row in set (0.00 sec)

mysql> CREATE TABLE t( a INT, b INT ) ENGINE=InnoDB PARTITION BY RANGE( a ) SUBPARTITION BY HASH( b ) SUBPARTITIONS 5 ( PARTITION p101 VALUES LESS THAN (102) DATA DIRECTORY = '/tmp/data' INDEX DIRECTORY = '/tmp/index' );
ERROR 1031 (HY000): Table storage engine for 't' doesn't have this option

mysql> show warnings;                                                                                                                                 +---------+------+--------------------------------------------------------+
| Level   | Code | Message                                                |
+---------+------+--------------------------------------------------------+
| Warning | 1478 | InnoDB: INDEX DIRECTORY is not supported               |
| Error   | 1031 | Table storage engine for 't' doesn't have this option |
+---------+------+--------------------------------------------------------+
2 rows in set (0.00 sec)

How to repeat:
Read the manual

Suggested fix:
Update the manual
[9 Mar 21:31] Miguel Solorzano
Thank you for the bug report.
[4 Jun 18:34] Daniel Price
Posted by developer:
 
The referenced documentation has been updated. The change should appear online soon.

Thank you for the bug report.