From: Johan Andersson
Date: November 4 2011 12:01pm
Subject: Re: change in mysql cluster config file
List-Archive: http://lists.mysql.com/cluster/8156
Message-Id: <4EB3D42F.8030606@severalnines.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

You need to increase IndexMemory and DataMemory.

johan

On 2011-11-04 12.56, Ridd1ck wrote:
> And When i try to engine=ndb with alter table command
> Cluster Managment say's:
> Node 3: Index usage increased to 84%(1965 8K pages of total 2336)
> Node 3: Data usage increased to 82%(2117 32K pages of total 2560)
> Node 2: Data usage increased to 83%(2131 32K pages of total 2560)
> Node 3: Index usage increased to 90%(2115 8K pages of total 2336)
> Node 2: Index usage increased to 91%(2126 8K pages of total 2336)
> Node 2: Data usage increased to 90%(2316 32K pages of total 2560)
> Node 3: Data usage increased to 93%(2394 32K pages of total 2560)
> Node 3: Index usage increased to 99%(2319 8K pages of total 2336)
> Node 2: Index usage increased to 99%(2329 8K pages of total 2336)
> Node 3: Data usage decreased to 1%(31 32K pages of total 2560)
> Node 3: Index usage decreased to 1%(39 8K pages of total 2336)
> Node 2: Data usage decreased to 1%(31 32K pages of total 2560)
> Node 2: Index usage decreased to 1%(39 8K pages of total 2336)
>
>
> --
> View this message in context: http://mysql-cluster.1050023.n4.nabble.com/change-in-mysql-cluster-config-file-tp3984963p3989791.html
> Sent from the MySQL - Cluster mailing list archive at Nabble.com.
>