MySQL Forums
Forum List  »  Performance

Index rebuilt every time?
Posted by: Sunni Sukumar
Date: September 30, 2005 03:18PM

Hi guys,

Is an index rebuilt from scratch every time additional INSERTs are done into the table it is defined on? Or are additional nodes simply added into the existing index? (Standard MyISAM table)

And is it faster to run DISABLE KEYS before doing a bunch (~4 million at a time, in my case) of INSERTs, and then ENABLE KEYS at the end? Or should I let the index creation go on simultaneously with the INSERTs? I ask because I've seen mysqldump's SQL code always DISABLE KEYS and then ENABLE KEYs after all of the INSERTs.

I apologize if these sound like dumb questions. I'm somewhat new to MySQL performance optimization, yet I'm working on tables up to ~125,000,000 rows in size for a critical work project.


Thank you sincerely for your time and insights,

Sunni

Options: ReplyQuote


Subject
Views
Written By
Posted
Index rebuilt every time?
1767
September 30, 2005 03:18PM


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.