From: Date: March 4 2008 3:36pm
Subject: Out of memory in NDB kernel and Table is full.
List-Archive: http://lists.mysql.com/cluster/5751
Message-Id: <209FBDF00C0A3342AA3C36DA14468144036D004B@BACKEND.vinagame.com.vn>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Our cluster have 2 managements, 2 APIs and four nodes.
Each node have 10GB RAM,
We have two databases with total more than 8GB size.
Our configure file:
[NDBD DEFAULT]
NoOfReplicas=3D2
HeartbeatIntervalDbDb=3D600
HeartbeatIntervalDbApi=3D600
HostName=3D10.30.13.46
DataDir=3D/var/lib/mysql/mysql-cluster
BackupDataDir=3D/var/lib/backup
DataMemory=3D9G
IndexMemory=3D1G
TransactionDeadlockDetectionTimeout=3D12000
MaxNoOfConcurrentTransactions =3D 10000
MaxNoOfConcurrentOperations =3D 250000
TimeBetweenWatchDogCheck =3D 20000
MaxNoOfOrderedIndexes =3D 17000
MaxNoOfTables =3D 3500
MaxNoOfAttributes =3D 15000
NoOfFragmentLogFiles =3D 300
RedoBuffer =3D 1024M
TimeBetweenLocalCheckpoints =3D 10
TimeBetweenGlobalCheckpoints =3D 500
NoOfDiskPagesToDiskAfterRestartTUP =3D 80
NoOfDiskPagesToDiskDuringRestartTUP =3D 80
NoOfDiskPagesToDiskAfterRestartACC =3D 40
NoOfDiskPagesToDiskDuringRestartACC =3D 40
ArbitrationTimeout =3D 2000
[MYSQLD DEFAULT]
[NDB_MGMD DEFAULT]
[TCP DEFAULT]
# Section for the cluster management node
SendBufferMemory=3D1024K
ReceiveBufferMemory=3D1024K
[NDB_MGMD]
# IP address of the management node (this system)
Id=3D1
HostName=3D10.30.13.45
[NDB_MGMD]
Id=3D2
HostName=3D10.30.13.55

I always get the error out of memory and table is full.
Please help me solve this problem. I do not know is there any problem in
my config file?

Sometime, I can not restart our node on cluster and lose data. When this
happen, I should restart by ndbd --initial and restore from backup file.

Mysql cluster is very terrible with me. I always got problems.
Please give me your advice.
Thanks so musch.
Toan Dang Anh
VINAGAME JSC=20
459B Nguyen Dinh Chieu, district 3, HCMC, VietNam
------------------------------------------------------------------------
--=20
Email: toanda@stripped=20
http://www.vinagame.com.vn=20
------------------------------------------------------------------------
--