No more table metadata records (increase MaxNoOfTables)' from NDBCLUSTER

[prasanth katta]

Hi All, i am new to mysql cluster.i have mysql cluster setup on Ubuntu OS.i am facing problem while dumpig data to mysql cluster . when ever i dump the data (.sql which is of 800MB size and around 400 tbales) in to mysql cluster i am getting the following error "No more table metadata records (increase MaxNoOfTables)' from NDBCLUSTER"

i changed MaxNoOfTable parameter to max (20320) even though i am getting the same error.

here is my config.ini file
[ndb_mgmd]
NodeId=1
HostName=127.0.0.1 # This is an IP address of the cluster management node
#DataDir=/var/lib/mysql-cluster # This is a data directory for the cluster management node
#DataDir=/usr/local/mysql/mysql-cluster
DataDir=/usr/local/mysql/data
Portnumber=1186

[tcp default]
# TCP/IP options:
SendBufferMemory=8M
ReceiveBufferMemory=8M


[ndbd default]
#DataDir=/var/lib/mysql-cluster
#DataDir=/usr/local/mysql/mysql-cluster
DataDir=/usr/local/mysql/data
NoOfReplicas=1
MaxNoOfConcurrentOperations=40000
MaxNoOfConcurrentTransactions=30000
MaxNoOfAttributes=4G
MaxNoOfOrderedIndexes=4000M
MaxNoOfUniqueHashIndexes=2G
MaxNoOfTables=20320
MaxNoOfTriggers=4500
StringMemory=50
DataMemory=14G
IndexMemory=12G
DiskPageBufferMemory=2048M
SharedGlobalMemory=2024M
BackupMaxWriteSize=1000M
BackupReportFrequency=1000
MemReportFrequency=300
LogLevelStartup=15
LogLevelShutdown=15
LogLevelCheckpoint=8
LogLevelNodeRestart=15
LongMessageBuffer=128M
MaxNoOfConcurrentTransactions=16384
BatchSizePerLocalScan=512
FragmentLogFileSize=64M
NoOfFragmentLogFiles=16
RedoBuffer=2000M
MaxNoOfExecutionThreads=2
StopOnError=false
LockPagesInMainMemory=1
TimeBetweenEpochsTimeout=32000
TimeBetweenWatchdogCheckInitial=60000
TransactionInactiveTimeout=60000
HeartbeatIntervalDbDb=15000
HeartbeatIntervalDbApi=15000



[ndbd]
NodeId=2
HostName=127.0.0.1
#datadir=/usr/local/mysql/data
DataDir=/usr/local/mysql/data


[mysqld]
HostName=127.0.0.1
NodeId=3

[API]
NodeId=4
HostName=127.0.0.1

appreciate

whcih parameter i need to change to come out of this issue..


thanks in advance.......



Edited 2 time(s). Last edit at 09/13/2013 04:48AM by prasanth katta.