Re: Optimizing frequently updated index

2007-05-30 Thread Chris Hostetter
: I have an index that is updated fairly frequently (every few seconds), and : I'm replicating to several slave servers. how often do you replicate? : I was wondering if it make sense to replicate to a slave instance, optimize : it there, and then distribute the optimized index from the first le

Optimizing frequently updated index

2007-05-29 Thread Tom Hill
Hi - I have an index that is updated fairly frequently (every few seconds), and I'm replicating to several slave servers. Because of the frequent updates, I'm usually pushing an index that is not optimized. And, as it takes several minutes to optimize, I don't want to do it every time I replicat