Performance inputs for PXC

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;”

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]

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]