Does TiDB have a testing tool like sqltest?

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

Original topic: tidb有sqltest这种测试工具吗

| username: TiDBer_U58GZgGJ

Is there something similar to mysqltest that can test the full range of SQL functionalities?

| username: zhaokede | Original post link

You can try Sysbench or HyBench.

| username: TiDBer_U58GZgGJ | Original post link

This can’t test the full range of SQL functionality, right?

| username: zhaokede | Original post link

It mainly depends on which items you want to test.

| username: 有猫万事足 | Original post link

TiDB is generally compatible with MySQL. I think if you want to use mysqltest, you can use it directly.

Apart from potential issues related to MySQL compatibility, there shouldn’t be major problems. You might as well give it a try first and address any issues as they arise.

| username: TIDB-Learner | Original post link

The testing tools should be compatible with MySQL. That is, the TiDB testing strategy needs to be more in-depth.

| username: TiDBer_tvqzG8Dk | Original post link

Sysbench

| username: tidb狂热爱好者 | Original post link

There are official tutorials.

| username: 濱崎悟空 | Original post link

Take a look at sysbench.

| username: TiDBer_tvqzG8Dk | Original post link

Sysbench

| username: tidb狂热爱好者 | Original post link

TiUP comes with it.

| username: kevinsna | Original post link

Sysbench and TPC-C

| username: residentevil | Original post link

Do you need to test all the syntax features of MySQL?

| username: YuchongXU | Original post link

Only benchmarking tools

| username: wangcw | Original post link

HammerDB is also quite useful, with standard TPCC, you don’t even need to prepare the data yourself.

| username: Soysauce520 | Original post link

Official benchmarking tools for TPC-C and TPC-H

| username: residentevil | Original post link

My personal suggestion is that you might as well write a stress testing tool directly and conduct stress testing using the full MySQL logs from your business. This way, the data will be more accurate.

| username: TiDBer_gtlKoEAZ | Original post link

Only benchmarking tools