duplicate the table structure, add the column to the new table, import the records into the table. this should be faster based on my experience and also will not disturb your transactions :)
On Feb 17, 2012, at 8:21 AM, Angela liu wrote: > Hi, Folk: > > I will need to add a column to a huge mysql table, this table is about 77GB, > and has thousands of millions rows. > > any idea I can make this alter table faster? > > Thanks > > Angela Willy Mularto F300HD+MR18DE (NLC1725) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
