Interrupt ALTER Process

Hi,
I have an InnoDB with 12 millions of data. For some reason I need to =
alter the table structure by expanding the varchars value. It's been an =
hour and slow down the performance. Is it safe to kill the process? =
Thanks.



Willy=

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

RE: Interrupt ALTER Process

Remember, the InnoDB table has a full table lock now since it is doing and =
ALTER TABLE.
You may want to kill it and try this instead:

In this example, the table with 12M rows is called BigTable

1) CREATE TABLE BigTable2 LIKE BigTable;
2) ALTER TABLE BigTable MODIFY COLUMN VARCHAR();
3) INSERT INTO BigTable2 SELECT * FROM BigTable;
4) DROP TABLE BigTable;
5) ALTER TABLE BigTable2 RENAME BigTable;

Give it a try !!!

Rolando A. Edwards
MySQL DBA (SCMDBA)

155 Avenue of the Americas, Fifth Floor
New York, NY 10013
212-625-5307 (Work)
201-660-3221 (Cell)
AIM & Skype : RolandoLogicWorx
redwards@logicworks.net
http://www.linkedin.com/in/rolandoedwards


-----Original Message-----
From: Willy Mularto [mailto:sangprabv@gmail.com]=20
Sent: Thursday, January 20, 2011 10:19 PM
To: mysql@lists.mysql.com
Subject: Interrupt ALTER Process

Hi,
I have an InnoDB with 12 millions of data. For some reason I need to alter =
the table structure by expanding the varchars value. It's been an hour and =
slow down the performance. Is it safe to kill the process? Thanks.



Willy
--=20
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dredwards@logicworks=
..net


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg