MySQL Forums
Forum List  »  NDB clusters

Problems with IndexMemory in config.ini
Posted by: Francesco Formizzi
Date: January 12, 2010 10:18AM

Hi, I've a problem with the setting of IndexMemory.
This is my config.ini:

[ndbd default]
NoOfReplicas= 2
MaxNoOfConcurrentOperations= 10000
DataMemory= 300M
IndexMemory= 100M
DiskPageBufferMemory=242M
TimeBetweenWatchDogCheck= 30000
datadir= /app/home/mysql/cluster2
#/var/lib/mysql-cluster
MaxNoOfOrderedIndexes= 512
MaxNoOfExecutionThreads=8

#LockPagesInMainMemory=2

[ndb_mgmd default]
DataDir= /var/lib/mysql-cluster

[ndb_mgmd]
Id= 1
HostName= 10.214.130.17
datadir= /app/home/mysql/mgt01/data

[ndbd]
id= 2
HostName= 10.214.130.17
DataDir= /app/home/mysql/ndb01/data

[ndbd]
id= 3
HostName= 10.214.130.17
DataDir= /app/home/mysql/ndb02/data

[mysqld]
id= 4
HostName= 10.214.130.17

[mysqld]
id= 5

[tcp default]
PortNumber= 63132


And this is the result of ALL DUMP 1000:

-- NDB Cluster -- Management Client --
ndb_mgm> ALL DUMP 1000
Connected to Management Server at: localhost:1186
Sending dump signal with data:
0x000003e8 Sending dump signal with data:
0x000003e8
Node 2: Index usage is 3%(118 8K pages of total 3232)
ndb_mgm> Node 2: Index usage is 12%(407 8K pages of total 3232)
Node 2: Index usage is 31%(1026 8K pages of total 3232)
Node 2: Index usage is 0%(20 8K pages of total 3232)
Node 2: Data usage is 18%(1752 32K pages of total 9600)
Node 3: Index usage is 3%(118 8K pages of total 3232)
Node 3: Index usage is 12%(407 8K pages of total 3232)
Node 3: Index usage is 31%(1026 8K pages of total 3232)
Node 3: Index usage is 0%(20 8K pages of total 3232)
Node 3: Data usage is 18%(1752 32K pages of total 9600)


If I calculate the dimension of Index Memory it's not 100M, but only 25M, and I don't know why I've 4 rows for IndexMemory.
This is not correct for me, 'cause I've an "OUT OF MEMORY" when tHe Index Usage is at 25M...

Can you explain me how it's work IndexMemory in mysql Cluster? Can I set 'only 1 row' with 100M of IndexMemory?

Options: ReplyQuote


Subject
Views
Written By
Posted
Problems with IndexMemory in config.ini
3517
January 12, 2010 10:18AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.