On 11-09-19 06:39 PM, Anthony wrote:
On Mon, Sep 19, 2011 at 3:57 PM, Brion Vibber brion@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]