Optimizing MySQL for ALTER TABLE of InnoDB
- by schuilr
Sometime soon we will need to make schema changes to our production database. We need to minimize downtime for this effort, however, the ALTER TABLE statements are going to run for quite a while. Our largest tables have 150 million records, largest table file is 50G.
All tables are InnoDB, and it was set up as one big data file (instead of a…