Increase max columns per key to 32
(Blueprint obsoleted by Rich's request)
Queries sometimes get much better performance when the index that is used covers the query. Storage engines like InnoDB and TokuDB store the primary key as part of the secondary key. When a query needs the values of columns that are not in the key, the storage engine does a primary key lookup for each secondary key read. This can really tank performance.
MySQL supports 16 columns per key. This patch increases the number of columns per key to 32, which allows one to increase the scope of queries that are covered by the secondary key.
https:/
and
https:/
Blueprint information
- Status:
- Not started
- Approver:
- None
- Priority:
- Not
- Drafter:
- None
- Direction:
- Needs approval
- Assignee:
- None
- Definition:
- New
- Series goal:
- None
- Implementation:
- Unknown
- Milestone target:
- None
- Started by
- Completed by