I am feeling more motivated to interrupt this operation now. What would
be an effective way to do that? As a reminder, I submitted this operation
using the GUI administration tool --- specifically the table editor. The
whole tool is unresponsive while this operation is running. I can run
The only way you can do it is with KILL. You will be able to see some
of the progress on rollback in SHOW INNODB STATUS. I recommend
innotop for watching this if you wish.
If you see the process's status as Killed in SHOW PROCESSLIST, you
have killed it.
Have a copy of War and Peace at the
I am new to MySQL, and wonder if I have done something terribly stupid. I
have an InnoDB table with 27 million rows. Without thinking very much, I
issued the following command through the GUI administration tool:
ALTER TABLE `wyky`.`externallinks` ADD COLUMN `el_p2` BLOB NOT NULL AFTER
Hi,
On Feb 19, 2008 5:20 PM, Mike Spreitzer [EMAIL PROTECTED] wrote:
I am new to MySQL, and wonder if I have done something terribly stupid. I
have an InnoDB table with 27 million rows. Without thinking very much, I
issued the following command through the GUI administration tool:
ALTER
Thanks, Baron. Yes, the table is bigger than memory. It took about 2.5
days to create the table, inserting about 7,000 rows at a time; this
column and index addition has been running for about a day now. I notice
you did not say it was terribly stupid to create this index before putting
the