I run alter today on table with 380,000 records. 'Alter' was adding column to the table. It took 10 minutes and server load went up to 15.
"alter table info add column interactive_email enum('on','off') NOT NULL default 'on';"
Here comes my questions:
#1 If I kill the process after it was running for 5 minutes. Would it update some records and some records not?
#2 How dangerous is to stop alter?
#3 What is a good way to stop alter or update without damaging database?
Thanks
Mike,
"Alter" creates a copy of the table so stopping it in the middle won't hurt anything. If the Alter succeeds, it renames the new table to the old table name.
Mike
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
