vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Hi, I got a NDB setup like this: Connected to Management Server at: localhost:1186 Cluster Configuration --------------------- [ndbd(NDB)] 3 node(s) id=5 @192.168.0.53 (Version: 5.0.30, Nodegroup: 0, Master) id=6 @192.168.0.54 (Version: 5.0.30, Nodegroup: 0) id=7 @192.168.0.55 (Version: 5.0.30, Nodegroup: 0) [ndb_mgmd(MGM)] 1 node(s) id=8 @192.168.0.104 (Version: 5.0.30) [mysqld(API)] 3 node(s) id=9 @192.168.0.53 (Version: 5.0.30) id=10 @192.168.0.54 (Version: 5.0.30) id=11 @192.168.0.55 (Version: 5.0.30) ndb_mgm> And config: --------------------- [NDBD DEFAULT] NoOfReplicas=3 DataMemory=7000M IndexMemory=300M datadir=/data/mysql-cluster Diskless=1 [MGM DEFAULT] datadir=/data/mysql-cluster [COMPUTER] id=1 HostName=db4.example.com [COMPUTER] id=2 HostName=db5.example.com [COMPUTER] id=3 HostName=db6.example.com [COMPUTER] id=4 hostname=root-int.example.com [NDBD] id=5 ExecuteOnComputer=1 [NDBD] id=6 ExecuteOnComputer=2 [NDBD] id=7 ExecuteOnComputer=3 [MGM] id=8 ExecuteOnComputer=4 [MYSQLD] id=9 ExecuteOnComputer=1 [MYSQLD] id=10 ExecuteOnComputer=2 [MYSQLD] id=11 ExecuteOnComputer=3 #EOF And erorlog message: --------------------- ERROR 1297 (HY000): Got temporary error 410 'REDO log files overloaded, consult online manual (decrease TimeBetweenLocalCheckpoints, and|or incre' from ndbcluster But I suspect that it is more than just decrease the TimeBetweenLocalCheckpoints variable. Anyone got any info how to collect needed data to try to find out what settings I need? // Sten |