Seeking advice on which tool is most suitable for benchmarking TiDB

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

Original topic: 请教大家个问题,用什么工具对tidb进行压测比较合适

| username: zhang_2023

I would like to ask everyone a question, which tool is more suitable for stress testing TiDB?

| username: Kongdom | Original post link

You can directly use the official guides, the steps are detailed.

| username: 我是人间不清醒 | Original post link

We switched to TiDB and conducted performance testing using JMeter.

| username: zhanggame1 | Original post link

The official built-in tpcc

| username: wangccsy | Original post link

You can also download or write your own testing tools.

| username: Kongdom | Original post link

I don’t really recommend reinventing the wheel~ :yum:

| username: 托马斯滑板鞋 | Original post link

I suggest directly running with business data and business logic. Some may score very high but are not suitable for the business; some may be average but fit the business. :upside_down_face:

| username: TiDBer_小阿飞 | Original post link

For stress testing, it’s fine to use the official tools. After all, it can’t represent all aspects of the production environment; it’s just to get a general understanding and comparison of performance.

| username: TiDBer_jYQINSnf | Original post link

You can compare your sysbench test results with the official ones to understand the hardware gap.

| username: forever | Original post link

JMeter is more targeted, it can stress test the corresponding SQL or interface of the business.

| username: kelvin | Original post link

I suggest using the official one.

| username: Jayjlchen | Original post link

DBA students use tpcc and sysbench for stress testing; testing students use jmeter for stress testing.

| username: ShawnYan | Original post link

Check out tiup bench.

| username: 哈喽沃德 | Original post link

You can use the official one, or if you’re not confident, you can write a program yourself.

| username: Kongdom | Original post link

:flushed: Can JMeter still stress test the database? We only use it for interface testing. Is there any documentation related to stress testing the database?

| username: wluckdog | Original post link

We developed the app interface and then used JMeter for stress testing.

| username: Kongdom | Original post link

:flushed: Oh, so it’s still about stressing the interface. Got it.

| username: xingzhenxiang | Original post link

Using JMeter for stress testing the business is better, as it can directly obtain the desired data. Sysbench requires a comparison object for stress testing.

| username: yulei7633 | Original post link

How to Benchmark TiDB Using Sysbench

| username: 随缘天空 | Original post link

You can refer to the following link for sysbench: