New answers tagged alter-table
You're using mysql 5.1, This means the only engines you'll have available are MyISAM or innodb. in both cases adding a new column, regardless of nullability will require a complete, blocking, table rebuild during alter table. You maybe be able to use the pt-online-schema change tool that does some tricks to rebuild the table in a less blocking manner but ...
Top 50 recent answers are included