[OSM-dev] ROMA servers down - osmosis large way problem

Tom Hughes tom at compton.nu
Sat Jan 10 18:37:33 GMT 2009


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 (tom at compton.nu)
http://www.compton.nu/




More information about the dev mailing list