Question: Can sysbench be installed via tiup for TiDB stress testing? I only see tpcc and others

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

Original topic: 请教:TiDB压测,sysbench能通过tiup安装吗? 我看只有tpcc这些

| username: 超7成网友

As mentioned, I want to use sysbench to stress test TiDB. Can tiup install sysbench? I didn’t see it in the documentation.

| username: DBAER | Original post link

Generally, the stress testing tools are deployed independently. Just install one yourself.

| username: 友利奈绪 | Original post link

There are quite a few stress testing tools.

| username: stephanie | Original post link

You need to install sysbench yourself, and it is very easy to install.
akopytov/sysbench: Scriptable database and system performance benchmark (github.com)

| username: tidb菜鸟一只 | Original post link

You need to install it yourself, see here,
Column - Benchmarking MySQL and TiDB with Sysbench on Low Configuration and Low Data Basis, the Actual Results of TiDB Surprised Me. | TiDB Community

| username: onlyacat | Original post link

TiUP has a bench component, and tpcc can be installed and run directly, which generally meets the requirements. If you need to use sysbench additionally, you need to install it yourself.

tiup bench tpcc   # Use TPC-C as the workload for benchmarking
tiup bench tpch   # Use TPC-H as the workload for benchmarking
tiup bench ch     # Use CH-benCHmark as the workload for benchmarking
tiup bench ycsb   # Use YCSB as the workload for benchmarking
tiup bench rawsql # Use custom SQL files as the workload for benchmarking
| username: stephanie | Original post link

Thanks for sharing. I wasn’t aware of this bench component before. I can try using these components for stress testing now.

| username: TiDBer_HErMeXDz | Original post link

Independent installation of sysbench

| username: zhanggame1 | Original post link

Install sysbench yourself.

| username: 呢莫不爱吃鱼 | Original post link

Install sysbench yourself.

| username: ShawnYan | Original post link

It’s not impossible, but some preliminary steps are required.

It is recommended to use tiup bench for benchmarking.


Here are a few articles that you can refer to.

| username: Jellybean | Original post link

You can use tiup bench for benchmarking.

| username: 随缘天空 | Original post link

You can refer to the following article: https://juejin.cn/post/7264921418802462754

| username: TIDB-Learner | Original post link

There are many stress testing tools, find one that suits you.

| username: TiDBer_QYr0vohO | Original post link

sysbench can be installed by yourself.

| username: YuchongXU | Original post link

Deploy separately

| username: TiDBer_JUi6UvZm | Original post link

You can install sysbench to test TIDB yourself. It’s quite simple. Refer to: TiDB 性能测试(sysbench)_tidb性能测试-CSDN博客

| username: QH琉璃 | Original post link

There are many stress testing tools.

| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.