MySQL Bugs: #74103: Remove index name lookups during DML

Bug #74103	Remove index name lookups during DML
Submitted:	26 Sep 2014 9:57	Modified:	2 Oct 2014 14:07
Reporter:	Marko Mäkelä	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: InnoDB storage engine	Severity:	S3 (Non-critical)
Version:	5.7.5	OS:	Any
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
For fulltext indexes, there is a special index name FTS_DOC_ID_INDEX that is being looked up during DML operations. A pointer to this special index could be cached at DDL time to avoid the costly lookups.

How to repeat:
Read the code.

Suggested fix:
Introduce dict_index_t::fts_doc_id_index that will point to the special index when fulltext indexes exist.

Posted by developer:
 
Fixed as of the upcoming 5.7.6 release, and here's the changelog entry:

For "FULLTEXT" indexes, a lookup for a special index named
"FTS_DOC_ID_INDEX" would be performed during DML operations. To avoid the
costly lookups, a pointer to "FTS_DOC_ID_INDEX" is now cached at DDL time.