- 论坛徽章:
- 0
|
配置文件参数如下,在导入cacti的数据库和syslog数据库是都报了一下的错误:
ERROR 1296 (HY000): Got error 708 'No more attribute metadata records (increase MaxNoOfAttributes)' from NDBCLUSTER
请问是什么原因导致MaxNoOfAttributes参数无效的?如何查看当前NDBD节点的各个默认值?
[root@ClusterMgm ~]# vi /etc/mycluster.cnf
[NDBD DEFAULT]
NoOfReplicas=2
DataMemory=64M
IndexMemory=18M
MaxNoOfTables=1024
MaxNoOfAttributes=5000000
MaxNoOfOrderedIndexes=10000
#[TCP DEFAULT]
#portnumber=2202
[NDB_MGMD]
nodeid=1
hostname=10.16.147.20
datadir=/var/lib/mysql-cluster
[MYSQLD]
nodeid=2
hostname=10.16.147.21
[MYSQLD]
nodeid=3
hostname=10.16.147.22
[NDBD]
nodeid=4
hostname=10.16.147.23
datadir=/var/lib/mysql-cluster
MaxNoOfTables=1024
MaxNoOfAttributes=5000000
MaxNoOfOrderedIndexes=10000
[NDBD]
nodeid=5
hostname=10.16.147.24
datadir=/var/lib/mysql-cluster
MaxNoOfTables=1024
MaxNoOfAttributes=5000000
MaxNoOfOrderedIndexes=10000
[root@ClusterMgm ~]# cat /etc/mycluster.cnf
[NDBD DEFAULT]
NoOfReplicas=2
DataMemory=64M
IndexMemory=18M
MaxNoOfTables=1024
MaxNoOfAttributes=5000000
MaxNoOfOrderedIndexes=10000
#[TCP DEFAULT]
#portnumber=2202
[NDB_MGMD]
nodeid=1
hostname=10.16.147.20
datadir=/var/lib/mysql-cluster
[MYSQLD]
nodeid=2
hostname=10.16.147.21
[MYSQLD]
nodeid=3
hostname=10.16.147.22
[NDBD]
nodeid=4
hostname=10.16.147.23
datadir=/var/lib/mysql-cluster
MaxNoOfTables=1024
MaxNoOfAttributes=5000000
MaxNoOfOrderedIndexes=10000
[NDBD]
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
---------------------
[ndbd(NDB)] 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)
[ndb_mgmd(MGM)] 1 node(s)
id=1 @10.16.147.20 (mysql-5.6.17 ndb-7.3.5)
[mysqld(API)] 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) |
|