On Mon, Oct 22, 2012 at 10:01 PM, Walter Underwood
<[email protected]> wrote:
> First, stop optimizing. You do not need to manually force merges. The system
> does a great job. Forcing merges (optimize) uses a lot of CPU and disk IO and
> might be the cause of your problem.
>
Thanks. Looking at the index statistics, I see that within minutes
after running optimize that the stats say the index needs to be
reoptimized. Though, the index still reads and writes fine even in
that state.
> Second, the OS will use the "extra" memory for file buffers, which really
> helps performance, so you might not need to do anything. This will work
> better after you stop forcing merges. A forced merge replaces every file, so
> the OS needs to reload everything into file buffers.
>
I don't see that the memory is being used:
$ free -g
total used free shared buffers cached
Mem: 14 2 12 0 0 1
-/+ buffers/cache: 0 14
Swap: 0 0 0
--
Dotan Cohen
http://gibberish.co.il
http://what-is-what.com