MySQL: Slow schema updates on empty tables with InnoDB -


i have collection of scripts migrating db schema latest version. developments , testing regularly apply them @ once, operating on empty tables since there no data.

this process painfully slow since started using innodb. single alter table operation takes ~0.1s myisam ~0.5s innodb. tried disabling foreign key checks, doesn't much. there else can try speed things up?

(i tried creating schema using myisam , migrating way lose foreign keys.)

the default values innodb shockingly guant. if give my.cnf reasonable values, may speed innodb in general, , may have positive impact on schema updates too.


Comments