来自NDBCLUSTER的本地数据管理器中的操作外记录(增加MaxNoOfLocalOperations)

Question

MaxNoOfConcurrentOperations=150000
MaxNoOfConcurrentTransactions=150000
MaxNoOfLocalOperations=150000

我在config.ini中有上面的参数，当我尝试删除表中的行时，会出现以下错误

mysql> delete from radacct where acctinputoctets=0 and acctoutputoctets=0;
ERROR 1297 (HY000): Got temporary error 1217 'Out of operation records in local data manager (increase MaxNoOfLocalOperations)' from NDBCLUSTER.

mysql> explain delete from radacct where acctinputoctets=0 and acctoutputoctets=0;    
+----+-------------+---------+------+---------------+------+---------+------+---------+-------------+
| id | select_type | table   | type | possible_keys | key  | key_len | ref  | rows    | Extra       |
+----+-------------+---------+------+---------------+------+---------+------+---------+-------------+
|  1 | SIMPLE      | radacct | ALL  | NULL          | NULL | NULL    | NULL | 1209607 | Using where |
+----+-------------+---------+------+---------------+------+---------+------+---------+-------------+

如何确定最大局部操作的最优值？

Answer 1

1. vi config.ini，/var/lib/mysql-cluster/XX/config.ini或/var/lib/mysql-cluster/config.ini※XX :ndb_mgmd节点的id
2. 添加MaxNoOfConcurrentOperations=2000000
3. 重新启动ndb集群

Answer 2

这些参数值应该如下所示：MaxNoOfLocalOperations>MaxNoOfConcurrentOperations>MaxNoOfConcurrentTransactions