The questions of CockroachDB 2.0 TPC-C test

After reading this paper “CockroachDB 2.0 Performance Makes Significant Strides”, I have some questions and hope to be answered.
1.What are the testing tools for TPC-C testing? Is it open source tools or self research tools?
2.Are the standard TPC-C data models used to test? Is the data model modified?
3.In the test, is the transaction isolation level set serializable or snapshot?Has the table create index?
4.What is the sum and proportion of the five transactions,including New-Order,Payment,Order-Status,Delivery,Stock-Level? What’s the number of transactions per minute?

Hi @haosifeng,

Thanks for your interest! There will be more details about our tools (and full reproduction instructions) published in a whitepaper coming soon, so look forward to that.

In the mean time, I’ll answer your questions briefly:

  1. They’re open-source tools, that we wrote. The source code is available in cockroachdb/cockroach, under pkg/workload/tpcc.
  2. Yes, the standard data models are used. The data model was not modified from the specification.
  3. Serializable. The tables have indexes.
  4. The proportion of the transactions are to specification. 43% of the txns are payments, 4% each are order status, delivery and stock level, and the rest (45%) are newOrders. The transactions per minute depend on the number of warehouses, but for all published results we achieve close to the maximum number of transactions per minute.

Thanks,
Jordan Lewis

1 Like

For people following along, the new blog post is here.