Mysql Cluster data node Setup

2009-08-06 Thread Manasi Save
Hi All, I have Set up MySQL Cluster This is my Config.ini file #options affecting ndbd processes on all data nodes: [ndbd default] NoOfReplicas=2# Number of replicas DataMemory=80M# How much memory to allocate for data storage IndexMemory=18M # How much memory to allocate for index stor

Question about MySQL

2009-08-06 Thread Peter Chacko
Hello MySQL developers, Could any one tell me if MySQL's equivalent of PRO C concept in ORACLE? and Is there any equivalent for SQL *NET in MySQL? Other than C API/ODBC what are the other interfaces from client applications to MySQL database ? Another question is , whats the general experience o

restoring data from partition files?

2009-08-06 Thread jeffrd...@gmail.com
Hi, I'm running mysql 5.1 on Fedora 2.6. The machine was rebooted yesterday using the linux shutdown command but mysql was not stopped before shutdown. Clearly a mistake. Now I have data in partition files that I would like to reload into their corresponding tables. How can I load the partitio

Re: How to Detect MySql table update/difference

2009-08-06 Thread Martijn Tonies
Hi, Hi, I'm a novel developer of MySql and now I am trying to create a mysql query to detect table updates. I query a database table every X seconds, and i want to get only the different rows in the table. The result that I want to have is simply TABLE (t = now) - TABLE (t = X second ago) E