TPC-C Stress Test

Translated
1

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: TPC-C压力测试

| username: 会飞的企鹅

【TiDB Usage Environment】Production Environment / Testing / PoC
【TiDB Version】
【Reproduction Path】What operations were performed when the issue occurred
【Encountered Issues: Issue Phenomenon and Impact】
【Resource Configuration】
【Attachments: Screenshots / Logs / Monitoring】
Dear experts, I am looking into TiDB stress testing related content and I don’t understand the TPC-C test results. What do Takes(s), Count: 32, TPM: 4.2, Sum(ms), Avg(ms), 90th(ms), 99th(ms), 99.9th(ms) represent?

image
image1179×250 11.4 KB

2
| username: magic | Original post link

takes: Time
tpm: Transactions per minute
count: Number of SQL executions
sum: Total SQL execution time
avg: Average SQL execution time
90, 99, 99.9: Percentile SQL execution time

3
| username: magic | Original post link

You can first conduct a sysbench test, specifically for single-table OLTP tests with tables that have fewer columns.

4
| username: leeray | Original post link

TPC-C is mainly for OLTP business testing. For performance stress testing, you should use sysbench.