# build more connection on each request

**URL:** <https://forums.percona.com/t/build-more-connection-on-each-request/3576>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [June 29, 2014, 6:29am UTC](https://forums.percona.com/t/build-more-connection-on-each-request/3576 "2014-06-29T06:29:10Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![tohid](https://avatars.discourse-cdn.com/v4/letter/t/df788c/32.png) [@tohid](https://forums.percona.com/u/tohid)\
**Post date:** [June 29, 2014, 6:29am UTC](https://forums.percona.com/t/build-more-connection-on-each-request/3576/1 "2014-06-29T06:29:10Z")

</div>

i setup percona cluster with only one node for simpilicity .. every thing is fine and works , but i found that when i establish a connection to that , more than one connection are generated !  
this is my process on mysql before new connection request :

mysql\> show processlist;

±—±------------±----------±-----±--------±-----±-------------------±-----------------±----------±--------------+  
| Id | User | Host | db | Command | Time | State | Info | Rows\_sent | Rows\_examined |  
±—±------------±----------±-----±--------±-----±-------------------±-----------------±----------±--------------+  
| 1 | system user | | NULL | Sleep | 523 | NULL | NULL | 0 | 0 |  
| 2 | system user | | NULL | Sleep | 523 | wsrep aborter idle | NULL | 0 | 0 |  
| 16 | root | localhost | NULL | Query | 0 | init | show processlist | 0 | 0 |  
±—±------------±----------±-----±--------±-----±-------------------±-----------------±----------±--------------+

and after new connection is request by root user , this is what happen :

mysql\> show processlist;

±—±------------±-------------------±-----±--------±-----±-------------------±-----------------±----------±--------------+  
| Id | User | Host | db | Command | Time | State | Info | Rows\_sent | Rows\_examined |  
±—±------------±-------------------±-----±--------±-----±-------------------±-----------------±----------±--------------+  
| 1 | system user | | NULL | Sleep | 530 | NULL | NULL | 0 | 0 |  
| 2 | system user | | NULL | Sleep | 530 | wsrep aborter idle | NULL | 0 | 0 |  
| 16 | root | localhost | NULL | Query | 0 | init | show processlist | 0 | 0 |  
| 17 | root | 192.168.1.200:2402 | NULL | Sleep | 1 | | NULL | 5 | 5 |  
| 19 | root | 192.168.1.200:2404 | NULL | Sleep | 0 | | NULL | 0 | 0 |  
| 20 | root | 192.168.1.200:2405 | NULL | Sleep | 0 | | NULL | 0 | 0 |  
±—±------------±-------------------±-----±--------±-----±-------------------±-----------------±----------±--------------+

also this is my.cnf config :

[mysqld]  
#port=4949

# Path to Galera library

wsrep\_provider=/usr/lib64/libgalera\_smm.so

# Cluster connection URL

wsrep\_cluster\_address=gcomm://192.168.1.149,192.168.1.150

# In order for Galera to work correctly binlog format should be ROW

binlog\_format=ROW

# MyISAM storage engine has only experimental support

default\_storage\_engine=InnoDB

# This changes how |InnoDB| autoincrement locks are managed and is a requirement for Galera

innodb\_autoinc\_lock\_mode=2  
wsrep\_node\_address=192.168.1.149  
wsrep\_sst\_method=rsync  
wsrep\_cluster\_name=aryanic\_cluster

what the problem is ? any suggesstion ?

---

<div class="post-metadata">

**Author:** ![tohid](https://avatars.discourse-cdn.com/v4/letter/t/df788c/32.png) [@tohid](https://forums.percona.com/u/tohid)\
**Post date:** [June 29, 2014, 8:01am UTC](https://forums.percona.com/t/build-more-connection-on-each-request/3576/2 "2014-06-29T08:01:05Z")

</div>

sorry , i found this happen if i connect to percona via mysql query browser or mysql workbench… any body have this experience like me ?