ok

2 data nodes having 2 gig ram

my mgm having this for config

[NDBD DEFAULT] NoOfReplicas=2 MaxNoOfConcurrentOperations=10000 MaxNoOfConcurrentTransactions=10000 MaxNoOfLocalOperations=100000 TimeBetweenWatchDogCheck=30000 TransactionInactiveTimeout=30000 TransactionDeadlockDetectionTimeout=2000

DataMemory=500M IndexMemory=100M

LogLevelStartup=15 LogLevelShutdown=15 LogLevelStatistic=15 LogLevelCheckpoint=15 LogLevelNodeRestart=15 LogLevelConnection=15 LogLevelError=15 LogLevelInfo=15 MaxNoOfTables=128 MaxNoOfUniqueHashIndexes=128

[NDB_MGMD] Id=1 HostName=10.10.10.10 DataDir=/var/lib/mysql-cluster ArbitrationRank=1

[NDBD] HostName=10.10.10.20 DataDir=/usr/mysql-cluster Id=2

[NDBD] HostName=10.10.10.21 DataDir=/usr/mysql-cluster Id=3

[TCP] NodeId1=2 NodeId2=3

HostName1=10.10.10.20 HostName2=10.10.10.21

[MYSQLD] [MYSQLD] [MYSQLD] [MYSQLD] [MYSQLD] [MYSQLD] [MYSQLD] [MYSQLD] [MYSQLD]

*******************************************************************

and my my.cnf having

[MYSQL_CLUSTER] ndb-connectstring=10.10.10.10 # location of MGM node

[MYSQLD] # Options for mysqld process: ndbcluster # run NDB engine ndb-connectstring=10.10.10.10 # location of MGM node

port = 3306 socket = /tmp/mysql.sock skip-locking key_buffer = 256M max_allowed_packet = 1M table_cache = 256 sort_buffer_size = 1M read_buffer_size = 1M read_rnd_buffer_size = 4M myisam_sort_buffer_size = 64M thread_cache = 8 query_cache_size= 16M # Try number of CPU's*2 for thread_concurrency thread_concurrency = 1 max_connections = 500 innodb_table_locks=0 log-bin=db4-bin server-id = 4

************************************************

i still get

Time: Tuesday 8 November 2005 - 12:14:01 Status: Permanent error, external action needed Message: Memory allocation failure, please decrease some configuration parameters (Configuration error) Error: 2327 Error data: DBTUP could not allocate memory for UndoPage Error object: Requested: 32768x512 = 16777216 bytes Program: /usr/local/libexec/ndbd Pid: 407 Trace: /usr/mysql-cluster/ndb_2_trace.log.8 Version: Version 5.0.15 ***EOM***

Time: Tuesday 8 November 2005 - 12:15:49 Status: Permanent error, external action needed Message: Memory allocation failure, please decrease some configuration parameters (Configuration error) Error: 2327 Error data: DBTUP could not allocate memory for UndoPage Error object: Requested: 32768x512 = 16777216 bytes Program: /usr/local/libexec/ndbd Pid: 576 Trace: /usr/mysql-cluster/ndb_2_trace.log.9 Version: Version 5.0.15 ***EOM***

on the nodes on trying to start ndbd

question:

no databases are currently set as cluster and db is empty

but why cnat i assign 500 and 100 megs for data and index ?

man this is hard to fix.. any help appreciated.

Frank