Hudson
Cc: MySQL List
Sent: Monday, September 25, 2006 1:23 PM
Subject: Re: adding columns to a large table
There must be some thing went wrong with your settings in my.cnf file.For an
3 million records 24 hrs is bad :(
> myisam_sort_buffer_size value in my.cnf ?
Also you can app
There must be some thing went wrong with your settings in my.cnf
file.For an 3 million records 24 hrs is bad :(
> |myisam_sort_buffer_size value in my.cnf ?
Also you can apporx check the status by doing file size check on the
table in database dir and the temoprory table created in the data ba
, since the OP did already wait 24 hours, that must've loaded
the server as well.
> Hope this helps.
>
> Regards,
> S.Mugunthan
>
> -Original Message-
> From: Ehrwin Mina [mailto:[EMAIL PROTECTED]
> Sent: Monday, September 25, 2006 12:35 PM
> To: Helen M Hudso
: 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
>Adm
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,
