Joachim Zobel wrote: > Am Sonntag, den 28.12.2008, 18:00 -0500 schrieb Jeremy Adams: >> I ran the same command on my box about 4 hours ago and it's still >> cranking away. Should it really take that long to change a column >> type? It's got one of the CPU cores pegged, so I assume it's still >> doing something. > > An ALTER TABLE on MySQL always copies the whole table.
Indeed, just one of the many reasons why MySQL sucks giant boulders through exceedingly small straws. Tom -- Tom Hughes ([email protected]) http://www.compton.nu/ _______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/dev
