Index-only prefix index queries

Registered by Laurynas Biveinis on 2017-03-10

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 on 2017-03-10
Completed by
Laurynas Biveinis on 2017-03-20

Related branches

Sprints

Whiteboard

(?)

Work Items

This blueprint contains Public information 
Everyone can see this information.

Subscribers

No subscribers.