MySQL集群7.2.2忽略了设置和TABLE IS FULL错误 [英] Mysql cluster 7.2.2 ignored settings and TABLE IS FULL error
问题描述
这是我的 my.cnf
设置
[mysqld]
ndbcluster
#engine_condition_pushdown=0
optimizer_switch=engine_condition_pushdown=off
# IP address of the cluster management node
ndb-connectstring=127.0.0.1
[mysql_cluster]
# IP address of the cluster management node
ndb-connectstring=127.0.0.1
[ndbd default]
NoOfReplicas= 2
MaxNoOfConcurrentOperations= 10000
DataMemory= 320M
IndexMemory= 96M
TimeBetweenWatchDogCheck= 30000
DataDir= /usr/local/mysql-cluster-gpl-7.2.2-osx10.6-x86_64/mysql-cluster
MaxNoOfOrderedIndexes= 512
[MYSQLD DEFAULT]
[NDB_MGMD DEFAULT]
[TCP DEFAULT]
# Section for the cluster management node
[NDB_MGMD]
# IP address of the management node (this system)
id=1
HostName=127.0.0.1
# Section for the storage nodes
[NDBD]
# IP address of the first storage node
id=2
HostName=127.0.0.1
DataDir= /usr/local/mysql-cluster-gpl-7.2.2-osx10.6-x86_64/mysql-cluster
[NDBD]
# IP address of the second storage node
id=3
HostName=127.0.0.1
DataDir= /usr/local/mysql-cluster-gpl-7.2.2-osx10.6-x86_64/mysql-cluster2
# one [MYSQLD] per storage node
[MYSQLD]
[MYSQLD]
我设置了数据内存320M,当我运行脚本填充表时,它停止并显示错误 table blabla已满。
我尝试运行 ndb_mgmd
和 -f
选项并使用配置文件的路径。
我将此文件复制到名称为 config.ini
的mysql-cluster文件夹中,但没有结果。
I set data memory 320M and when I run script to fill table it stop with error 'table blabla is full'.
I try to run ndb_mgmd
with -f
option and with path of configuration file.
I copy this file in mysql-cluster folder with name config.ini
but without result.
我得到了:
ndb_mgm> ALL REPORT MEMORYUSAGE
Node 2: Data usage is 100%(2560 32K pages of total 2560)
Node 2: Index usage is 74%(1741 8K pages of total 2336)
Node 3: Data usage is 100%(2560 32K pages of total 2560)
Node 3: Index usage is 74%(1741 8K pages of total 2336)
2560 * 32K = 80M。 80M就像默认的MySQL群集设置。
2560*32K=80M. 80M is like default mysql cluster settings.
推荐答案
我解决了我的问题。我需要将此配置分为两个配置文件,一个用于mysql服务器,然后将其放在data / my.cnf中:
i solve my problem. I need to divide this config on two config files one for mysql server and put it in data/my.cnf:
[mysqld]
ndbcluster
#engine_condition_pushdown=0
optimizer_switch=engine_condition_pushdown=off
# IP address of the cluster management node
ndb-connectstring=127.0.0.1
[mysql_cluster]
# IP address of the cluster management node
ndb-connectstring=127.0.0.1
/mysql_cluster/config.ini文件夹中用于群集捆绑的第二个文件:
And second file for cluster bundle in /mysql_cluster/config.ini folder:
[ndbd default]
NoOfReplicas= 2
MaxNoOfConcurrentOperations= 10000
DataMemory= 320M
IndexMemory= 96M
TimeBetweenWatchDogCheck= 30000
DataDir= /usr/local/mysql-cluster-gpl-7.2.2-osx10.6-x86_64/mysql-cluster
MaxNoOfOrderedIndexes= 512
[MYSQLD DEFAULT]
[NDB_MGMD DEFAULT]
[TCP DEFAULT]
# Section for the cluster management node
[NDB_MGMD]
# IP address of the management node (this system)
id=1
HostName=127.0.0.1
# Section for the storage nodes
[NDBD]
# IP address of the first storage node
id=2
HostName=127.0.0.1
DataDir= /usr/local/mysql-cluster-gpl-7.2.2-osx10.6-x86_64/mysql-cluster
[NDBD]
# IP address of the second storage node
id=3
HostName=127.0.0.1
DataDir= /usr/local/mysql-cluster-gpl-7.2.2-osx10.6-x86_64/mysql-cluster2
# one [MYSQLD] per storage node
[MYSQLD]
[MYSQLD]
这篇关于MySQL集群7.2.2忽略了设置和TABLE IS FULL错误的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!