# Unknow problem make innodb\_buffer\_pool\_size useless in cluster environment

**URL:** <https://forums.percona.com/t/unknow-problem-make-innodb-buffer-pool-size-useless-in-cluster-environment/3769>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [September 24, 2014, 9:28pm UTC](https://forums.percona.com/t/unknow-problem-make-innodb-buffer-pool-size-useless-in-cluster-environment/3769 "2014-09-24T21:28:14Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![raymondchu](https://avatars.discourse-cdn.com/v4/letter/r/5f9b8f/32.png) [@raymondchu](https://forums.percona.com/u/raymondchu)\
**Post date:** [September 24, 2014, 9:28pm UTC](https://forums.percona.com/t/unknow-problem-make-innodb-buffer-pool-size-useless-in-cluster-environment/3769/1 "2014-09-24T21:28:14Z")

</div>

I’ve setup 2 servers in my cluster, but something strange happend.  
I’ve tried to change innodb\_buffer\_pool\_size this variable in 1G , 8G 10G ,enven make it comment out. My both server still use 13G memory.  
Who can help me?

I copy my.cnf in the below:  
[mysqld]  
datadir = /Data/mysql/data  
socket=/Data/mysql/mysql.sock  
user=mysql  
character-set-server = utf8  
port = 3306

# Disabling symbolic-links is recommended to prevent assorted security risks

symbolic-links=0  
default-storage-engine=InnoDB  
explicit\_defaults\_for\_timestamp=true

character-set-server = utf8  
sort\_buffer\_size = 4M  
max\_connections = 65535  
join\_buffer\_size = 4M  
#thread\_concurrency=16  
#InnoDB  
innodb\_data\_file\_path=ibdata1:2048M:autoextend  
innodb\_buffer\_pool\_size = 6G  
innodb\_log\_buffer\_size = 8M  
innodb\_log\_file\_size = 256M  
innodb\_log\_files\_in\_group = 3  
innodb\_autoinc\_lock\_mode=2  
innodb\_additional\_mem\_pool\_size = 32M  
innodb\_thread\_concurrency=0  
log-bin=/Data/mysql/binlog/bin-file.log  
binlog\_cache\_size = 1M  
binlog\_format=ROW  
max\_binlog\_size=256M  
max\_binlog\_cache\_size=50M

log-error=/Data/mysql/mysqld\_error.log

wsrep\_provider=/usr/lib64/libgalera\_smm.so  
wsrep\_cluster\_address=gcomm://172.168.3.57,172.168.3.58  
wsrep\_node\_address=172.168.3.57  
wsrep\_sst\_method=xtrabackup-v2  
wsrep\_cluster\_name=test.cluster  
wsrep\_sst\_auth=“sstuser:s3cret”

[mysqld\_safe]  
pid-file=/Data/mysql/mysqld.pid

socket=/Data/mysql/mysql.sock

[client]  
socket=/Data/mysql/mysql.sock

---

<div class="post-metadata">

**Author:** ![przemek](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/przemek/32/3_2.png) [@przemek](https://forums.percona.com/u/przemek)\
**Post date:** [September 28, 2014, 3:39pm UTC](https://forums.percona.com/t/unknow-problem-make-innodb-buffer-pool-size-useless-in-cluster-environment/3769/2 "2014-09-28T15:39:56Z")

</div>

I don’t think I understand the problem - what is the error you get? What does it mean “useless”?