Mysql NDB Cluster

[SRINIVASA RAO PUJARI]

Hi Every One,

I am using MYSQL as database for my application. It is good and working fine. Recently we have implemented NDB cluster for my database. From there on wards I am getting some issues related to database in my application. Every time getting error message like "Lock wait timeout exceeded; restart transaction". Currently my database parameters are set like below.

innodb_lock_wait_timeout=50
ndb_wait_connected=30
ndb_wait_setup=30
table_lock_wait_timeout=30
wait_timeout=28800

Kindly tell me which parameter I need to change and what will be the feasible value to run our application smoother.

Thanks & Regards
Srinivasa Rao Pujari