June 19, 2013

Post: Improved InnoDB fast index creation

November 6, 2011 By 4 Comments

…table size. mysql> SET expand_fast_index_creation=ON; Query OK, 0 rows affected (0.00 sec) mysql> ALTER TABLE t MODIFY…table rebuild on foreign key changes. So adding them back with a separate ALTER TABLE after restoring the data from a dump would actually make…non-nullable columns when the table has …

Filed Under: Benchmarks, Insight for DBAs, MySQL