Hello, I have a fairly active and large DB. I need to create a new index on a column. It will take (just guessing) 15-30 minutes for the entire creation. I've got different people hittiing this table all the time, mostly with new inserts (not really any updates). My question is:
Can I create this new index without locking the table, or should I lock it? Thanks! --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php