On 11-09-19 06:39 PM, Anthony wrote: > On Mon, Sep 19, 2011 at 3:57 PM, Brion Vibber <br...@pobox.com> wrote: >> That's probably the simplest solution; adding a new empty table will be very >> quick. It may make it slower to use the field though, depending on what all >> uses/exposes it. > Isn't adding a new column with all NULL values quick too? Apparently in InnoDB a table ALTER requires an entire copy of the table to do. In other words to do a table alter every box doing it needs to be able to hold the entire Wikipedia revision table twice to add a new column. ...InnoDB also doesn't generally like to give disk space back to the disk when it's done using it.
~Daniel Friesen (Dantman, Nadir-Seen-Fire) [http://daniel.friesen.name] _______________________________________________ Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l