From: Devananda
Date: July 12 2004 8:36pm
Subject: importance of IndexMemory
List-Archive: http://lists.mysql.com/cluster/121
Message-Id: <40F2F667.3030003@neopets.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

Hi again :)

While I'm playing around with config.ini and super-smack, I've been 
trying to figure out how to increase the load that my cluster could 
handle ... for a while I've been stuck with about 400k rows. I've been 
adjusting DataMemory, but hadn't gotten any improvement. I just lowered 
DataMemory to 256M and increased IndexMemory to 256M and went up to 2mil 
rows! (each cluster machine has 1G ram). Thought I'd share with everyone 
the lesson learned: Index Memory is very important :)

Cheers,
Devananda