Mysql Cluster MaxNoOfAttributes参数无效疑问
配置文件参数如下,在导入cacti的数据库和syslog数据库是都报了一下的错误:ERROR 1296 (HY000): Got error 708 'No more attribute metadata records (increase MaxNoOfAttributes)' from NDBCLUSTER
请问是什么原因导致MaxNoOfAttributes参数无效的?如何查看当前NDBD节点的各个默认值?
# vi /etc/mycluster.cnf
NoOfReplicas=2
DataMemory=64M
IndexMemory=18M
MaxNoOfTables=1024
MaxNoOfAttributes=5000000
MaxNoOfOrderedIndexes=10000
#
#portnumber=2202
nodeid=1
hostname=10.16.147.20
datadir=/var/lib/mysql-cluster
nodeid=2
hostname=10.16.147.21
nodeid=3
hostname=10.16.147.22
nodeid=4
hostname=10.16.147.23
datadir=/var/lib/mysql-cluster
MaxNoOfTables=1024
MaxNoOfAttributes=5000000
MaxNoOfOrderedIndexes=10000
nodeid=5
hostname=10.16.147.24
datadir=/var/lib/mysql-cluster
MaxNoOfTables=1024
MaxNoOfAttributes=5000000
MaxNoOfOrderedIndexes=10000
# cat /etc/mycluster.cnf
NoOfReplicas=2
DataMemory=64M
IndexMemory=18M
MaxNoOfTables=1024
MaxNoOfAttributes=5000000
MaxNoOfOrderedIndexes=10000
#
#portnumber=2202
nodeid=1
hostname=10.16.147.20
datadir=/var/lib/mysql-cluster
nodeid=2
hostname=10.16.147.21
nodeid=3
hostname=10.16.147.22
nodeid=4
hostname=10.16.147.23
datadir=/var/lib/mysql-cluster
MaxNoOfTables=1024
MaxNoOfAttributes=5000000
MaxNoOfOrderedIndexes=10000
nodeid=5
hostname=10.16.147.24
datadir=/var/lib/mysql-cluster
MaxNoOfTables=1024
MaxNoOfAttributes=5000000
MaxNoOfOrderedIndexes=10000
-- NDB Cluster -- Management Client --
ndb_mgm> show
Connected to Management Server at: 10.16.147.20:1186
Cluster Configuration
---------------------
2 node(s)
id=4 @10.16.147.23(mysql-5.6.17 ndb-7.3.5, Nodegroup: 0, *)
id=5 @10.16.147.24(mysql-5.6.17 ndb-7.3.5, Nodegroup: 0)
1 node(s)
id=1 @10.16.147.20(mysql-5.6.17 ndb-7.3.5)
2 node(s)
id=2 @10.16.147.21(mysql-5.6.17 ndb-7.3.5)
id=3 @10.16.147.22(mysql-5.6.17 ndb-7.3.5) 终于找到原因了,原来修改了配置文件后,需要添加--initial参数重新读取才行的...没想到居然有一个这么纠结的选项....
ndb_mgmd -f /etc/mycluster.cnf --initial
查看当前的参数,配置已生效
# ndb_config -q MaxNoOfAttributes
50000 50000 可以分享下怎么搭建起来的吗?我搭建了很多次都失败了
页:
[1]