Looking more into the problem it looks like the problem is in documentation which does NOT mention expand_index_creation variable:
mysql> show variables like "expand_fast_index_creation";
+----------------------------+-------+
| Variable_name | Value |
+----------------------------+-------+
| expand_fast_index_creation | OFF |
+----------------------------+-------+
1 row in set (0.00 sec)
By the way any reason to still keep it OFF by default ?
Looking more into the problem it looks like the problem is in documentation which does NOT mention expand_ index_creation variable:
mysql> show variables like "expand_ fast_index_ creation" ; ------- ------- ------- -+----- --+ ------- ------- ------- -+----- --+ fast_index_ creation | OFF | ------- ------- ------- -+----- --+
+------
| Variable_name | Value |
+------
| expand_
+------
1 row in set (0.00 sec)
By the way any reason to still keep it OFF by default ?