How to set value of mysql MaxNoOfConcurrentOperations

Question

Hi All,

I am getting following error Got temporary error 233 'Out of operation records in transaction coordinator (increase MaxNoOfConcurrentOperations)' from NDBCLUSTER

While inserting data into ndb table.

Can anyone explain more about this error. Also in my config.ini I dont have this parameter set. Is there any way I can see the default value of this variable. as I canot see this variable when I am using commmand SHOW VARIABLES.

To set this variable do I also need to change the MaxMaxNoOfConcurrentTransactions and MaxNoOfLocalOperations.

Need your valuable input. Please tell me what extra information i can provide on this, so that it will be easy to answer this question.

Thank you

Answer 1

The default value for MaxNoOfConcurrentOperations is 32768 but you can increase this value by editing your ndb_mgm config i.e. /etc/mysql/ndb_mgmd.cnf

and adding something like

MaxNoOfConcurrentOperations=100000

When updaing the MaxNoOfConcurrentOperations value you should also update MaxNoOfLocalOperations. The rule of thumb is to make MaxNoOfLocalOperations 10% larger than MaxNoOfConcurrentOperations so you would have.

MaxNoOfConcurrentOperations=100000
MaxNoOfLocalOperations=110000