Could you give us some tips on how to improve CREATE INDEX performance on InnoDB?
Some secondary questions that might help to answer question above:
- Is it faster to define indexes in the CREATE TABLE before loading data OR declare one ALTER TABLE per table with indexes after the load? or …
- Are there innodb parameters that affect CREATE INDEX speed?