MySQL Forums
Forum List  »  Newbie

adding index to a table
Posted by: tekion tekion
Date: February 12, 2010 08:53PM

I am trying to add a compound index on a table with 24 million rows. The index seems to be running too long and other queries such as insert and select seems be affected by the index I am trying to create. I am wondering if there is an option to add the index online in MySQL 5.0, this is assuming adding an index puts a lock on the table.

Options: ReplyQuote

Written By
adding index to a table
February 12, 2010 08:53PM
February 13, 2010 11:25PM
February 15, 2010 10:39AM
February 16, 2010 11:07AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.