Re: how to add index

2008-02-15 Thread mos
At 07:55 AM 2/15/2008, you wrote: Hi lists, I have innodb tables with millions of records. How can i add index without locking the table. Saravanan Saravanan, I don't see any way of doing it without locking the table. Otherwise as the index is being built, user's would be modifying, add

how to add index

2008-02-15 Thread Saravanan
Hi lists, I have innodb tables with millions of records. How can i add index without locking the table. Saravanan Never miss a thing. Make Yahoo your home page. http://www.yahoo.com/r/hs -- MySQL Ge