… affected (0.00 sec) mysql> ALTER TABLE t ADD COLUMN v VARCHAR(1); Query OK, 4194304…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… UNIQUE index on non-nullable columns when the table has no PRIMARY KEY …
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…, and watch out for NULLable columns. Use smallint … the downtime caused by ALTER TABLE — a typical reason to…add them. Did this gain us anything? We dropped one column, and we just moved those other values around to store them…table (somehow the image of putting columns next to each other makes…
