# Performance inputs for PXC

**URL:** <https://forums.percona.com/t/performance-inputs-for-pxc/4267>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [June 17, 2015, 7:11am UTC](https://forums.percona.com/t/performance-inputs-for-pxc/4267 "2015-06-17T07:11:08Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![surajchauhan](https://avatars.discourse-cdn.com/v4/letter/s/9f8e36/32.png) [@surajchauhan](https://forums.percona.com/u/surajchauhan)\
**Post date:** [June 17, 2015, 7:11am UTC](https://forums.percona.com/t/performance-inputs-for-pxc/4267/1 "2015-06-17T07:11:08Z")

</div>

Please suggest some inputs on read/write performance on PXC.

H/W – 3 nodes with 1 HA Proxy

64 GB RAM  
12 Core CPU/DELL  
Flash Drive 2.1 Tb  
PXC – 5.6.24 PXC (GPL)

Sample bench marking:

Average number of queries per client: 2500

Average number of queries per client: 714

Sample config on PXC:

wsrep\_provider\_options=“gcache.size=128M;gcache.page\_size =128M;”

---

<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:** [July 7, 2015, 1:43pm UTC](https://forums.percona.com/t/performance-inputs-for-pxc/4267/2 "2015-07-07T13:43:14Z")

</div>

Remember that this is still InnoDB and basic tuning of the storage engine is the first thing you should do. Like you may follow this:  
[url][https://www.percona.com/blog/2013/09/20/innodb-performance-optimization-basics-updated/[/url]](https://www.percona.com/blog/2013/09/20/innodb-performance-optimization-basics-updated/%5B/url%5D)

---

<div class="post-metadata">

**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:28am UTC](https://forums.percona.com/t/performance-inputs-for-pxc/4267/3 "2017-04-24T11:28:54Z")

</div>

also checkout the new pxc-5.7 that is performance optimized.

[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)