Parallel fast index creation

Registered by Alexey Kopytov on 2013-01-31

When doing fast index creation for multiple indexes InnoDB first reads the clustered index and creates temporary files containing unsorted index entries, one file per index. It then sorts those files one-by-one using the merge buffer (which is tunable in Percona Server) and another temporary file. It is possible to do that sorting in multiple threads. Naturally, with N threads it would require (N-1) more temporary files and (N-1) more merge buffers.

This is to implement an InnoDB alternative to myisam-repair-threads, i.e. multi-threaded fast index creation.

Blueprint information

Status:
Not started
Approver:
Vadim Tkachenko
Priority:
Medium
Drafter:
Alexey Kopytov
Direction:
Needs approval
Assignee:
None
Definition:
Pending Approval
Series goal:
None
Implementation:
Unknown
Milestone target:
None

Related branches

Sprints

Whiteboard

(?)

Work Items

This blueprint contains Public information 
Everyone can see this information.

Subscribers

No subscribers.