MySQL Bugs: #72961: Glossary for system tablespace does not take FTS in account

Bug #72961	Glossary for system tablespace does not take FTS in account
Submitted:	11 Jun 2014 18:58	Modified:	3 Jul 2014 17:46
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

Description:
According to Bug #72132 the FTS tables indexes are always created in the system tablespace.

But there is nothing about FTS in the glossary for 'system tablespace':
http://dev.mysql.com/doc/refman/5.6/en/glossary.html#glos_system_tablespace

How to repeat:
Compare docs with the bug report and/or code.

Suggested fix:
Update docs

Thank you for the bug report

FTS index tables should be created in their own individual tablespaces when innodb_file_per_table=ON, which was the case in MySQL 5.6.4. Due to a regression introduced in MySQL 5.6.5, FTS index tables were always created in the system tablespace. This bug is fixed in 5.6.20 and MySQL 5.7.5.

The incorrect behaviour is noted in the FULLTEXT Indexes section of the reference manual and in the "system tablespace" glossary entry.

http://dev.mysql.com/doc/refman/5.6/en/innodb-fulltext-index.html
http://dev.mysql.com/doc/refman/5.7/en/innodb-fulltext-index.html

http://dev.mysql.com/doc/refman/5.6/en/glossary.html#glos_system_tablespace
http://dev.mysql.com/doc/refman/5.7/en/glossary.html#glos_system_tablespace

The revised content should appear soon, with the next published documentation build.

Thank you for the bug report.