On Mon, 2006-09-25 at 15:27 +0530, Mugunthan SIFY wrote:
> If you have enough disk space, create a temporary table with the four new
> columns. Insert into this table selecting records from the original table.
> Finally rename the tables.
isn't this resource intensive?
Then again, since the OP did already wait 24 hours, that must've loaded
the server as well.
> Hope this helps.
> -----Original Message-----
> From: Ehrwin Mina [mailto:ehrwin@stripped]
> Sent: Monday, September 25, 2006 12:35 PM
> To: Helen M Hudson; MySQL List
> Subject: Re: adding columns to a large table
> At 12:53 PM 9/25/2006, Helen M Hudson wrote:
> >I have a table with about 3million rows and I'm having trouble
> >altering it to add 4 more columns. I'm using the MySQL
> >Administrator and I've left it more than 24hours and its still not
> >finished. I was going to try using a login to the console next, but
> >is there a better way? Any advice much appreciated!
> >MySQL General Mailing List
> >For list archives: http://lists.mysql.com/mysql
> >To unsubscribe: http://lists.mysql.com/mysql?unsub=1
> Hi Helen,
> I would like to know what type of engine your using in mysql?
> Is it mysisam or innodb?
> thank you,
> Ehrwin C. Mina
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> ********** DISCLAIMER **********
> Information contained and transmitted by this E-MAIL is proprietary to
> Sify Limited and is intended for use only by the individual or entity to
> which it is addressed, and may contain information that is privileged,
> confidential or exempt from disclosure under applicable law. If this is a
> forwarded message, the content of this E-MAIL may not have been sent with
> the authority of the Company. If you are not the intended recipient, an
> agent of the intended recipient or a person responsible for delivering the
> information to the named recipient, you are notified that any use,
> distribution, transmission, printing, copying or dissemination of this
> information in any way or in any manner is strictly prohibited. If you have
> received this communication in error, please delete this mail & notify us
> immediately at admin@stripped
> Watch the latest updates on Mumbai, with video coverage of news, events,
> Bollywood, live darshan from Siddhivinayak temple and more, only on
> Watch the hottest videos from Bollywood, Fashion, News and more only on