Indexing Performance Problem

2005-06-08 Thread roi h
Hi. I need to index about 300 million 20-byte records, but it takes forever (it isn't finished yet, after almost 24 hours, so I don't have actual numbers). I'm using RHEL, kernel 2.6.9, Mysql 4.1.11, MyISAM table, on a dual Xeon with 4GB RAM and IDE disks. I'm using the following values from

Indexing implementation

2005-06-08 Thread roi h
Hi, Another question, to help me better understand MySQL indexing: In MyISAM, does DISABLE INDEX followed by insertions and then ENABLE INDEX freeze the original index and batch-updates it, or does it drop it completely and recreate it from scratch? --thanks, Roi -- MySQL General Mailing List