On Tue, Nov 13, 2001 at 10:28:53PM -0700, Karl J. Stubsjoen wrote: > 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!
MySQL will put a READ lock on the table automatically. -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 69 days, processed 1,536,800,396 queries (254/sec. avg) --------------------------------------------------------------------- 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