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, adding, deleting rows that would affect the index.
Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
