I have deployed a default cockroachdb cluster with:
helm install wh2500crdb cockroachdb/cockroachdb --namespace=thesis-crdb
And I’ve initiated a workload of 2500 warehouses:
cockroach workload init tpcc --warehouses=2500 'postgresql://root@wh2500crdb-cockroachdb-public:26257?sslmode=disable'
This took around 5 hours to complete. Then I run the workload:
cockroach workload run tpcc --warehouses=20 --ramp=3m --duration=10m 'postgresql://root@wh2500crdb-cockroachdb-public:26257?sslmode=disable'
I run the test with warehouses=10
and then I’ve increased warehouses=20
and then 40, 80 and all the way up to 2500.
Everything seems to be following a pattern, the throughput is increasing with increased number of workload. But something strange happends at 1280 and 2500 warehouses.
1280 warehouses has a tpmC of 15515
2500 warehouses has tpmC of 8918
Is there a logical explanation for this?
I’ll attach my excel sheet here so you can see for yourselves.