ndbd --initial startup issues in mysql cluster

2006-05-02 Thread Pradeep Chandru
hi, i am trying to install a cluster. i am facing issues in starting up the ndbd. My configuration is as follows. *Config.ini:* [NDBD DEFAULT] NoOfReplicas=2 [MYSQLD DEFAULT] [NDB_MGMD DEFAULT] [TCP DEFAULT] # Section for the cluster management node [NDB_MGMD] # IP address of the management n

Re: How to repair a table,

2006-05-11 Thread Pradeep Chandru
Hi, I think the syntax is to be verified. myisamchk * * -u root -p * ///*.* mysql will accept only if the passwords is next to "-p" option **: some frequently used options are mentioned below -r, --recover -o, --safe-recover -e, --extend-check -q, --quick -S, --sort-index -f, --force ( to b

Re: Need help in recreating .MYD files

2006-05-11 Thread Pradeep Chandru
hi, Just to add up i have read some where ( i assume in the mailing list only) that OS recognizes the file based on few codes added at the starting / ending of a file. So there are ways to create a MYD file through vi editor as well (this is not from the angle of restoring the data in that

Re: SELECT locking tables.... in other databases

2008-11-27 Thread Pradeep Chandru
Hi David, can you please let me know what is the select query and the update query along with the explain plan of the same. can you please let me know if you are using innodb storage engine? Regards, Chandru www.mafiree.com On Thu, Nov 27, 2008 at 4:45 PM, David Scott <[EMAIL PROTECTED]>wrot