# Poor sysbench performance - 3 node pxc versus single node community version **URL:** \ **Category:** Percona XtraDB Cluster 5.x\ **Created:** [January 11, 2016, 12:09pm UTC](https://forums.percona.com/t/poor-sysbench-performance-3-node-pxc-versus-single-node-community-version/4660 "2016-01-11T12:09:33Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![rossiwa](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/rossiwa/32/953_2.png) [@rossiwa](https://forums.percona.com/u/rossiwa)\ **Post date:** [January 11, 2016, 12:09pm UTC](https://forums.percona.com/t/poor-sysbench-performance-3-node-pxc-versus-single-node-community-version/4660/1 "2016-01-11T12:09:33Z")
I’m trying to benchmark the performance of 3-node pxc cluster. The sysbench result I’m getting on a 3-node pxc is much slower than the sysbench result on a single node community version server. The transaction rate on the pxc is about 1/2 the rate on the single node. I expected the performance of the 3-node cluster to be better than the single node. I suspect that I have configured the cluster and/or the test incorrectly. I’ve tried several different configurations, but still get similar results. Are there any obvious problems with my setup? Is there a guide to running sysbench on pxc? Sysbench Results (tps): [TABLE=“border: 1, cellpadding: 1, width: 500”] [TR] [TD]Threads[/TD] [TD]Community-56[/TD] [TD]PXC-3node[/TD] [/TR] [TR] [TD]1[/TD] [TD]178.8[/TD] [TD]122.41[/TD] [/TR] [TR] [TD]8[/TD] [TD]1323.24[/TD] [TD]891.09[/TD] [/TR] [TR] [TD]128[/TD] [TD]2166.06[/TD] [TD]595.68[/TD] [/TR] [TR] [TD]1024[/TD] [TD]1427.13[/TD] [TD]563.8[/TD] [/TR] [TR] [TD]2048[/TD] [TD]579.6[/TD] [TD]528.31[/TD] [/TR] [TR] [TD]4096[/TD] [TD]42.02[/TD] [TD]304.98[/TD] [/TR] [/TABLE] 3 Physical Hosts: 24 core Xenon 256 GB RAM 3T disk pxc version: 5.6.24-72.2-56 pxc config: [mysqld] datadir=/clusterdb/mysql/data user=mysql wsrep\_provider=/usr/lib64/libgalera\_smm.so wsrep\_cluster\_address=gcomm://192.168.12.65,192.168.12.66,192.168.12.67 binlog\_format=ROW default\_storage\_engine=InnoDB innodb\_autoinc\_lock\_mode=2 wsrep\_node\_address=192.168.12.65 wsrep\_sst\_method=xtrabackup-v2 wsrep\_cluster\_name=my\_centos\_cluster wsrep\_sst\_auth=“xxxx:xxxxx” log-error=/clusterdb/mysql/var/log/mysqld.log max\_connections = 6000 max\_prepared\_stmt\_count = 65536 innodb\_log\_file\_size = 1500M community version 5.6.26 config: [mysqld] user = mysql bind-address = 0.0.0.0 port = 50000 socket = /clusterdb/mysql/56/sbtest/var/run/mysql.sock pid-file = /clusterdb/mysql/56/sbtest/var/run/mysql.pid datadir = /clusterdb/mysql/56/sbtest/data tmpdir = /clusterdb/mysql/56/sbtest/tmp log-bin = /clusterdb/mysql/56/sbtest/var/log/binlog/mysql-bin.log expire\_logs\_days = 5 max\_binlog\_size = 100M general-log = 0 general\_log\_file = /clusterdb/mysql/56/sbtest/var/log/mysql.log log-error = /clusterdb/mysql/56/sbtest/var/log/error.log slow-query-log = 1 slow\_query\_log\_file = /clusterdb/mysql/56/sbtest/var/log/slow.log relay-log = /clusterdb/mysql/56/sbtest/var/log/relaylog/mysqld-relay-bin relay-log-index = /clusterdb/mysql/56/sbtest/var/log/relaylog/mysqld-relay-bin.index server-id = 1 innodb\_fast\_shutdown = 0 max\_connections = 6000 open\_files\_limit = 32768 max\_prepared\_stmt\_count = 65536 table\_open\_cache = 8000 sysbench version: 0.5 sysbench command: sysbench --test=oltp –mysql-host=mysql-cluster1,mysql-cluster2,mysql-cluster3 –mysql-user=xxxx --mysql-password=xxxx –mysql-table-engine=InnoDB –mysql-engine-trx=yes –oltp-table-size=200000000 –max-time=60 –max-requests=0 –num-threads=$N –oltp-auto-inc=off –oltp-test-mode=complex –db-driver=mysql run ---
**Author:** ![krunalbauskar](https://avatars.discourse-cdn.com/v4/letter/k/439d5e/32.png) [@krunalbauskar](https://forums.percona.com/u/krunalbauskar)\ **Post date:** [April 24, 2017, 11:27am UTC](https://forums.percona.com/t/poor-sysbench-performance-3-node-pxc-versus-single-node-community-version/4660/2 "2017-04-24T11:27:43Z")
check the new performance optimized pxc-5.7 [url][https://www.percona.com/blog/2017/04/19/performance-improvements-percona-xtradb-cluster-5-7-17/[/url]](https://www.percona.com/blog/2017/04/19/performance-improvements-percona-xtradb-cluster-5-7-17/%5B/url%5D)