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
: 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
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 Hudson; MySQL List
Subject: Re: adding columns to a large
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
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 apporx
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