…table. No matter if it’s InnoDB or MyISAM, you’d usually ALTER TABLE `huge_table`…table with desired table structure and switch .frm table definition files. For safety, I’d recommend to flush tables with read lock while switching .frm files… does not work that way. Enum values (add and remove). …
Comment: Hacking to make ALTER TABLE online for certain changes
October 30, 2007 By 26 Comments
…be nice if other ALTER TABLE commands which didn’t strictly need a rebuild didn… not require a table rebuild. Likewise, a change of an ENUM column to add more ENUM values shouldn’t … ALTER to a similar, empty table, then copying the .frm file (this requires the table to be closed with a FLUSH TABLES) …
Post: Using MMM to ALTER huge tables
March 27, 2008 By 11 Comments
…remove auto_increment or change ENUM values. When it comes to changes that really require table to be rebuilt – …must be executed on db2 so better use mysql file socket, or real IP of the node, but not…to db1 at this stage. If you’re altering gigabyte size tables, this step may take some time. Go get…
