MySQL Lists: mysql: best way to add a new column to a table with 60+ million records

List:	General Discussion	« Previous Message Next Message »
From:	Arun Kumar PG	Date:	April 16 2008 2:00pm
Subject:	best way to add a new column to a table with 60+ million records
View as plain text

hi,

is there any other best way add a new column to an existing table having 60+
million records. alter is taking more than 1.5 hours.. what are the best
practices around this. quick help will be appreciated.

-- 
cheers,

- a

Thread
• best way to add a new column to a table with 60+ million records	Arun Kumar PG	16 Apr
• Re: best way to add a new column to a table with 60+ million records	Arun Kumar PG	16 Apr
• Re: best way to add a new column to a table with 60+ million records	Moon's Father	26 May
• Re: best way to add a new column to a table with 60+ million records	Ananda Kumar	26 May