So does it work as you expect once you turn on the expand_fast_index_creation?
I think we have a quite big confusion due to two similar but not really related features: 1) fast_index_creation that is enabled by default, [1], and I don't even get what's documented there - is this an upstream feature that we have option to disable? and 2) expanded_fast_index_creation that is disabled by default and seems actually to be required for ALTER TABLE etc. optimizations to actually work.
I think these two doc items should be rewritten to increase clarity and distinction between the features.
Peter -
So does it work as you expect once you turn on the expand_ fast_index_ creation?
I think we have a quite big confusion due to two similar but not really related features: 1) fast_index_creation that is enabled by default, [1], and I don't even get what's documented there - is this an upstream feature that we have option to disable? and 2) expanded_ fast_index_ creation that is disabled by default and seems actually to be required for ALTER TABLE etc. optimizations to actually work.
I think these two doc items should be rewritten to increase clarity and distinction between the features.
[1] www.percona. com/doc/ percona- server/ 5.5/management/ innodb_ fast_index_ creation. html com/doc/ percona- server/ 5.5/management/ innodb_ extended_ fast_index_ creation. html
[2] www.percona.