# somebody help me. **URL:** \ **Category:** Other MySQL® Questions\ **Created:** [January 3, 2010, 11:25am UTC](https://forums.percona.com/t/somebody-help-me/1323 "2010-01-03T11:25:27Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![jack\_0909](https://avatars.discourse-cdn.com/v4/letter/j/87869e/32.png) [@jack\_0909](https://forums.percona.com/u/jack_0909)\ **Post date:** [January 3, 2010, 11:25am UTC](https://forums.percona.com/t/somebody-help-me/1323/1 "2010-01-03T11:25:27Z")
hello. help me plz.. * * * ## OS : solaris 10(x86 32bit) RAM : 1gb #\> ./ndbd 2010-01-04 01:51:18 [ndbd] INFO – Configuration fetched from ‘localhost:1186’, generation: 1 2010-01-04 01:51:18 [ndbd] INFO – Angel pid: 9160 ndb pid: 9161 NDBMT: non-mt 2010-01-04 01:51:18 [ndbd] INFO – NDB Cluster – DB node 3 2010-01-04 01:51:18 [ndbd] INFO – mysql-5.1.39 ndb-7.0.9b – 2010-01-04 01:51:18 [ndbd] INFO – WatchDog timer is set to 6000 ms 2010-01-04 01:51:18 [ndbd] INFO – Ndbd\_mem\_manager::init(1) min: 44Mb initial: 244Mb Adding 244Mb to ZONE\_LO (1,7807) 2010-01-04 01:51:18 [ndbd] INFO – Start initiated (mysql-5.1.39 ndb-7.0.9) NDBFS/AsyncFile: Allocating 310256 for In/Deflate buffer NDBFS/AsyncFile: Allocating 310256 for In/Deflate buffer NDBFS/AsyncFile: Allocating 310256 for In/Deflate buffer NDBFS/AsyncFile: Allocating 310256 for In/Deflate buffer NDBFS/AsyncFile: Allocating 310256 for In/Deflate buffer NDBFS/AsyncFile: Allocating 310256 for In/Deflate buffer NDBFS/AsyncFile: Allocating 310256 for In/Deflate buffer NDBFS/AsyncFile: Allocating 310256 for In/Deflate buffer NDBFS/AsyncFile: Allocating 310256 for In/Deflate buffer NDBFS/AsyncFile: Allocating 310256 for In/Deflate buffer NDBFS/AsyncFile: Allocating 310256 for In/Deflate buffer NDBFS/AsyncFile: Allocating 310256 for In/Deflate buffer NDBFS/AsyncFile: Allocating 310256 for In/Deflate buffer NDBFS/AsyncFile: Allocating 310256 for In/Deflate buffer NDBFS/AsyncFile: Allocating 310256 for In/Deflate buffer NDBFS/AsyncFile: Allocating 310256 for In/Deflate buffer NDBFS/AsyncFile: Allocating 310256 for In/Deflate buffer NDBFS/AsyncFile: Allocating 310256 for In/Deflate buffer NDBFS/AsyncFile: Allocating 310256 for In/Deflate buffer NDBFS/AsyncFile: Allocating 310256 for In/Deflate buffer NDBFS/AsyncFile: Allocating 310256 for In/Deflate buffer NDBFS/AsyncFile: Allocating 310256 for In/Deflate buffer NDBFS/AsyncFile: Allocating 310256 for In/Deflate buffer NDBFS/AsyncFile: Allocating 310256 for In/Deflate buffer NDBFS/AsyncFile: Allocating 310256 for In/Deflate buffer NDBFS/AsyncFile: Allocating 310256 for In/Deflate buffer NDBFS/AsyncFile: Allocating 310256 for In/Deflate buffer WOPool::init(61, 9) RWPool::init(22, 13) 2010-01-04 01:51:22 [ndbd] INFO – DBLQH could not allocate memory for LogPageRecord 2010-01-04 01:51:22 [ndbd] INFO – Requested: 32768x5760 = 188744191 bytes 2010-01-04 01:51:22 [ndbd] INFO – Error handler startup shutting down system 2010-01-04 01:51:22 [ndbd] INFO – Error handler shutdown completed - exiting 2010-01-04 01:51:22 [ndbd] INFO – Angel received ndbd startup failure count 1. 2010-01-04 01:51:22 [ndbd] ALERT – Node 3: 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’. ## config.ini [NDBD DEFAULT] NoOfReplicas: 1 DataDir: /usr/local/web\_apps/mysql/clusterdata DataMemory: 60M IndexMemory: 10M BackupMemory: 7M [MGM DEFAULT] PortNumber: 1186 DataDir: /usr/local/web\_apps/mysql/clusterdata [TCP DEFAULT] #SendBufferMemory: 10M SendBufferMemory: 2M PortNumber: 2202 [NDB\_MGMD] Id: 1 HostName: 127.0.0.1 ArbitrationRank: 1 [NDBD] Id: 3 HostName: localhost [MYSQLD] Id: 5 HostName: 127.0.0.1 ## my.cnf [client] #password = your\_password port = 3306 socket = /tmp/mysql.sock # Here follows entries for some specific programs # The MySQL server [mysqld] port = 3306 socket = /tmp/mysql.sock skip-locking #key\_buffer\_size = 48M key\_buffer\_size = 10M max\_allowed\_packet = 1M table\_open\_cache = 4 sort\_buffer\_size = 64K read\_buffer\_size = 256K read\_rnd\_buffer\_size = 256K net\_buffer\_length = 2K thread\_stack = 128K default-character-set=euckr skip-character-set-client-handshake character-set-filesystem=euckr default-collation = euckr\_korean\_ci ndbcluster # run NDB engine ndb-connectstring=localhost # location of MGM node # Don’t listen on a TCP/IP port at all. This can be a security enhancement, # if all processes that need to connect to mysqld run on the same host. # All interaction with mysqld must be made via Unix sockets or named pipes. # Note that using this option without enabling named pipes on Windows # (using the “enable-named-pipe” option) will render mysqld useless! # #skip-networking server-id = 1 # Uncomment the following if you want to log updates log-bin=mysql-bin # binary logging format - mixed recommended #binlog\_format=mixed # Uncomment the following if you are using InnoDB tables #innodb\_data\_home\_dir = /usr/local/mysql/data/ #innodb\_data\_file\_path = ibdata1:10M:autoextend #innodb\_log\_group\_home\_dir = /usr/local/mysql/data/ # You can set ..\_buffer\_pool\_size up to 50 - 80 % # of RAM but beware of setting memory usage too high #innodb\_buffer\_pool\_size = 16M #innodb\_additional\_mem\_pool\_size = 2M # Set ..\_log\_file\_size to 25 % of buffer pool size #innodb\_log\_file\_size = 5M #innodb\_log\_buffer\_size = 8M #innodb\_flush\_log\_at\_trx\_commit = 1 #innodb\_lock\_wait\_timeout = 50 [mysqldump] quick max\_allowed\_packet = 16M [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates [myisamchk] key\_buffer\_size = 8M sort\_buffer\_size = 8M [mysqlhotcopy] interactive-timeout ## top result last pid: 9185; load avg: 0.01, 0.02, 0.03; up 3+12:15:18 01:59:27 72 processes: 71 sleeping, 1 on cpu CPU states: 99.5% idle, 0.0% user, 0.5% kernel, 0.0% iowait, 0.0% swap Memory: 1024M phys mem, 726M free mem, 1028M total swap, 990M free swap PID USERNAME LWP PRI NICE SIZE RES STATE TIME CPU COMMAND 9185 root 1 59 0 2484K 1412K cpu/0 0:00 0.20% top 9114 root 10 59 0 14M 3252K sleep 0:02 0.14% ndb\_mgmd 805 root 46 59 0 611M 93M sleep 4:41 0.02% java 700 zentop 1 59 0 8416K 1616K sleep 0:02 0.01% sshd 7 root 12 59 0 11M 4556K sleep 0:07 0.00% svc.startd 752 root 1 59 0 269M 4708K sleep 0:13 0.00% httpd 770 root 1 59 0 7456K 3244K sleep 0:14 0.00% httpd 405 root 1 59 0 1112K 644K sleep 0:00 0.00% utmpd 9 root 15 59 0 10M 6340K sleep 0:23 0.00% svc.configd 159 root 29 59 0 6512K 2444K sleep 0:10 0.00% nscd 1 root 1 59 0 2160K 776K sleep 0:07 0.00% init 349 daemon 4 59 0 13M 7084K sleep 0:05 0.00% nfsmapid 581 root 16 59 0 13M 3256K sleep 0:05 0.00% fmd 385 root 4 59 0 4616K 1904K sleep 0:05 0.00% inetd 521 daemon 2 60 -20 2336K 1304K sleep 0:04 0.00% nfsd ---
**Author:** ![xaprb](https://avatars.discourse-cdn.com/v4/letter/x/49beb7/32.png) [@xaprb](https://forums.percona.com/u/xaprb)\ **Post date:** [January 3, 2010, 11:18pm UTC](https://forums.percona.com/t/somebody-help-me/1323/2 "2010-01-03T23:18:10Z")
I have two suggestions: 1. read [URL][http://catb.org/~esr/faqs/smart-questions.html[/URL]](http://catb.org/~esr/faqs/smart-questions.html%5B/URL%5D) 2. you are playing with fire if you can’t admin Cluster at this level. Hire someone competent (like us) or stop using it, because you are going to shoot yourself in the foot, bigtime. ---
**Author:** ![jack\_0909](https://avatars.discourse-cdn.com/v4/letter/j/87869e/32.png) [@jack\_0909](https://forums.percona.com/u/jack_0909)\ **Post date:** [January 3, 2010, 11:39pm UTC](https://forums.percona.com/t/somebody-help-me/1323/3 "2010-01-03T23:39:15Z")
Thank you. happy new year! D