Is it feasible and meaningful to conduct stress testing on multi-table join queries in actual business scenarios?

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

Original topic: 在实际业务场景测试中,数据库的多表连接查询压测是可行、有意义的吗?

| username: TiDBer_mOiapMwy

[TiDB Usage Environment] Production Environment / Testing / PoC
[TiDB Version]
[Reproduction Path] In actual business scenario testing, is it feasible and meaningful to perform stress testing on multi-table join queries in the database?
[Encountered Issues: Problem Phenomenon and Impact] If feasible, what are the general stress testing methods?
[Resource Configuration]
[Attachments: Screenshots / Logs / Monitoring]

| username: zhanggame1 | Original post link

Whether it is meaningful depends on the business. Just prepare data tests based on actual business and data volume.

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

There shouldn’t be any ready-made solutions for this; it mainly depends on the actual business needs.

| username: 春风十里 | Original post link

In the process of using databases, multi-table join queries are very common. The optimization of multi-table join queries is an important key indicator to test a database optimizer. In the early days, MySQL’s performance with multi-table joins or subqueries was so poor that many enterprises required that only two tables could be joined, and three tables were not allowed. However, this greatly limited the usability of the database, forcing many query functions that could have been easily implemented by the database to be transferred to the application layer, significantly increasing the complexity of the application’s logic. To test multi-table joins independently, I am not sure if there are specialized tools available, but you can also test it yourself.

| username: cy6301567 | Original post link

Conduct stress testing based on business requirements.

| username: Jellybean | Original post link

Using the TiUP bench component to stress test TiDB, the subcommand tiup bench rawsql allows you to customize an SQL file as a workload for stress testing. You just need to replace the SQL here with your business SQL.

Official website:

| username: 春风十里 | Original post link

Thank you, I will try TiDB’s own benchmarking tool when I have time.

| username: system | Original post link

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