At 01:32 PM 7/20/2007, Andrew Rosolino wrote:
Whenever I alter a mysql table like add a new field it gets really slow and
all other processes lag.
Is there a memory variable I can adjust for this?
It may be slow because if it is rebuilding the indexes to the table. Don't
forget that when
Whenever I alter a mysql table like add a new field it gets really slow and
all other processes lag.
Is there a memory variable I can adjust for this?
--
View this message in context:
http://www.nabble.com/MySQL-slow-when-altering-tables.-tf4119161.html#a11714643
Sent from the MySQL - General
On Fri, July 20, 2007 12:32, Andrew Rosolino said:
Whenever I alter a mysql table like add a new field it gets really slow
and
all other processes lag.
Is there a memory variable I can adjust for this?
--
View this message in context:
Without more information it might be hard to answer. A
alter table hr-data set column Reason4leaving1 char(100)
I thought I knew - but I wanted to play safe. So I went to
http://mysql.com and entered alter table to the search box.
From the results list I chose ALTER TABLE Syntax:
http://www.mysql.com/doc/A/L/ALTER_TABLE.html
Here I found what I
Hi,
I dont know whats wrong with my mysql but when I add a column with auto_inc
(I just copied and paseted what you did) I got: Primary key cannot be NULL,
so, but I got it working So thanks anyway.
And as I always say... If something works, dont touch int.
So I wont reinstall.
/roger
Hi there,
Question:
Whats the Easiest way to insert an AUTO_INCREMENT column into an existing table,
the new field will take over the primary key and the index.
Hi I solved it my self.
If anyone whats to know the awnser to this it was NOT as easy as the manual
would have described.
The only thing I got to work was:
1. Drop the index
2. create new field (whitout index and auto_inc) if any of them where added
I got an error and nothing worked.
3. make the
On 21-Mar-01 roger westin wrote:
Hi there,
Question:
Whats the Easiest way to insert an AUTO_INCREMENT column into an existing
table,
the new field will take over the primary key and the index.
alter table da_table drop primary key, drop old_id;
alter table da_table add id int not
On 21-Mar-01 roger westin wrote:
Hi I solved it my self.
If anyone whats to know the awnser to this it was NOT as easy as the manual
would have described.
The only thing I got to work was:
1. Drop the index
2. create new field (whitout index and auto_inc) if any of them where added
I got