Problems with IndexMemory in config.ini
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?
Subject
Views
Written By
Posted
Problems with IndexMemory in config.ini
3517
January 12, 2010 10:18AM
1720
January 12, 2010 04:18PM
1608
January 19, 2010 03:32AM
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.