Index-only prefix index queries

Registered by Laurynas Biveinis

https://github.com/percona/percona-server/pull/1505

For prefix indexes, InnoDB always fetches the clustered index record, even if record length is less than the prefix length. Optimise this case by avoiding the clustered index read.

This is a Facebook patch feature:
https://github.com/webscalesql/webscalesql-5.6/commit/3277028169fa336f718bbdb2ae4417f722ebf0f4
or
https://github.com/facebook/mysql-5.6/commit/5f9e36706fee7295b3ba736899717cf57bfb9859

See also https://mariadb.atlassian.net/browse/MDEV-6929

Blueprint information

Status:
Complete
Approver:
Laurynas Biveinis
Priority:
Medium
Drafter:
Laurynas Biveinis
Direction:
Approved
Assignee:
Laurynas Biveinis
Definition:
Approved
Series goal:
Accepted for 5.6
Implementation:
Implemented
Milestone target:
milestone icon 5.6.36-82.0
Started by
Laurynas Biveinis
Completed by
Laurynas Biveinis

Related branches

Sprints

Whiteboard

(?)

Work Items

This blueprint contains Public information 
Everyone can see this information.

Subscribers

No subscribers.