Re: Rebuild Indexes Online after Insert/Update
Maybe I'm just not understanding how MySQL works. I thought indexes are modified every time a new record is inserted. I'm told this takes the table offline for writes while the indexes rebuild. For a table with millions of records, it will take some time to rebuild the indexes, no? This seems to be causing insert/update timeout issues on that table.
Subject
Views
Written By
Posted
6045
January 20, 2010 12:15PM
2509
January 21, 2010 03:00PM
Re: Rebuild Indexes Online after Insert/Update
3003
January 21, 2010 03:04PM
5993
January 21, 2010 06:35PM
2446
January 21, 2010 09:20PM
2402
January 21, 2010 11:56PM
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.