When tunning MySQL-SERVER for best performance, the edition is done down my.cnf file.

Such as:

max_connections = 500
wait_timeout = 600
sort_buffer_size = 2M

Can I improve MySQL CLUSTER performance with those editable variables down [mysqld] tag of config.ini of mgmt node or my.cnf of ndbd node?

The main reason of this question is that I'm getting ERROR 1205: Lock wait timeout exceeded; try restarting transaction when importing a 1.2 G .sql file. I can't find any solution to this refering to MySQL CLUSTER so I want to try with the wait_timeoutvariable, but I don know if it's compatible with.

Will it accept those variables?

1 Answer 1


Yes, all this tuning variables are described in MySQL Documentation

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.