MySQL Forums :: Newbie :: adding index to a table


Advanced Search

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

Folks,
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


Subject Written By Posted
adding index to a table tekion tekion 02/12/2010 08:53PM
Re: adding index to a table Rick James 02/13/2010 11:25PM
Re: adding index to a table tekion tekion 02/15/2010 10:39AM
Re: adding index to a table Rick James 02/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.