Performance benchmarking for CockroachDB
In this section, we will go over the process of performing TPC-C benchmarking on CockroachDB. Here are the steps for running a TPC-C workload and getting the statistics for the run:
- Import the TPC-C dataset into your local CockroachDB cluster, as follows:
$ cockroach workload fixtures import tpcc –warehouses=5 'postgresql://root@localhost:26257?sslmode=disable' I220127 06:46:52.189260 1 ccl/workloadccl/fixture.go:342 [-] 1 starting import of 9 tables
- After loading the tables, you should see the following statistics at the end:
I220127 06:47:31.384005 1 workload/tpcc/tpcc.go:485 [-] 13 check 3.3.2.1 took 152.063ms I220127 06:47:31.664548 1 workload/tpcc/tpcc.go:485 [-] 14 check 3.3.2.2 took 280.468ms I220127 06:47:31.719888 1 workload/tpcc/tpcc.go:485 [-] 15 check 3.3.2.3 took 55.281ms I220127 06:47:32.796841 1 workload/tpcc/tpcc...
