![]() |
|
Welcome to the Computer Webmaster Gaming Console Graphics Forum forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
| |||||||
| Database Database problems or need to ask a question? maybe something to do with sql injections or a database software question. Database topics cover MySQL, PostgreSQL, Oracle, SQL Server or anything else related to databases. |
![]() |
| | LinkBack | Thread Tools | Display Modes |
| | #1 | ||
| 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 | |||
|
| Featured Websites | ||||
|
![]() |
| Tags: 1297, 410, error, files, hy000, log, overloaded, redo, temporary |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| mysql data files error | BL | Database | 1 | 07-01-2007 11:00 PM |
| ERROR 2013 (HY000): Lost connection to MySQL server during query | Leonardo | Database | 2 | 07-01-2007 9:35 PM |
| Meridian "There are no data files" error message | Eldon Thrush | GPS | 2 | 06-25-2007 11:20 PM |
| ALTER TABLE and temporary files on a webserver | Geert | Database | 0 | 06-10-2007 12:20 AM |
| PEAR DB ERROR: db_error: message="DB Error: insufficient data supplied" code=-20 | Kevin McCarthy | Pear | 0 | 05-20-2007 6:34 PM |
| Featured Websites | ||||
|