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
_________________________________________________________________
Find high-speed ‘net deals — comparison-shop your local providers here. https://broadband.msn.com
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
