O'Reilly logo
  • Ashwin Konireddy thinks this is interesting:

For larger tables, an ALTER statement can takes hours, or even days, to complete!

From

Cover of Effective MySQL Optimizing SQL Statements

Note

Alter statements cautions on production