Hi!
Im Cluster with 1 mgm, 1 sql and 1 nd on the same machine.
i have 2Gb on ram. enough hd.
my config.ini
[NDBD DEFAULT]
NoOfReplicas=1
DataMemory=170M
IndexMemory=64M
MaxNoOfAttributes=10000
MaxNoOfConcurrentOperations=200000
datadir=/var/db/mysql/
[TCP DEFAULT]
portnumber=2202
SendBufferMemory=1024K
#------------------------
[NDB_MGMD]
id=1
hostname=192.168.6.1
datadir=/usr/local/etc/mysql
[MYSQLD]
id=3
hostname=192.168.6.1
[NDBD]
id=2
hostname=192.168.6.1
datadir=/var/db/mysql/nodos/
TransactionDeadlockDetectionTimeout=10000
HeartbeatIntervalDbDb=3000
HeartbeatIntervalDbApi=3000
BackupDataBufferSize=2M
BackupLogBufferSize=2M
BackupMemory=4M
BackupWriteSize=32K
When i try to set more than 175M on the DataMemory fails. Only on this
parameter.
Someone knows why?
freebsd#uname -a
FreeBSD freebsd.aduanet.net 6.3-RELEASE FreeBSD 6.3-RELEASE #0: Wed Jan
16 04:18:52 UTC 2008 [EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>:/usr/obj/usr/src/sys/GENERIC i386
freebsd# mysql --version
mysql Ver 14.12 Distrib 5.0.51a, for portbld-freebsd6.3 (i386) using 5.2
freebsd#
LOGS===================
freebsd# tail -f ndb_1_cluster.log
2008-04-07 16:04:20 [MgmSrvr] ALERT -- Node 2: Forced node shutdown
completed. Occured during startphase 0. Caused by error 2327: 'Memory
allocation failure, please decrease some configuration
parameters(Configuration error). Permanent error, external action needed'.
freebsd# tail -f ndb_2_out.log
2008-04-07 16:04:20 [ndbd] ALERT -- Node 2: Forced node shutdown
completed. Occured during startphase 0. Caused by error 2327: 'Memory
allocation failure, please decrease some configuration
parameters(Configuration error). Permanent error, external action needed'.
freebsd# tail -f Server_MySQL_err.log
080407 15:25:34 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.0.51a-log' socket: '/tmp/mysql.sock' port: 3306 FreeBSD
port: mysql-server-5.0.51a
--NO ERRORS¿?
--
====================================================
Ing. Vidal Garza Tirado
Depto. Sistemas
Aduanet S.A. de C.V.
Tel. (867)711-5850 ext. 4346, Fax (867)711-5855.
Ave. César López de Lara No. 3603 Int. B Col Jardín.
Nuevo Laredo, Tamaulipas, México.
--
Este mensaje ha sido analizado por MailScanner
en busca de virus y otros contenidos peligrosos,
y se considera que está limpio.
For all your IT requirements visit: http://www.aduanet.net
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
