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